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,110 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
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.


Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

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: 2110 times
Last updated: 3/16/15, 8:10 AM