Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
โปรเจกต์
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

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

error query website_builder v12

5 ตอบกลับ

7793 มุมมอง

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.

JPK Consulting

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	3764
How to Fix RPC_ERROR/ ODOO SERVER ERROR/TRACEBACK error website_builder	3 ส.ค. 24	9040
UncaughtPromiseError in V18.4 website error website_builder V18.4	2 ก.ย. 25	1051
How to resolve <UncaughtPromiseError> error website_builder v17	1 มิ.ย. 23	9538
v12 - I get an error when I click HTML/CSS editor. error customize website_builder	0 ก.ย. 21	3251

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

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