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

CRM
e-Commerce
Бухгалтерия
Склад
PoS
Проекты
MRP

All apps

Все посты Люди Значки

Теги (Смотреть все)

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 Ответы

7695 Представления

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.

Не оставайтесь в стороне – присоединяйтесь к обсуждению!

Создайте аккаунт сегодня, чтобы получить доступ к эксклюзивным функциям и стать частью нашего замечательного сообщества!

Регистрация

Похожие посты	Ответы	Просмотры
How to Fix RPC_ERROR/ ODOO SERVER ERROR error website_builder	0 апр. 24	3524
How to Fix RPC_ERROR/ ODOO SERVER ERROR/TRACEBACK error website_builder	3 авг. 24	8703
UncaughtPromiseError in V18.4 website error website_builder V18.4	2 сент. 25	889
How to resolve <UncaughtPromiseError> error website_builder v17	1 июн. 23	9331
v12 - I get an error when I click HTML/CSS editor. error customize website_builder	0 сент. 21	3169

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!