credativ team mailing list archive

[Coco <906362@xxxxxxxxxxxxxxxxxx>]

Hello,

I am on revision 3923 and I'm facing the same problem :

ERROR:db.cursor:bad query: insert into "ir_module_module" (id,"license","sequence","demo","state","application","complexity",create_uid,create_date) values (231,E'AGPL-3',10,E'False',E'uninstalled',E'False',E'normal',1,now())
Traceback (most recent call last):
  File "/usr/lib/openerp/trunk/server/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "name" violates not-null constraint

ERROR:tools.convert.xml_import:Parse error in /usr/lib/openerp/trunk/server/openerp/addons/base/base_module_meta.xml:5: 
<record id="base.module_account_accountant" model="ir.module.module">
            <field name="sequence">10</field>
        </record>
Traceback (most recent call last):
  File "/usr/lib/openerp/trunk/server/openerp/tools/convert.py", line 889, in parse
    self._tags[rec.tag](self.cr, rec, n)
  File "/usr/lib/openerp/trunk/server/openerp/tools/convert.py", line 856, 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, context=rec_context )
  File "/usr/lib/openerp/trunk/server/openerp/addons/base/ir/ir_model.py", line 732, in _update
    res_id = model_obj.create(cr, uid, values, context=context)
  File "/usr/lib/openerp/trunk/server/openerp/osv/orm.py", line 4134, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/usr/lib/openerp/trunk/server/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/openerp/trunk/server/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "name" violates not-null constraint

-- 
You received this bug notification because you are a member of OpenERP
Framework Experts, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/906362

Title:
  [6.1/trunk] regression in module loading since around rev #3887:
  "name" violates not-null constraint

Status in OpenERP Server:
  Fix Released

Bug description:
  Hello today, 
  when I tried to refresh our trunk server with --update=all --database=my_base,

  I got this error:

  
  [2011-12-19 15:01:18,768][?] INFO:web.common.http:Loading web_mobile
  [2011-12-19 15:01:18,769][?] INFO:web.common.http:Loading base
  [2011-12-19 15:01:18,941][prod] INFO:init.load:module base: loading objects
  [2011-12-19 15:01:18,943][prod] INFO:init:module base: registering objects
  [2011-12-19 15:01:19,025][prod] INFO:init:module base: creating or updating database tables
  [2011-12-19 15:01:21,411][prod] INFO:init.load:module base: loading base_data.xml
  [2011-12-19 15:01:21,784][prod] INFO:init.load:module base: loading security/base_security.xml
  [2011-12-19 15:01:21,856][prod] INFO:init.load:module base: loading base_menu.xml

  [2011-12-19 15:01:21,959][prod] INFO:init.load:module base: loading base_module_meta.xml
  [2011-12-19 15:01:21,966][prod] ERROR:db.cursor:bad query: insert into "ir_module_module" (id,"license","sequence","demo","state","application"
  ,"complexity",create_uid,create_date) values (242,'AGPL-3',10,'False','uninstalled','False','normal',1,now())
  Traceback (most recent call last):
    File "/opt/openerp/prod/server/openerp/sql_db.py", line 215, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "name" violates not-null constraint

  [2011-12-19 15:01:21,967][prod] ERROR:tools.convert.xml_import:Parse error in /opt/openerp/prod/server/openerp/addons/base/base_module_meta.xml
  :5:
  <record id="base.module_account_accountant" model="ir.module.module">
              <field name="sequence">10</field>
          </record>
  Traceback (most recent call last):
    File "/opt/openerp/prod/server/openerp/tools/convert.py", line 889, in parse
      self._tags[rec.tag](self.cr, rec, n)
    File "/opt/openerp/prod/server/openerp/tools/convert.py", line 856, 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), nou
  pdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )
    File "/opt/openerp/prod/server/openerp/addons/base/ir/ir_model.py", line 719, in _update
      res_id = model_obj.create(cr, uid, values, context=context)
    File "/opt/openerp/prod/server/openerp/osv/orm.py", line 4116, in create
      cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
    File "/opt/openerp/prod/server/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/opt/openerp/prod/server/openerp/sql_db.py", line 215, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "name" violates not-null constraint


  Notice this that roll backing to rev #3887 the update worked normally.
  I had no time to hunt the exact revision but it's between #3887 and
  #3893

  Hope this helps.

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