Odoo Help


UPDATE XML architecture via PostgreSQL query

Yassine TEIMI
on 11/17/14, 10:17 AM 1,583 views

When we want to access views via web client, we go into : Configuration/Technical/User interface/Views.

We select the desired view, in my case : res.users.form and we have Architecture Tab, containing the XML Code, wich we can modify.

I no longer have this possibility, because I'm unable to connect to my openerp account via the web client.

So I decided to do it by accessing the table ir_ui_views containing all the views, via postgresql, and modify the XML architecture via SQL Query.

I am right know connected to my desired database, on shell, and my question is : 

What is the SQL query to perform ? 

@yassine why do you want to change the view at the database end. Is it that due to any view the client is not starting? If yes, and if you know which view is the culprit then just remove that view from the '__openerp__.py' file and restart the server. This may start your client.

Emipro Technologies Pvt. Ltd.
on 11/17/14, 12:35 PM

I am unable to connect top my openerp account, because of the XML architecture error, the fact is I deleted a custom field from user interface, via the configuration module, and not from the view, so when he looks for the field from the XML architecture he doesn't find it. The Probleme is that when we add a custom field from the debugger mode ( User interface ), it loads the view from the database, and not from the source code, the view from the openerp file does not contain the custom field that I added, so I dont' have any point of access apart of the database.

Yassine TEIMI
on 11/17/14, 1:00 PM

I removed the view from the openerp.py file, same probleme ..., the server loads always the XML code on the database ...

Yassine TEIMI
on 11/17/14, 1:01 PM

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

2 follower(s)


Asked: 11/17/14, 10:17 AM
Seen: 1583 times
Last updated: 3/16/15, 8:10 AM