openerp-india team mailing list archive

["Jignesh Rathod\(OpenERP\)" <1047057@xxxxxxxxxxxxxxxxxx>]

*** This bug is a duplicate of bug 1027923 ***
    https://bugs.launchpad.net/bugs/1027923

** This bug has been marked a duplicate of bug 1027923
   [6.1 Regression@Quentin6911 revno]: l10n_fr : Gives the error at the time of update cause account type is removed on 6911 revision.

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1047057

Title:
  [l10n_fr] Errors when updating minor 6.1 version due to removal of
  account types

Status in OpenERP Addons (modules):
  New

Bug description:
  During the l10n_fr upgrade of july 2012, account types have been removed from plan_comptable_general.xml, as it now uses account_types from the account module.
  When updating to a august or septembre nightly the upgrade process tries to remove all the obsolete records and it breaks because all the previous accounts link to these account types.

  How to reproduce :

  - install 6.1-1 with account, and the french account chart
  - upgrade to any nightly version starting from august 2012.

  2012-09-06 21:06:28,968 10345 ERROR anybox.2012-09-03_01-56 openerp.sql_db: bad query: delete from account_account_type where id IN (7)
  Traceback (most recent call last):
    File "/home/dadafkas/projets/anybox/hg/openerp.anybox.fr/parts/openerp-6.1-20120905-232133/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  IntegrityError: ERREUR:  une valeur NULL viole la contrainte NOT NULL de la colonne « user_type »
  CONTEXTE : instruction SQL « UPDATE ONLY "public"."account_account" SET "user_type" = NULL WHERE $1 OPERATOR(pg_catalog.=) "user_type" »

  
  The quick workaround is to use --import-partial but it would be better to bring back the original account_types, or provide a seamless way to upgrade.

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