← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 684095] [NEW] installing l10n_ch: insert into "account_journal" violates unique constraint "account_journal_code_company_uniq"

 

Public bug reported:

Steps:
 - install account
 - select Swiss chart of accounts

openobject-addons revno: 3948

When trying to generate l10n_ch chart of accounts, wizard produces the
following error:

ERROR:db.cursor:bad query: insert into "account_journal" (id,"default_debit_account_id","update_posted","code","user_id","name","analytic_journal_id","view_id","group_invoice_lines","company_id","centralisation","sequence_id","refund_journal","allow_date","entry_posted","type","default_credit_account_id",create_uid,create_date) values (7,721,E'False',E'EXJ',1,E'Purchase Journal',NULL,4,E'False',1,E'False',9,E'False',E'False',E'False',E'purchase',721,1,now())
Traceback (most recent call last):
  File "/home/elbati/workspace/openerp/server/openobject-server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
IntegrityError: duplicate key value violates unique constraint "account_journal_code_company_uniq"

due to the file vaudtax_data.xml
that creates journals (sale, purchase and refund) that should be created by wizard instead

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/684095

Title:
  installing l10n_ch: insert into "account_journal" violates unique constraint "account_journal_code_company_uniq"

Status in OpenObject Addons Modules:
  New

Bug description:
  Steps:
 - install account
 - select Swiss chart of accounts

openobject-addons revno: 3948

When trying to generate l10n_ch chart of accounts, wizard produces the following error:

ERROR:db.cursor:bad query: insert into "account_journal" (id,"default_debit_account_id","update_posted","code","user_id","name","analytic_journal_id","view_id","group_invoice_lines","company_id","centralisation","sequence_id","refund_journal","allow_date","entry_posted","type","default_credit_account_id",create_uid,create_date) values (7,721,E'False',E'EXJ',1,E'Purchase Journal',NULL,4,E'False',1,E'False',9,E'False',E'False',E'False',E'purchase',721,1,now())
Traceback (most recent call last):
  File "/home/elbati/workspace/openerp/server/openobject-server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
IntegrityError: duplicate key value violates unique constraint "account_journal_code_company_uniq"

due to the file vaudtax_data.xml
that creates journals (sale, purchase and refund) that should be created by wizard instead





Follow ups

References