openupgrade-drivers team mailing list archive
-
openupgrade-drivers team
-
Mailing list archive
-
Message #00466
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.