Skip to Content
This question has been flagged
languagepostgresqlchangebug
2 Replies
5370 Views
Avatar
Sanjin Šarić

Hi,

I imported language (in my case Bosnian). And I changed in the preference tab for administrator. After that something crazy happened. I get the picture below. Anything I click doesn't do anything. And I cannot change the lanugage back because admin is only user on my server that can change language for others. Now my admin is stuck like this.

http://pokit.org/get/?6db2ee042e9c1ec88ba0ee6217445a0c.jpg

I am hereby asking you to tell me where this is setting written for a user. Like what table in PostgreSQL database?

The only way to change it back to English is to manually change it in database (i see no other way).

Avatar
Discard
Avatar
Michael Thomas
Best Answer

It is a good idea to always backup your server before making a major change. I use a virtual server with Altaro Hyper-V backup (free for up to 2 servers), so my backups just take a few minutes. 

That said, I believe the table you are looking for is res_partner and the field is "lang". I only use English but the value in mine is "en_US". 

Avatar
Discard
Avatar
Sanjin Šarić
Author Best Answer

Thank you Michael, that was the right table, I manually changed it and fixed it. I will do that with server backup asap. I didn't think of it because I am still tinkering around with odoo and setting it up.

Note to others:

If you do encounter any problem like this, odoo keeps all its settings in that postgreSQL database. Its only a matter of table when you will find that setting you are looking for.

Avatar
Discard
Ermin Trevisan

But sometimes it is just too difficult to fix things in the database because of the complexity of the relational ORM. I, for example, did install the Blogs_Private module, which messed up the access rights of the blog user and it would probably take me days to fix it in the database. So I had to change the email address of the corrupt user and then create a new user with the old email address, something which could be dangerous in a system in full production mode. A note to you: never change the admin user (except the password). Create a new technical user, when you need it in another language.

Related Posts Replies Views Activity
Some Langauge Text is not displaying properly while install langauge.
language ui bug
Avatar
Avatar
1
Dec 19
3637
Odoo language change error 16?
language menu change odoo16features
Avatar
Avatar
1
Jul 23
3768
Odoo bug?
postgresql chat bug longpolling
Avatar
0
Jul 21
5323
Frontend codec bug swedish language ö ä etc. Solved
language translation bug codec
Avatar
1
Mar 21
3841
Change date format does not work
language date bug odooV8
Avatar
0
Oct 15
4502