Odoo Addons (MOVED TO GITHUB)

error "ir_ui_menu" violates foreign key constraint "res_portal_parent_menu_id_fkey" on table "res_portal"

Bug #903474 reported by Ferdinand on 2011-12-12

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Odoo Addons (MOVED TO GITHUB)	Fix Released	Low	OpenERP R&D Addons Team 1

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".

Related branches

lp:~openerp-dev/openobject-addons/trunk-bug-903474-kjo

Merged into lp:openobject-addons at revision 6270

Thibault Delavallée (OpenERP) (community): Approve on 2012-01-05

Kuldeep Joshi(OpenERP) (community): Needs Resubmitting on 2011-12-20

Bhumika Shrimali (community): Needs Fixing on 2011-12-19

Revision history for this message

Jignesh Rathod(OpenERP) (jir-openerp) wrote on 2011-12-13:

Hello Dr. Ferdinand ,

I have checked this issue with trunk but I did not face any
Trace back at my end so would you please check it again
and provide a more information regarding this issue.

Thanks and waiting for replay.

Changed in openobject-addons:
status:	New → Incomplete

Revision history for this message

Ferdinand (office-chricar) wrote on 2011-12-13:

select * from res_portal;
id | create_uid | create_date | write_date | write_uid | url | menu_action_id | group_id | parent_menu_id
----+------------+----------------------------+----------------------------+-----------+-----------------------------+----------------+----------+----------------
2 | 1 | 2011-12-11 22:16:53.735274 | 2011-12-12 07:09:18.077708 | 1 | http://192.168.160.136:8169 | | 88 | 720

there is an entry in res_portal
imho the sql statement must also check for parent_menu_id in res_portal, then it will not raise an error.

Changed in openobject-addons:
status:	Incomplete → New

Revision history for this message

Jignesh Rathod(OpenERP) (jir-openerp) wrote on 2011-12-13:

Portal.ogv Edit (8.8 MiB, video/ogg)

Changed in openobject-addons:
assignee:	nobody → OpenERP R&D Addons Team 1 (openerp-dev-addons1)
importance:	Undecided → Low
status:	New → Confirmed

Kuldeep Joshi(OpenERP) (kjo-openerp) on 2011-12-14

Changed in openobject-addons:
status:	Confirmed → In Progress

Revision history for this message

Kuldeep Joshi(OpenERP) (kjo-openerp) wrote on 2011-12-15:

Hello, Thanks For Reporting.
It has been Fixed in https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-903474-kjo
revision-id: <email address hidden>
revno: 5970
It will be available in trunk soon.