← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 672331] Re: null value in column "wkf_id" violates not-null constraint

 

this is the SQL sentence that throws the ERROR:

2010-11-07 16:07:27 COT openerp_ch02 openerp LOG:  statement: insert into "wkf_a
ctivity" (id,"kind","split_mode","name","join_mode","action","wkf_id","flow_stop
","flow_start",create_uid,create_date) values (10,E'function',E'XOR',E'proforma2
',E'XOR',E'write({''state'':''proforma2''})',NULL,E'False',E'False',1,now())
2010-11-07 16:07:27 COT openerp_ch02 openerp ERROR:  null value in column "wkf_id" violates not-null constraint

-- 
 null value in column "wkf_id" violates not-null constraint
https://bugs.launchpad.net/bugs/672331
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Server: New

Bug description:
Hello, i am starting with openerp, i am following the openerp book, but when i try to install the 'account' module, it fails with the above error, which i reproduce as follows:

As always any help with be apreciated.

Environment Information : 
System : Linux-2.6.32-bpo.2-686-i686-with-debian-squeeze-sid
OS Name : posix
Distributor ID:	Debian
Description:	Debian GNU/Linux testing (squeeze)
Release:	testing
Codename:	squeeze
Operating System Release : 2.6.32-bpo.2-686
Operating System Version : #1 SMP Tue Feb 16 06:03:17 UTC 2010
Operating System Architecture : 32bit
Operating System Locale : en_US.UTF8
Python Version : 2.6.6
OpenERP-Client Version : 5.0.14
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/usr/local/openerp-server-5.0.14/bin/netsvc.py", line 256, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/usr/local/openerp-server-5.0.14/bin/netsvc.py", line 76, in __call__
    return getattr(self, method)(*params)
  File "/usr/local/openerp-server-5.0.14/bin/service/web_services.py", line 633, in execute
    return self._execute(db, uid, wiz_id, datas, action, context)
  File "/usr/local/openerp-server-5.0.14/bin/service/web_services.py", line 613, in _execute
    return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
  File "/usr/local/openerp-server-5.0.14/bin/wizard/__init__.py", line 178, in execute
    res = self.execute_cr(cr, uid, data, state, context)
  File "/usr/local/openerp-server-5.0.14/bin/wizard/__init__.py", line 73, in execute_cr
    action_res = action(self, cr, uid, data, context)
  File "/usr/local/openerp-server/bin/addons/base/module/wizard/wizard_module_upgrade.py", line 92, in _upgrade_module
    db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/usr/local/openerp-server-5.0.14/bin/pooler.py", line 62, in restart_pool
    return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
  File "/usr/local/openerp-server-5.0.14/bin/pooler.py", line 40, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/usr/local/openerp-server-5.0.14/bin/addons/__init__.py", line 736, in load_modules
    r = load_module_graph(cr, graph, status, report=report)
  File "/usr/local/openerp-server-5.0.14/bin/addons/__init__.py", line 626, in load_module_graph
    tools.convert_xml_import(cr, m, fp, idref, mode=mode, **kwargs)
  File "/usr/local/openerp-server-5.0.14/bin/tools/convert.py", line 877, in convert_xml_import
    obj.parse(doc.getroot())
  File "/usr/local/openerp-server-5.0.14/bin/tools/convert.py", line 774, in parse
    self._tags[rec.tag](self.cr, rec, n)
  File "/usr/local/openerp-server-5.0.14/bin/tools/convert.py", line 746, 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/local/openerp-server/bin/addons/base/ir/ir_model.py", line 515, in _update
    res_id = model_obj.create(cr, uid, values, context=context)
  File "/usr/local/openerp-server-5.0.14/bin/osv/orm.py", line 2869, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/usr/local/openerp-server-5.0.14/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/openerp-server-5.0.14/bin/sql_db.py", line 123, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "wkf_id" violates not-null constraint





References