Skip to Content
This question has been flagged
languagepostgresqlchangebug
2 Replies
6445 Rodiniai
Portretas
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).

Portretas
Atmesti
Portretas
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". 

Portretas
Atmesti
Portretas
Sanjin Šarić
Autorius 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.

Portretas
Atmesti
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 Rodiniai Veikla
Some Langauge Text is not displaying properly while install langauge.
language ui bug
Portretas
Portretas
1
gruod. 19
4492
Odoo language change error 16?
language menu change odoo16features
Portretas
Portretas
1
liep. 23
4797
Odoo bug?
postgresql chat bug longpolling
Portretas
0
liep. 21
6335
Frontend codec bug swedish language ö ä etc. Solved
language translation bug codec
Portretas
1
kov. 21
4764
Change date format does not work
language date bug odooV8
Portretas
0
spal. 15
5699