openupgrade-drivers team mailing list archive

[Manuel Vazquez Acosta <question264133@xxxxxxxxxxxxxxxxxxxxx>]

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

Manuel Vazquez Acosta proposed the following answer:

I did what I suggested cause I get the same problem.  So I went:

psql -d mercurio8 -c "DELETE FROM ir_ui_view where id=272 or inherit_id=272"
psql -d mercurio8 -c "DELETE FROM ir_model_data WHERE model='ir.ui.view'
AND res_id NOT IN(SELECT id FROM ir_ui_view)"

Then I ran the upgrade and it went ok.

Bests,
Manuel.

PD:  Replace my ids in the first query with yours.

Le 26/03/15 12:47, Manuel Vázquez Acosta a écrit :
> 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.