credativ team mailing list archive

[Yann Papouin <yann.papouin@xxxxxxxxx>]

** Branch linked: lp:~yann-papouin/openupgrade-
addons/7.0-bug-1318686-project

** Changed in: openupgrade-addons
       Status: New => Fix Committed

-- 
You received this bug notification because you are a member of
OpenUpgrade Committers, which is subscribed to OpenUpgrade Addons.
https://bugs.launchpad.net/bugs/1318686

Title:
  [7.0] ProgrammingError when migrating project

Status in OpenUpgrade Addons:
  Fix Committed

Bug description:
  2014-05-12 12:27:26,334 5448 INFO dec_database openerp.modules.migration: module project: Running migration [>7.0.1.1] pre-migration
  2014-05-12 12:27:26,335 5448 INFO dec_database OpenUpgrade: project: pre-migration script called with version 6.1.1.1
  2014-05-12 12:27:26,335 5448 INFO dec_database OpenUpgrade: table account_analytic_account, column state: renaming to openupgrade_legacy_7_0_state
  2014-05-12 12:27:26,336 5448 INFO dec_database OpenUpgrade: table project_task, column type_id: renaming to stage_id
  2014-05-12 12:27:26,337 5448 INFO dec_database OpenUpgrade: table project_task_type, column project_default: renaming to case_default
  2014-05-12 12:27:26,345 5448 INFO dec_database openerp.modules.module: module project: creating or updating database tables
  2014-05-12 12:27:26,486 5448 WARNING dec_database openerp.osv.orm: WARNING: unable to set column alias_id of table project_project not null !
  Try to re-run: openerp-server --update=module
  If it doesn't work, update records and execute manually:
  ALTER TABLE project_project ALTER COLUMN alias_id SET NOT NULL

  
  2014-05-12 12:27:31,102 5448 ERROR dec_database openerp.sql_db: Programming error: table name "project_project" specified more than once
  , in query 
          UPDATE project_project
          SET state = account_analytic_account.openupgrade_legacy_7_0_state
          FROM project_project
          INNER JOIN account_analytic_account
          ON account_analytic_account.id = project_project.analytic_account_id
          WHERE analytic_account_id is not NULL
          
  2014-05-12 12:27:31,102 5448 ERROR dec_database OpenUpgrade: project: error in migration script /home/ubuntu/projects/openupgrade/addons/project/migrations/7.0.1.1/post-migration.py: table name "project_project" specified more than once

  2014-05-12 12:27:31,102 5448 ERROR dec_database OpenUpgrade: table name "project_project" specified more than once
  Traceback (most recent call last):
    File "/home/ubuntu/projects/openupgrade/server/openerp/openupgrade/openupgrade.py", line 471, in wrapped_function
      func(cr, version)
    File "project/migrations/7.0.1.1/post-migration.py", line 68, in migrate
    File "project/migrations/7.0.1.1/post-migration.py", line 33, in copy_state_from_analytic_account
    File "/home/ubuntu/projects/openupgrade/server/openerp/openupgrade/openupgrade.py", line 328, in logged_query
      res = cr.execute(query, args)
    File "/home/ubuntu/projects/openupgrade/server/openerp/sql_db.py", line 161, in wrapper
      return f(self, *args, **kwargs)
    File "/home/ubuntu/projects/openupgrade/server/openerp/sql_db.py", line 226, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: table name "project_project" specified more than once

  2014-05-12 12:27:31,103 5448 ERROR dec_database openerp.modules.loading: Error executing post migration script for module project
  : table name "project_project" specified more than once

To manage notifications about this bug go to:
https://bugs.launchpad.net/openupgrade-addons/+bug/1318686/+subscriptions