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 Belhadj · 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

Gerelateerde posts	Antwoorden	Weergaven
In Failed SQL Transaction postgresql psycopg2	1 sep. 21	5168
Error at connect to an external postgres postgresql psycopg2 OdooSH	1 jul. 25	2371
while creating database aws ubuntu server odoo17 database postgresql v17	1 jun. 24	2851
PostgreSQL port do not match psycopg2 default port Opgelost postgresql port psycopg2	2 apr. 24	11539
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 jan. 24	3229

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!