Odoo 12 CE - query error when trying to save in website HTML/CSS-Editor

error query website_builder v12

5 ตอบกลับ

8704 มุมมอง

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

Tommy Lo

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

Raheem Azeez

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.

HT Electronics

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.

Ermin Trevisan

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

Lars Gaertner

ผู้เขียน

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

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
How to Fix RPC_ERROR/ ODOO SERVER ERROR error website_builder	0 เม.ย. 24	5315
How to Fix RPC_ERROR/ ODOO SERVER ERROR/TRACEBACK แก้ไขแล้ว error website_builder	3 มี.ค. 26	10823
UncaughtPromiseError in V18.4 website error website_builder V18.4	2 ก.ย. 25	2099
How to resolve <UncaughtPromiseError> error website_builder v17	1 มิ.ย. 23	11082
v12 - I get an error when I click HTML/CSS editor. error customize website_builder	0 ก.ย. 21	4024

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!