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

[Ben Ubah]

I installed the trunk version of the "Indent" module for Warehouse Management on OpenERP 7.0-20130605-231041.
I can create and confirm a new indent request.
But, I get the following error when i try to "Approve" an indent request.

Client Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\openerp\addons\web\http.py", line 204, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\openerp\addons\web\controllers\main.py", line 1132, in exec_workflow
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\openerp\addons\web\session.py", line 147, in exec_workflow
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\openerp\addons\web\session.py", line 30, in proxy_method
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\openerp\addons\web\session.py", line 103, in send

Server Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\openerp\addons\web\session.py", line 89, in send
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\netsvc.py", line 292, in dispatch_rpc
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\service\web_services.py", line 626, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\osv\osv.py", line 131, in wrapper
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\osv\osv.py", line 220, in exec_workflow
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\osv\osv.py", line 213, in exec_workflow_cr
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\osv\orm.py", line 3926, in _workflow_signal
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\workflow\wkf_service.py", line 119, in trg_validate
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\workflow\instance.py", line 43, in validate
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\workflow\workitem.py", line 60, in process
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\workflow\workitem.py", line 175, in _split_test
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\workflow\workitem.py", line 183, in _join_test
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\workflow\workitem.py", line 40, in create
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\workflow\workitem.py", line 52, in process
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\workflow\workitem.py", line 127, in _execute
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\workflow\wkf_expr.py", line 67, in execute
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\workflow\wkf_expr.py", line 57, in _eval_expr
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\tools\safe_eval.py", line 241, in safe_eval
  File "", line 1, in <module>
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\osv\orm.py", line 374, in function_proxy
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\openerp\addons\indent\indent.py", line 231, in action_picking_create
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\openerp\addons\indent\indent.py", line 421, in _create_pickings_and_procurements
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\openerp\addons\indent\indent.py", line 376, in _prepare_indent_line_procurement
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\osv\orm.py", line 484, in __getattr__
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\osv\orm.py", line 399, in __getitem__
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\osv\orm.py", line 3604, in read
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\osv\orm.py", line 3656, in _read_flat
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\sql_db.py", line 161, in wrapper
  File "C:\Program Files (x86)\OpenERP 7.0-20130605-231041\Server\server\.\openerp\sql_db.py", line 226, in execute
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...d FROM "stock_warehouse" WHERE stock_warehouse.id IN (false)...
                                                             ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

[Twinkle Christian(OpenERP) (tch-openerp)]

Hello,

"Indent" module is part of the extra-addons openerp-India, which are maintained by the community, including all the modules created by "OpenERP" or "Tiny", as none of these are actively developed by our teams anymore.

If you or anyone from the community would like to work on it, please mark the bug as "In progress" and assign it to yourself
(or ask us or anyone from OpenERP Drivers to do it for you). In the mean time, we will mark it as "Won't fix" to indicate that
no further progress is expected at the moment. If you require further assistance with any trouble while updating the module,
do not hesitate to ask here or via a question: https://answers.launchpad.net/openobject-addons

I hope you understand, and perhaps this explanation will be helpful to you if you start fixing this extra-addon...
Thank you!

[Hemangini (h-patel-serpentcs)]

Ben,

The problem has been fixed by revision http://bazaar.launchpad.net/~openerp-india/openerp-india/trunk/revision/789.

Please pull the latest code and recheck.

Thanks,
Hemangini,
Serpent Consulting Services Pvt. Ltd.

[Ben Ubah (benchie2k3)]

Thank you so much for the kindness to fix this bug. I will test it soonest.
Thank you again.

[Ben Ubah (benchie2k3)]

Dear sir,
Thanks for the fix, however, the link: http://bazaar.launchpad.net/~openerp-india/openerp-india/trunk/revision/789 is not found.
The revision 789 does not exist on bazaar.

Thank you

[Serpent Consulting Services (serpent-consulting-services)]

Ben,
its now merged into http://bazaar.launchpad.net/~openerp-india/openerp-india/trunk/revision/782
Thanks.

[Ben Ubah (benchie2k3)]

Dear sir,

I downloaded the code revision 782 and tried to install it. The Installation did not complete but, It showed this OpenERP warning:

ValidateError
Error occurred while validating the field(s) arch: Invalid XML for View Architecture!

Please what could be the cause of this?

[Serpent Consulting Services (serpent-consulting-services)]

Ben,

Please make sure you have not done any custom code.

Additionally, paste your server trace here.

Thanks.