Odoo Help


((HELP-my OpenERP is almost down!)) How to change 'Admin' user's language from code|Database? not GUI

Karolin Ar.
on 2/4/15, 12:47 AM 1,184 views


I have uploaded a language (name:Test1) in ERP& my language's captions were just for CRM module, not all modules.(forgotten to check 'overwrite' option)

I chose 'Test1' lang for Admin user, my page refreshed and after that I have no GUI in screen!!

I have no access to OpenERP now. I cant change the lang setting for Admin user, cause Other users have not Administrator privilege!.

How Can I reset Admin's lang to en-US lang?! How can I do it!!




Ludo - 21South

--Ludo - 21South--
| 2 2 5
Zwijndrecht, Netherlands
--Ludo - 21South--


Ludo - 21South
On 2/4/15, 6:23 AM
  1. Open up psql (or pg_admin3 or similair) and connect to your database
  2. Lookup the id and partner_id for user administrator in res_users table
  3. Use partner_id to find the partner attached to administrator user in res_partner table
  4. Run query: "update res_partner set lang = 'en_US' where id = $your_partner_id_here;"


Should do the trick.

Thank you so much.

Karolin Ar.
on 2/5/15, 2:58 AM

i've removed the translated 'lang' from ir_translations and from res_lang . and changed the (res_patner) user lang to en US, but still my admin page does not loading.!!! Please advice.

Karolin Ar.
on 2/5/15, 4:12 AM

Have you tried updating the database with the "-u all" flag on the command line? That will reinitialise the modules and perhaps restore the translations. Furthermore, check the log files for any inconstancy. It is really difficult to debug for anyone if you don't have error log.

21south, Ludo - 21South
on 2/5/15, 4:22 AM

I used the 'refresh' button in phAdmin3 GUI. I guessed it too, and for making sure about the changes i've changed the name of one user and stop-start erp.. The user's name was changed!! but still my admin lang didnt updated!!

Karolin Ar.
on 2/5/15, 4:48 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 2/4/15, 12:47 AM
Seen: 1184 times
Last updated: 3/16/15, 8:10 AM