credativ team mailing list archive

["Ferdinand @ Camptocamp" <903474@xxxxxxxxxxxxxxxxxx>]

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

-- 
You received this bug notification because you are a member of OpenERP
Framework Experts, 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