Odoo Help


OpenErp Server Error _ No operator matches the given name and argument type(s). You might need to add explicit type casts.

on 5/22/14, 7:50 AM 2,516 views


we are a group of students who are working for a university project.

we have the following problem in the marketing modul, when we want to add a new event and insert ticket types.

anybody can help?

thank you 


OpenERP Server Error

Traceback (most recent call last): File "/home/odoo/src/odoo/saas-3/openerp/http.py", line 395, in dispatch result = self._call_function(**self.params) File "/home/odoo/src/odoo/saas-3/openerp/http.py", line 234, in _call_function return checked_call(self.db, *args, **kwargs) File "/home/odoo/src/odoo/saas-3/openerp/service/model.py", line 114, in wrapper return f(dbname, *args, **kwargs) File "/home/odoo/src/odoo/saas-3/openerp/http.py", line 231, in checked_call return self.func(*a, **kw) File "/home/odoo/src/odoo/saas-3/openerp/http.py", line 550, in __call__ return self.method(*args, **kw) File "/home/odoo/src/odoo/saas-3/addons/web/controllers/main.py", line 1233, in call_kw return self._call_kw(model, method, args, kwargs) File "/home/odoo/src/odoo/saas-3/addons/web/controllers/main.py", line 1225, in _call_kw return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs) File "/home/odoo/src/odoo/saas-3/addons/event_sale/event_sale.py", line 218, in onchange_product_id return {'value': {'price': self.pool.get("product.product").browse(cr, uid, product_id).list_price or 0}} File "/home/odoo/src/odoo/saas-3/openerp/osv/orm.py", line 505, in __getattr__ return self[name] File "/home/odoo/src/odoo/saas-3/openerp/osv/orm.py", line 408, in __getitem__ field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write") File "/home/odoo/src/odoo/saas-3/openerp/osv/orm.py", line 3300, in read result = self._read_flat(cr, user, select, fields, context, load) File "/home/odoo/src/odoo/saas-3/openerp/osv/orm.py", line 3347, in _read_flat cr.execute(query, [tuple(sub_ids)] + rule_params) File "/home/odoo/src/odoo/saas-3/openerp/sql_db.py", line 156, in wrapper return f(self, *args, **kwargs) File "/home/odoo/src/odoo/saas-3/openerp/sql_db.py", line 221, 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.


Mariusz Mizgier

--Mariusz Mizgier--
| 4 1 7
SOPOT, Poland
--Mariusz Mizgier--

OpenERP developer

Mariusz Mizgier
On 5/22/14, 11:27 AM

Error comes from onchange_product id method, your browse returns NoneType. Paste this piece of code that we could help you a little bit more.

On 5/31/14, 8:42 AM

Hi Mariuzs,

thank you, we solve the problem now..we deinstall the modul and now it works again.


About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/22/14, 7:50 AM
Seen: 2516 times
Last updated: 3/16/15, 8:10 AM