savoirfairelinux-openerp team mailing list archive

[Launchpad Bug Tracker <1234795@xxxxxxxxxxxxxxxxxx>]

** Branch linked: lp:~savoirfairelinux-openerp/openerp-
accountedge/fix-1234795

-- 
You received this bug notification because you are a member of Savoir-
faire Linux' OpenERP, which is a bug assignee.
https://bugs.launchpad.net/bugs/1234795

Title:
  ProgrammingError: operator does not exist: integer = boolean

Status in OpenERP AccountEdge:
  Confirmed

Bug description:
  When creating an hr expense line without product, I get:

  OpenERP Server Error

  Client Traceback (most recent call last):
  File "/opt/home/openerp/src/bzr/web/addons/web/common/http.py", line 180, in dispatch
  response["result"] = method(controller, self, **self.params)
  File "/opt/home/openerp/src/bzr/web/addons/web/controllers/main.py", line 976, in save
  r = m.write([id], data, req.session.eval_context(req.context))
  File "/opt/home/openerp/src/bzr/web/addons/web/common/openerplib/main.py", line 250, in proxy
  args, kw)
  File "/opt/home/openerp/src/bzr/web/addons/web/common/openerplib/main.py", line 117, in proxy
  result = self.connector.send(self.service_name, method, *args)
  File "/opt/home/openerp/src/bzr/web/addons/web/common/http.py", line 608, in send
  raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)

  
  Server Traceback (most recent call last):
  File "/opt/home/openerp/src/bzr/web/addons/web/common/http.py", line 593, in send
  return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/home/openerp/src/bzr/server/openerp/netsvc.py", line 360, in dispatch_rpc
  result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/home/openerp/src/bzr/server/openerp/service/web_services.py", line 586, in dispatch
  res = fn(db, uid, *params)
  File "/opt/home/openerp/src/bzr/server/openerp/osv/osv.py", line 186, in execute_kw
  return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/home/openerp/src/bzr/server/openerp/osv/osv.py", line 129, in wrapper
  return f(self, dbname, *args, **kwargs)
  File "/opt/home/openerp/src/bzr/server/openerp/osv/osv.py", line 195, in execute
  res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/home/openerp/src/bzr/addons/audittrail/audittrail.py", line 503, in execute_cr
  return fct_src(cr, uid, model, method, *args)
  File "/opt/home/openerp/src/bzr/server/openerp/osv/osv.py", line 183, in execute_cr
  return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/home/openerp/src/bzr/server/openerp/osv/orm.py", line 3955, in write
  result += self._columns[field].set(cr, self, id, field, vals[field], user, context=rel_context) or []
  File "/opt/home/openerp/src/bzr/server/openerp/osv/fields.py", line 572, in set
  id_new = obj.create(cr, user, act[2], context=context)
  File "/opt/home/openerp/src/bzr/accountedge/hr_expense_line_supplier_tax/hr_expense_line_supplier_tax.py", line 60, in create
  vals['tax_id'] = self.get_tax_id(cr, user, vals['product_id'], vals['partner_id'], context)
  File "/opt/home/openerp/src/bzr/accountedge/hr_expense_line_supplier_tax/hr_expense_line_supplier_tax.py", line 34, in get_tax_id
  purch_tax = product.product_tmpl_id.supplier_taxes_id
  File "/opt/home/openerp/src/bzr/server/openerp/osv/orm.py", line 476, in __getattr__
  return self[name]
  File "/opt/home/openerp/src/bzr/server/openerp/osv/orm.py", line 391, in __getitem__
  field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/opt/home/openerp/src/bzr/server/openerp/osv/orm.py", line 3416, in read
  result = self._read_flat(cr, user, select, fields, context, load)
  File "/opt/home/openerp/src/bzr/server/openerp/osv/orm.py", line 3475, in _read_flat
  cr.execute(query, (tuple(sub_ids),))
  File "/opt/home/openerp/src/bzr/server/openerp/sql_db.py", line 152, in wrapper
  return f(self, *args, **kwargs)
  File "/opt/home/openerp/src/bzr/server/openerp/sql_db.py", line 212, in execute
  res = self._obj.execute(query, params)
  ProgrammingError: operator does not exist: integer = boolean
  LINE 1: ...d FROM "product_product" WHERE product_product.id IN (false)...
  ^
  HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openerp-accountedge/+bug/1234795/+subscriptions