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

UPDATE XML architecture via PostgreSQL query

By
Yassine TEIMI
on 11/17/14, 10:17 AM 1,084 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

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

2 follower(s)

Stats

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