{"action":"created","issue":{"url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/431","repository_url":"https://api.github.com/repos/OCA/OpenUpgrade","labels_url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/431/labels{/name}","comments_url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/431/comments","events_url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/431/events","html_url":"https://github.com/OCA/OpenUpgrade/issues/431","id":129784899,"number":431,"title":"Error migration openerp 7 to odoo 8.0 ","user":{"login":"vm50","id":16958487,"avatar_url":"https://avatars.githubusercontent.com/u/16958487?v=3","gravatar_id":"","url":"https://api.github.com/users/vm50","html_url":"https://github.com/vm50","followers_url":"https://api.github.com/users/vm50/followers","following_url":"https://api.github.com/users/vm50/following{/other_user}","gists_url":"https://api.github.com/users/vm50/gists{/gist_id}","starred_url":"https://api.github.com/users/vm50/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vm50/subscriptions","organizations_url":"https://api.github.com/users/vm50/orgs","repos_url":"https://api.github.com/users/vm50/repos","events_url":"https://api.github.com/users/vm50/events{/privacy}","received_events_url":"https://api.github.com/users/vm50/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":13,"created_at":"2016-01-29T14:44:54Z","updated_at":"2016-02-05T07:42:43Z","closed_at":null,"body":"Hello ,\r\n\r\nBy migrating openerp 7 to 8.0 I get the following error. I do not see many or it may come.\r\nInformation the database isn't run on the Odoo Server\r\nDo you have an idea ?\r\n\r\nThank you\r\n\r\n\r\n2016-01-29 14:15:35,043 32600 INFO bdd_migrated OpenUpgrade: table crm_case_channel_id_seq: renaming to crm_tracking_medium_id_seq\r\n2016-01-29 14:15:35,043 32600 INFO bdd_migrated OpenUpgrade: table crm_case_resource_type_id_seq: renaming to crm_tracking_campaign_id_seq\r\n2016-01-29 14:15:35,044 32600 ERROR bdd_migrated openerp.sql_db: Programming error: syntax error at or near \"EXISTS\"\r\nLINE 1: ALTER TABLE crm_lead DROP CONSTRAINT IF EXISTS crm_lead_chan...\r\n                                                ^\r\n, in query ALTER TABLE crm_lead DROP CONSTRAINT IF EXISTS crm_lead_channel_id_fkey\r\n2016-01-29 14:15:35,044 32600 ERROR bdd_migrated OpenUpgrade: crm: error in migration script /var/tmp/openupgrade/8.0/addons/crm/migrations/8.0.1.0/pre-migration.py: syntax error at or near \"EXISTS\"\r\nLINE 1: ALTER TABLE crm_lead DROP CONSTRAINT IF EXISTS crm_lead_chan...\r\n                                                ^\r\n\r\n2016-01-29 14:15:35,044 32600 ERROR bdd_migrated OpenUpgrade: syntax error at or near \"EXISTS\"\r\nLINE 1: ALTER TABLE crm_lead DROP CONSTRAINT IF EXISTS crm_lead_chan...\r\n                                                ^\r\nTraceback (most recent call last):\r\n  File \"/var/tmp/openupgrade/openupgradelib/openupgradelib/openupgrade.py\", line 948, in wrapped_function\r\n    func(cr, version)\r\n  File \"/var/tmp/openupgrade/8.0/addons/crm/migrations/8.0.1.0/pre-migration.py\", line 62, in migrate\r\n    constraint))\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/sql_db.py\", line 158, in wrapper\r\n    return f(self, *args, **kwargs)\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/sql_db.py\", line 234, in execute\r\n    res = self._obj.execute(query, params)\r\nProgrammingError: syntax error at or near \"EXISTS\"\r\nLINE 1: ALTER TABLE crm_lead DROP CONSTRAINT IF EXISTS crm_lead_chan...\r\n                                                ^\r\n\r\n2016-01-29 14:15:35,045 32600 CRITICAL bdd_migrated openerp.service.server: Failed to initialize database `bdd_migrated`.\r\nTraceback (most recent call last):\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/service/server.py\", line 929, in preload_registries\r\n    registry = RegistryManager.new(dbname, update_module=update_module)\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/modules/registry.py\", line 370, in new\r\n    openerp.modules.load_modules(registry._db, force_demo, status, update_module)\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/modules/loading.py\", line 394, in load_modules\r\n    force, status, report, loaded_modules, update_module, upg_registry)\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/modules/loading.py\", line 286, in load_marked_modules\r\n    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks, upg_registry=upg_registry)\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/modules/loading.py\", line 156, in load_module_graph\r\n    migrations.migrate_module(package, 'pre')\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/modules/migration.py\", line 179, in migrate_module\r\n    mod.migrate(self.cr, pkg.installed_version)\r\n  File \"/var/tmp/openupgrade/openupgradelib/openupgradelib/openupgrade.py\", line 948, in wrapped_function\r\n    func(cr, version)\r\n  File \"/var/tmp/openupgrade/8.0/addons/crm/migrations/8.0.1.0/pre-migration.py\", line 62, in migrate\r\n    constraint))\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/sql_db.py\", line 158, in wrapper\r\n    return f(self, *args, **kwargs)\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/sql_db.py\", line 234, in execute\r\n    res = self._obj.execute(query, params)\r\nProgrammingError: syntax error at or near \"EXISTS\"\r\nLINE 1: ALTER TABLE crm_lead DROP CONSTRAINT IF EXISTS crm_lead_chan...\r\n                                                ^\r\n\r\n2016-01-29 14:15:35,045 32600 INFO bdd_migrated openerp.service.server: Initiating shutdown\r\n2016-01-29 14:15:35,045 32600 INFO bdd_migrated openerp.service.server: Hit CTRL-C again or send a second signal to force the shutdown."},"comment":{"url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/comments/180238857","html_url":"https://github.com/OCA/OpenUpgrade/issues/431#issuecomment-180238857","issue_url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/431","id":180238857,"user":{"login":"StefanRijnhart","id":1033124,"avatar_url":"https://avatars.githubusercontent.com/u/1033124?v=3","gravatar_id":"","url":"https://api.github.com/users/StefanRijnhart","html_url":"https://github.com/StefanRijnhart","followers_url":"https://api.github.com/users/StefanRijnhart/followers","following_url":"https://api.github.com/users/StefanRijnhart/following{/other_user}","gists_url":"https://api.github.com/users/StefanRijnhart/gists{/gist_id}","starred_url":"https://api.github.com/users/StefanRijnhart/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/StefanRijnhart/subscriptions","organizations_url":"https://api.github.com/users/StefanRijnhart/orgs","repos_url":"https://api.github.com/users/StefanRijnhart/repos","events_url":"https://api.github.com/users/StefanRijnhart/events{/privacy}","received_events_url":"https://api.github.com/users/StefanRijnhart/received_events","type":"User","site_admin":false},"created_at":"2016-02-05T07:42:43Z","updated_at":"2016-02-05T07:42:43Z","body":"Is it maybe the case that you have procurement installed in 7.0 but not stock? That may not be supported. In that case, try installing stock in 7.0 before migration."}}