Odoo Help


ProgrammingError: operator does not exist: integer = boolean [Closed]

on 4/11/13, 2:17 AM 4,419 views

The Question has been closed

Sudhir Arya (SA)
on 04/18/2013 05:13:41
  File "/home/bellvantage/Documents/openerp-7.0/openerp-7.0/openerp/addons/bpl/bpl.py", line 100, in create
    no_define_object_browse.write({'current_no': emp_no})   File "/home/bellvantage/Documents/openerp-7.0/openerp-7.0/openerp/osv/orm.py", line 374, in function_proxy
    return attr(self._cr, self._uid, [self._id], *args, **kwargs)   File "/home/bellvantage/Documents/openerp-7.0/openerp-7.0/openerp/osv/orm.py", line 4150, in write
    'where id IN %s', upd1 + [sub_ids])   File "/home/bellvantage/Documents/openerp-7.0/openerp-7.0/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)   File "/home/bellvantage/Documents/openerp-7.0/openerp-7.0/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params) ProgrammingError: operator does not exist: integer = boolean LINE 1: ...=1,write_date=(now() at time zone 'UTC') where id IN (false)
                                                             ^ HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

here shows my error and here shows my code line 100

Sudhir Arya (SA)
On 4/11/13, 2:59 AM

I guess division_id field is either False or None. So check whether it has value or not.

Try this:

no_define_object_browse = no_define_object.browse(cr, uid, division_id, context=context)
if no_define_object_browse:
    no_define_object_browse.write({'current_no': emp_no})

ok Arya.thanks issue with I'm refer null value (because called list hasn't records yet )

on 4/11/13, 3:50 AM

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

0 follower(s)


Asked: 4/11/13, 2:17 AM
Seen: 4419 times
Last updated: 3/16/15, 8:10 AM