Skip to Content
This question has been flagged
errorquerywebsite_builderv12
5 Replies
5685 Views
Avatar
Lars Gaertner

Hello,

I am working on my website and have some problems to save several HTML modifications using the website module.

E.g. I am working on website_blog.blog_post_short, but as soon as I try to save a (valid) modification, I get the following error message:

A server error occured. Please check you correctly signed in and that the file you are saving is correctly formatted.
[object Object]


In the server logfile I do find the following:

2019-02-14 14:16:45,519 19530 ERROR xmp odoo.sql_db: bad query: b'DELETE FROM ir_ui_view WHERE id IN (1392)'
ERROR: update or delete on table "ir_ui_view" violates foreign key constraint "ir_ui_view_inherit_id_fkey" on table "ir_ui_view"
DETAIL:  Key (id)=(1392) is still referenced from table "ir_ui_view".

Can anybody help me?

I am using the latest github-state of Odoo 12.

Thanks in advance.

Lars

Avatar
Discard
Tom Lanbacher

Hi Lars, I have the same problem here, ... no solution found so far

Avatar
Raheem Azeez
Best Answer

I had the same problem and I couldn't get it resolved with the HTML Editor of the website. However, I was able to do it by going to the backend.

Log in to the database and activate Developer Mode, then go to "Settings" -> "Technical" -> "User Interface" -> "Views". Then, type "Products" in the search field and select "Search View For: Products".

Then, look for and click on the result that has "website_sale.products" under the "External ID" column. Thereafter, you can edit the qweb form and save it. The changes you make should reflect on your web page.

 Hope this solves the problem.


Avatar
Discard
Avatar
JPK Consulting
Best Answer

I have the same problem here when updating SEO information. It would be great if somebody give some clues on how to solve this. I don't know where to start. 

Avatar
Discard
Avatar
Ermin Trevisan
Best Answer

You try to delete a view, which is still referenced. You can not proceed before you have solved this error.

Avatar
Discard
Lars Gaertner
Author

I did not ever try do delete any view. I just tried to save my HTML modifications, as described.

Related Posts Replies Views Activity
How to Fix RPC_ERROR/ ODOO SERVER ERROR
error website_builder
Avatar
0
Apr 24
708
How to Fix RPC_ERROR/ ODOO SERVER ERROR/TRACEBACK
error website_builder
Avatar
Avatar
Avatar
Avatar
3
Aug 24
2922
How to resolve <UncaughtPromiseError>
error website_builder v17
Avatar
Avatar
1
Jun 23
4868
v12 - I get an error when I click HTML/CSS editor.
error customize website_builder
Avatar
0
Sep 21
1371
[Odoo16] ERROR: could not serialize access due to concurrent update
community error query odoo16features
Avatar
1
Sep 24
1059