← Back to team overview

openerp-india team mailing list archive

[Bug 1163345] Re: [7/0/Trunk] Journal Items modification triggers error because of empty elect boxes in header

 

** Tags added: invoicing

-- 
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/1163345

Title:
  [7/0/Trunk] Journal Items modification triggers error because of empty
  elect boxes in header

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  Steps to reproduce:

  1. Go on runbot db_all
  2. Click on Accounting > Journal Entries > Journal Items
  3. Remove the data in the period and journal select boxes in the header
  4. select the first line and modify any of the data
  5. Press enter in order to save the record
  6. Traceback:

  Client Traceback (most recent call last):
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/addons/web/http.py", line 203, in dispatch
      response["result"] = method(self, **self.params)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/addons/web/controllers/main.py", line 1129, in call_kw
      return self._call_kw(req, model, method, args, kwargs)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/addons/web/controllers/main.py", line 1121, in _call_kw
      return getattr(req.session.model(model), method)(*args, **kwargs)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/addons/web/session.py", line 43, in proxy
      result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/addons/web/session.py", line 31, in proxy_method
      result = self.session.send(self.service_name, method, *args)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/addons/web/session.py", line 104, in send
      raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

  
  Server Traceback (most recent call last):
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/addons/web/session.py", line 90, in send
      return openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/netsvc.py", line 293, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/service/web_services.py", line 626, in dispatch
      res = fn(db, uid, *params)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/osv/osv.py", line 188, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/osv/osv.py", line 131, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/osv/osv.py", line 197, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/addons/audittrail/audittrail.py", line 514, in execute_cr
      return fct_src(cr, uid, model, method, *args, **kw)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/osv/osv.py", line 185, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/addons/account/account_move_line.py", line 1087, in write
      if journal.centralisation:
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/osv/orm.py", line 484, in __getattr__
      return self[name]
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/osv/orm.py", line 399, in __getitem__
      field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/osv/orm.py", line 3604, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/osv/orm.py", line 3656, in _read_flat
      cr.execute(query, [tuple(sub_ids)] + rule_params)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/sql_db.py", line 161, in wrapper
      return f(self, *args, **kwargs)
    File "/home/odoo/runbot/static/openerp-dev-7-0-6101/server/openerp/sql_db.py", line 226, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: operator does not exist: integer = boolean
  LINE 1: ...d FROM "account_journal" WHERE account_journal.id IN (false)...
                                                               ^
  HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.


  This problem doesn't appear if there's data for period AND journal

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