← Back to team overview

openupgrade-drivers team mailing list archive

Re: [Question #264133]: V7->V8: IntegrityError: foreign key constraint

 

Question #264133 on OpenUpgrade Addons changed:
https://answers.launchpad.net/openupgrade-addons/+question/264133

    Status: Open => Answered

Manuel Vazquez Acosta proposed the following answer:
Try this:

1. Remove the view with id 345 in ir_ui_view in CASCADE and also remove
from ir_module_data any row with res_model='ir.ui.view' and a res_id not
found in the ir_ui_view table.

2. Update your 7.0 DB normally (with openerp and not openupgrade).  This
should recreate the removed views.

3. Upgrade with OpenUpgrade.


If the error still happens report this a github.com.

Best regards,
Manuel.


Le 24/03/15 14:41, Vuong Pham a écrit :
> New question #264133 on OpenUpgrade Addons:
> https://answers.launchpad.net/openupgrade-addons/+question/264133
>
> I'm trying to migrate from OpenERP 7 to Odoo 8. And I'm stuck at this step. Please help me to proceed. Thank you so much!
>
> 2015-03-24 18:23:20,430 13916 INFO Db_migrated OpenUpgrade: Selecting autoinstallable modules im_chat
> 2015-03-24 18:23:24,162 13916 INFO Db_migrated OpenUpgrade: Selecting autoinstallable modules im_odoo_support
> 2015-03-24 18:23:40,250 13916 ERROR Db_migrated openerp.sql_db: bad query: delete from ir_ui_view where id IN (345)
> Traceback (most recent call last):
>   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
>     res = self._obj.execute(query, params)
> IntegrityError: 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)=(345) is still referenced from table "ir_ui_view".
>

-- 
You received this question notification because you are a member of
OpenUpgrade Drivers, which is an answer contact for OpenUpgrade Addons.