{"action":"created","issue":{"url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/issues/283","labels_url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/issues/283/labels{/name}","comments_url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/issues/283/comments","events_url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/issues/283/events","html_url":"https://github.com/OpenUpgrade/OpenUpgrade/issues/283","id":70357215,"number":283,"title":"Errors migrating from 7 to 8","user":{"login":"javierobcn","id":1226690,"avatar_url":"https://avatars.githubusercontent.com/u/1226690?v=3","gravatar_id":"","url":"https://api.github.com/users/javierobcn","html_url":"https://github.com/javierobcn","followers_url":"https://api.github.com/users/javierobcn/followers","following_url":"https://api.github.com/users/javierobcn/following{/other_user}","gists_url":"https://api.github.com/users/javierobcn/gists{/gist_id}","starred_url":"https://api.github.com/users/javierobcn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/javierobcn/subscriptions","organizations_url":"https://api.github.com/users/javierobcn/orgs","repos_url":"https://api.github.com/users/javierobcn/repos","events_url":"https://api.github.com/users/javierobcn/events{/privacy}","received_events_url":"https://api.github.com/users/javierobcn/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-04-23T09:20:34Z","updated_at":"2015-04-23T14:37:00Z","closed_at":null,"body":"Hello, I'm stuck some days with the following error, any ideas are very welcome:\r\n\r\nFirst error i obtain is:\r\nInvalid value 'tree_account_reconciliation' in the table 'ir_ui_view' for the field 'type'. (1 rows).\r\n\r\nthen, later:\r\n\r\n2015-04-22 18:16:53,850 10492 ERROR db_prod_migrated OpenUpgrade: Invalid value 'email' in the model 'ir_actions_server' for the field 'state'. (id 568).Please overload the new ir_actions_server._get_state function.\r\n2015-04-22 18:16:53,850 10492 ERROR db_prod_migrated OpenUpgrade: Invalid value 'email' in the model 'ir_actions_server' for the field 'state'. (id 601).Please overload the new ir_actions_server._get_state function.\r\n\r\nAnd later:\r\n\r\n2015-04-22 18:18:51,634 10492 ERROR db_prod_migrated openerp.sql_db: bad query: ALTER TABLE \"stock_picking\" ALTER COLUMN \"picking_type_id\" SET NOT NULL\r\nTraceback (most recent call last):\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\nIntegrityError: column \"picking_type_id\" contains null values\r\n\r\n2015-04-22 18:18:51,636 10492 WARNING db_prod_migrated openerp.models: WARNING: unable to set column picking_type_id of table stock_picking not null !\r\nTry to re-run: openerp-server --update=module\r\nIf it doesn't work, update records and execute manually:\r\nALTER TABLE stock_picking ALTER COLUMN picking_type_id SET NOT NULL\r\nTraceback (most recent call last):\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/models.py\", line 2658, in _auto_init\r\n    cr.execute('ALTER TABLE \"%s\" ALTER COLUMN \"%s\" SET NOT NULL' % (self._table, k))\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\nIntegrityError: column \"picking_type_id\" contains null values\r\n\r\nAnd this:\r\n\r\n\r\n2015-04-22 18:19:41,354 10492 INFO db_prod_migrated OpenUpgrade: table stock_picking, column sale_id: renaming to openupgrade_legacy_8_0_sale_id\r\n2015-04-22 18:19:41,355 10492 ERROR db_prod_migrated openerp.sql_db: Programming error: column \"sale_id\" does not exist\r\n, in query ALTER TABLE \"stock_picking\" RENAME \"sale_id\" TO \"openupgrade_legacy_8_0_sale_id\"\r\n2015-04-22 18:19:41,355 10492 ERROR db_prod_migrated OpenUpgrade: sale_stock: error in migration script /var/tmp/openupgrade/8.0/addons/sale_stock/migrations/8.0.1.0/pr$\r\n\r\nFinally:\r\n\r\n2015-04-22 18:19:41,355 10492 ERROR db_prod_migrated OpenUpgrade: column \"sale_id\" does not exist\r\nTraceback (most recent call last):\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/openupgrade/openupgrade.py\", line 805, in wrapped_function\r\n    func(cr, version)\r\n  File \"/var/tmp/openupgrade/8.0/addons/sale_stock/migrations/8.0.1.0/pre-migration.py\", line 33, in migrate\r\n    openupgrade.rename_columns(cr, column_renames)\r\n  File \"/var/tmp/openupgrade/8.0/server/openerp/openupgrade/openupgrade.py\", line 194, in rename_columns\r\n    'ALTER TABLE \"%s\" RENAME \"%s\" TO \"%s\"' % (table, old, new,))\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: column \"sale_id\" does not exist\r\n\r\n\r\nThanks for your time and for this project"},"comment":{"url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/issues/comments/95607878","html_url":"https://github.com/OpenUpgrade/OpenUpgrade/issues/283#issuecomment-95607878","issue_url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/issues/283","id":95607878,"user":{"login":"o-w","id":4641703,"avatar_url":"https://avatars.githubusercontent.com/u/4641703?v=3","gravatar_id":"","url":"https://api.github.com/users/o-w","html_url":"https://github.com/o-w","followers_url":"https://api.github.com/users/o-w/followers","following_url":"https://api.github.com/users/o-w/following{/other_user}","gists_url":"https://api.github.com/users/o-w/gists{/gist_id}","starred_url":"https://api.github.com/users/o-w/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/o-w/subscriptions","organizations_url":"https://api.github.com/users/o-w/orgs","repos_url":"https://api.github.com/users/o-w/repos","events_url":"https://api.github.com/users/o-w/events{/privacy}","received_events_url":"https://api.github.com/users/o-w/received_events","type":"User","site_admin":false},"created_at":"2015-04-23T14:37:00Z","updated_at":"2015-04-23T14:37:00Z","body":"Regarding the \"tree_account_reconciliation\" error ->\r\nhttps://github.com/OpenUpgrade/OpenUpgrade/issues/220"}}