openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #02781
[Bug 903474] [NEW] error "ir_ui_menu" violates foreign key constraint "res_portal_parent_menu_id_fkey" on table "res_portal"
Public bug reported:
I have installed portal and get the error
delete from
ir_ui_menu
where
(id not IN (select parent_id from ir_ui_menu where parent_id is not null))
and
(id not IN (select res_id from ir_values where model='ir.ui.menu'))
and
(id not IN (select res_id from ir_model_data where model='ir.ui.menu'))
Traceback (most recent call last):
File "/home/srv/openerp/instances/trunk/openobject-server/openerp/sql_db.py", line 215, in execute
res = self._obj.execute(query, params)
IntegrityError: update or delete on table "ir_ui_menu" violates foreign key constraint "res_portal_parent_menu_id_fkey" on table "res_portal"
DETAIL: Key (id)=(720) is still referenced from table "res_portal".
** Affects: openobject-addons
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/903474
Title:
error "ir_ui_menu" violates foreign key constraint
"res_portal_parent_menu_id_fkey" on table "res_portal"
Status in OpenERP Addons (modules):
New
Bug description:
I have installed portal and get the error
delete from
ir_ui_menu
where
(id not IN (select parent_id from ir_ui_menu where parent_id is not null))
and
(id not IN (select res_id from ir_values where model='ir.ui.menu'))
and
(id not IN (select res_id from ir_model_data where model='ir.ui.menu'))
Traceback (most recent call last):
File "/home/srv/openerp/instances/trunk/openobject-server/openerp/sql_db.py", line 215, in execute
res = self._obj.execute(query, params)
IntegrityError: update or delete on table "ir_ui_menu" violates foreign key constraint "res_portal_parent_menu_id_fkey" on table "res_portal"
DETAIL: Key (id)=(720) is still referenced from table "res_portal".
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/903474/+subscriptions
Follow ups
References