Odoo Help

Welcome!

This community 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.

0

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

By
Karolin Ar.
on 2/4/15, 12:47 AM 816 views

Hi,

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!!

 

Thanks,Parelli

1

Ludo - Neobis

--Ludo - Neobis--
2387
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--

Developer

Ludo - Neobis
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.

Ludo - Neobis
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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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