odoo 17 setup encoding error

Question

I am trying to get the odoo local host server to work. i am getting the error as*: UnicodeDecodeError: 'utf-8' codec can't decode byte 0xfc in position 97: invalid start byte.*
The pre installations are already done the postgres, pgadmin, newest python version. i am using pycharm in windows. i think the erros is due to the psycopg2 wiht the postgres server. any one had the same issue??

Abdou · Accepted Answer

I'm pretty sure the issue is due to the browser cache. Try opening it in a private/incognito window to confirm.

mer5 · Answer

i think the issue in the postgres user try to alter role utf8 to user by the below (run it from psql shell)
ALTER ROLE user SET client_encoding TO 'utf8';
change user with your postgres user

Cesar García · Answer

I'm setting up odoo 18 on localhost and I encountered this error. Your solution worked very well for me. Thank you!

Friedrich Sauer · Answer

There was no easy fix. It seems that running the odoo server locally in windows is a huge gamble, dependency-version-wise.

Therefore I am using wsl now at the tradeoff of slightly worse PyCharm integration.
This Video was great help:  https://www.youtube.com/watch?v=4wpaTRaOwJo [1]

Best

[1] https://www.youtube.com/watch?v=4wpaTRaOwJo

相关帖文	回复	查看
In Failed SQL Transaction postgresql psycopg2	1 9月 21	4265
Error at connect to an external postgres postgresql psycopg2 OdooSH	1 7月 25	1371
while creating database aws ubuntu server odoo17 database postgresql v17	1 6月 24	1836
PostgreSQL port do not match psycopg2 default port 已解决 postgresql port psycopg2	2 4月 24	10529
Following the Odoo 17 installation guide when I run the command sudo -u postgres createuser -d -R -S $USER I get the message could not change directory to "/home/odoo": Access denied installation postgresql v17 ubuntu22.04	0 1月 24	2110

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！