This question has been flagged
1 Reply
7567 Views

Traceback (most recent call last):

  File "/home/arun/Odoo_new/openerp/http.py", line 646, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/home/arun/Odoo_new/openerp/http.py", line 683, in dispatch result = self._call_function(**self.params) File "/home/arun/Odoo_new/openerp/http.py", line 319, in _call_function return checked_call(self.db, *args, **kwargs) File "/home/arun/Odoo_new/openerp/service/model.py", line 118, in wrapper return f(dbname, *args, **kwargs) File "/home/arun/Odoo_new/openerp/http.py", line 312, in checked_call result = self.endpoint(*a, **kw) File "/home/arun/Odoo_new/openerp/http.py", line 962, in __call__ return self.method(*args, **kw) File "/home/arun/Odoo_new/openerp/http.py", line 512, in response_wrap response = f(*args, **kw) File "/home/arun/Odoo_new/addons/web/controllers/main.py", line 897, in call_kw return self._call_kw(model, method, args, kwargs) File "/home/arun/Odoo_new/addons/web/controllers/main.py", line 889, in _call_kw return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs) File "/home/arun/Odoo_new/openerp/api.py", line 250, in wrapper return old_api(self, *args, **kwargs) File "/home/arun/Odoo_new/addons/stock_account/product.py", line 76, in create return super(product_template, self).create(cr, uid, vals, context=context) File "/home/arun/Odoo_new/openerp/api.py", line 250, in wrapper return old_api(self, *args, **kwargs) File "/home/arun/Odoo_new/openerp/api.py", line 354, in old_api result = method(recs, *args, **kwargs) File "/home/arun/custom_2512/product_code/models/product.py", line 47, in create vals['item_sequence'] = categ.sequence_id.next_by_id() File "/home/arun/Odoo_new/openerp/api.py", line 248, in wrapper return new_api(self, *args, **kwargs) File "/home/arun/Odoo_new/openerp/addons/base/ir/ir_sequence.py", line 259, in next_by_id return self._next() File "/home/arun/Odoo_new/openerp/addons/base/ir/ir_sequence.py", line 245, in _next return self._next_do() File "/home/arun/Odoo_new/openerp/addons/base/ir/ir_sequence.py", line 187, in _next_do number_next = _update_nogap(self, self.number_increment) File "/home/arun/Odoo_new/openerp/addons/base/ir/ir_sequence.py", line 61, in _update_nogap self.env.cr.execute("SELECT number_next FROM %s WHERE id=%s FOR UPDATE NOWAIT" % (self._table, self.id)) File "/home/arun/Odoo_new/openerp/sql_db.py", line 141, in wrapper return f(self, *args, **kwargs) File "/home/arun/Odoo_new/openerp/sql_db.py", line 220, in execute res = self._obj.execute(query, params)ProgrammingError: operator does not exist: integer = booleanLINE 1: SELECT number_next FROM ir_sequence WHERE id=False FOR UPDAT...

                                                    ^HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Avatar
Discard
Best Answer

Hi,

You are trying to go through the field "id" in the table ir_sequence which is of type integer so you can't compare it to a boolean. What are you trying to do ? I think it cannot be empty or equal to 0 if that's what you are looking for.

Avatar
Discard