Odoo Help


Error in OpenERP 7 with the "multicompany_warehouse" addon: "integer = boolean", "WHERE stock_picking.id IN (false)"

Achim Sinsel
on 6/16/14, 4:23 AM 1,267 views


I'm getting this "picking_id" error with the "multicompany_warehouse" addon when I'm trying to change the products quantity. I'm able to change the quantity if I this addon is disabled, however, when this addon is enabled, then the following error (see below) occurs.

It seems to be a general problem with the "picking_id" because it is "false" (doesn't exist) sometimes where a valid "picking_id" is expected.

Does anybody know why it happens, is it an integrity issue in the database, a general error in OpenERP, or are these addons buggy?

Thank you.


File "E:\OpenERP 7.0-20140105-002500\Server\server\openerp\addons\stock\wizard\stock_change_product_qty.py", line 108, in change_product_qty
  File "E:\OpenERP 7.0-20140105-002500\Server\server\openerp\addons\stock\stock.py", line 2834, in action_done
  File "E:\OpenERP 7.0-20140105-002500\Server\server\openerp\addons\sale_stock_block_without_payment\stock.py", line 99, in action_done
  File "E:\OpenERP 7.0-20140105-002500\Server\server\openerp\addons\stock\stock.py", line 2427, in action_done
  File "E:\OpenERP 7.0-20140105-002500\Server\server\openerp\addons\multicompany_warehouse\stock.py", line 38, in write
  File "E:\OpenERP 7.0-20140105-002500\Server\server\.\openerp\osv\orm.py", line 497, in __getattr__
  File "E:\OpenERP 7.0-20140105-002500\Server\server\.\openerp\osv\orm.py", line 405, in __getitem__
  File "E:\OpenERP 7.0-20140105-002500\Server\server\.\openerp\osv\orm.py", line 3623, in read
  File "E:\OpenERP 7.0-20140105-002500\Server\server\.\openerp\osv\orm.py", line 3681, in _read_flat
  File "E:\OpenERP 7.0-20140105-002500\Server\server\.\openerp\osv\orm.py", line 3931, in check_access_rule
  File "E:\OpenERP 7.0-20140105-002500\Server\server\.\openerp\sql_db.py", line 161, in wrapper
  File "E:\OpenERP 7.0-20140105-002500\Server\server\.\openerp\sql_db.py", line 226, in execute
ProgrammingError: FEHLER:  Operator existiert nicht: integer = boolean
LINE 1: ...ng.id FROM "stock_picking" WHERE stock_picking.id IN (false)...

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: 6/16/14, 4:23 AM
Seen: 1267 times
Last updated: 3/16/15, 8:10 AM