ProgrammingError: operator does not exist: integer = boolean

Bug #1234795 reported by Maxime Chambreuil (http://www.savoirfairelinux.com)
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
openerp-accountedge
Fix Released
Low
Savoir-faire Linux' OpenERP

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.

Related branches

Changed in openerp-accountedge:
status: New → Confirmed
importance: Undecided → Low
assignee: nobody → Savoir-faire Linux' OpenERP (savoirfairelinux-openerp)
Changed in openerp-accountedge:
status: Confirmed → Fix Committed
Changed in openerp-accountedge:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.