Odoo Help

Welcome!

This community 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.

0

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

By
Achim Sinsel
on 6/16/14, 4:23 AM 889 views

Hi,

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)...
================================================================

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 6/16/14, 4:23 AM
Seen: 889 times
Last updated: 3/16/15, 8:10 AM