Odoo Help


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

on 4/11/13, 2:17 AM 4,056 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)

--Sudhir Arya (SA)--
| 6 8 8
Ahmedabad, India
--Sudhir Arya (SA)--

Working as an OpenERP/Odoo developer and a Team Leader 

Top 5 Odoo contributor On Stackoverflow




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