While using l10n_fr_pgc extra addons in OpenERP 4.3, I get the following error while initializing my application:
ERROR: invalid input syntax for integer: "[(6, 0, [1])]"
insert into "account_account" (id,"code","name","company_id","sign","close_method","parent_id","active","type","reconcile",create_uid,create_date) values (7,'Classes 1 à 5','Comptes de bilan','1','1','none','[(6, 0, [1])]','True','view','False',1,now())
And the log file tells:
[Fri Aug 08 03:59:26 2008] INFO:init:addon:l10n_fr_pcg:loading pcg.xml
[Fri Aug 08 03:59:27 2008] INFO:init:
<record>
<field>Comptes de bilan</field>
<field>Classes 1 à 5</field>
<field>view</field>
<field>none</field>
<field>
<field>
</record>
[Fri Aug 08 03:59:27 2008] ERROR:web-services:Exception in call: Traceback (most recent call last):
File "/usr/lib64/python2.5/site-packages/tinyerp-server/wizard/__init__.py", line 80, in execute_cr
action_res = action(self, cr, uid, data, context)
File "/usr/lib64/python2.5/site-packages/tinyerp-server/addons/base_setup/wizard/wizard_base_setup.py", line 230, in _update
(db, pool)=pooler.restart_pool(cr.dbname, update_module=True)
File "/usr/lib64/python2.5/site-packages/tinyerp-server/pooler.py", line 66, in restart_pool
return get_db_and_pool(db_name, force_demo, update_module=update_module)
File "/usr/lib64/python2.5/site-packages/tinyerp-server/pooler.py", line 55, in get_db_and_pool
addons.load_modules(db, force_demo, status, update_module)
File "/usr/lib64/python2.5/site-packages/tinyerp-server/addons/__init__.py", line 335, in load_modules
load_module_graph(cr, graph, status, report=report)
File "/usr/lib64/python2.5/site-packages/tinyerp-server/addons/__init__.py", line 260, in load_module_graph
tools.convert_xml_import(cr, m, tools.file_open(opj(m, filename)), idref, mode=mode, **kwargs)
File "/usr/lib64/python2.5/site-packages/tinyerp-server/tools/convert.py", line 765, in convert_xml_import
obj.parse(xmlstr)
File "/usr/lib64/python2.5/site-packages/tinyerp-server/tools/convert.py", line 681, in parse
self._tags[rec.nodeName](self.cr, rec, n)
File "/usr/lib64/python2.5/site-packages/tinyerp-server/tools/convert.py", line 657, in _tag_record
id = self.pool.get('ir.model.data')._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode )
File "/usr/lib64/python2.5/site-packages/tinyerp-server/addons/base/ir/ir_model.py", line 333, in _update
res_id = model_obj.create(cr, uid, values)
File "/usr/lib64/python2.5/site-packages/tinyerp-server/osv/orm.py", line 2117, in create
cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
File "/usr/lib64/python2.5/site-packages/tinyerp-server/sql_db.py", line 76, in execute
res = self.obj.execute(sql, p)
ProgrammingError: ERROR: invalid input syntax for integer: "[(6, 0, [1])]"
insert into "account_account" (id,"code","name","company_id","sign","close_method","parent_id","active","type","reconcile",create_uid,create_date) values (7,'Classes 1 à 5','Comptes de bilan','1','1','none','[(6, 0, [1])]','True','view','False',1,now())
It seems that the sql query is not well formatted.'[(6, 0, [1])]' shouldn't be replaced by '1' ?