Odoo Help


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

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

The Question has been closed

Sudhir Arya (ERP Harbor Consulting Services)
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 (ERP Harbor Consulting Services)

--Sudhir Arya (ERP Harbor Consulting Services)--
| 6 8 8
Ahmedabad, India
--Sudhir Arya (ERP Harbor Consulting Services)--

• Co-Founder & Co-Owner at ERP Harbor Consulting Services

• ERP Consultant / ERP Customization / TechnoFunctional Expert

• Sound knowledge in Python, Odoo (Open ERP), XML, PostgreSQL

• Domain knowledge of Sale Management, Purchase Management, Warehouse Management, Manufacturing, Multi Company Configuration & Management, HR Management, Medical Management, Construction Management, Education Management, Point of Sale, Third Party Integrations

• Positive attitude and quick Learner

• Good analytical skill, quick bug and issue tracing and find the solution

• Good knowledge and experience in payment gateway integration with Odoo

• Ready to accept new challenges

• Active Memeber On Stackoverflow 




Sudhir Arya
ERP Harbor Consulting Services
Sudhir Arya (ERP Harbor Consulting Services)
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: 4661 times
Last updated: 3/16/15, 8:10 AM