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	4403
Error at connect to an external postgres postgresql psycopg2 OdooSH	1 7月 25	1490
while creating database aws ubuntu server odoo17 database postgresql v17	1 6月 24	1998
PostgreSQL port do not match psycopg2 default port 解決済 postgresql port psycopg2	2 4月 24	10690
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	2300

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！