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. -- Mailing list: https://launchpad.net/~openupgrade-drivers Post to : [email protected] Unsubscribe : https://launchpad.net/~openupgrade-drivers More help : https://help.launchpad.net/ListHelp
