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 سبتمبر 21	4379
Error at connect to an external postgres postgresql psycopg2 OdooSH	1 يوليو 25	1473
while creating database aws ubuntu server odoo17 database postgresql v17	1 يونيو 24	1979
PostgreSQL port do not match psycopg2 default port تم الحل postgresql port psycopg2	2 أبريل 24	10673
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 يناير 24	2273

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!