Hello and thanks in advance to everyone who will help me with this problem.
I'm using Odoo 8 on CentOS 7, I have installed the base modules (CRM, Purchases, MRP, Warehouse management, etc) and this 4 modules, mantained by OCA:
stock_picking_package_preparation
stock_picking_package_preparation_line
stock_picking_package_info
stock_picking_package_preparation_add_to_wave
An example of use case that I'd like to do is this:
1) After a purchase order I receive items into WH/Input; I can't check at this moment if the packages contains all items that I ordered, so I can only say that I receive one or more packages linked to this purchase order (PACK00001, PACK00002, etc)
2) I should move these packages from WH/Input to WH/Quality Control, where one or more employees will opent that packages and will verify if they contain all the items of the purchase order, and then transfer them to WH/Stock.
I tried to do all that on my Odoo, and the first step is working. At the second step when I try to move some packages to WH/Quality Control, I have this error message:
Odoo Server Error
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/http.py", line 539, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/http.py", line 576, in dispatch
result = self._call_function(**self.params)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/http.py", line 312, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/service/model.py", line 118, in wrapper
return f(dbname, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/http.py", line 309, in checked_call
return self.endpoint(*a, **kw)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/http.py", line 805, in __call__
return self.method(*args, **kw)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/http.py", line 405, in response_wrap
response = f(*args, **kw)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/addons/web/controllers/main.py", line 948, in call_button
action = self._call_kw(model, method, args, {})
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/addons/web/controllers/main.py", line 936, in _call_kw
return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 268, in wrapper
return old_api(self, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 439, in old_api
result = new_api(recs, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 443, in new_api
result = [method(rec, *args, **kwargs) for rec in self]
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/addons/stock/wizard/stock_transfer_details.py", line 109, in do_detailed_transfer
self.picking_id.do_transfer()
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 266, in wrapper
return new_api(self, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 592, in new_api
result = method(self._model, cr, uid, self.ids, *args, **old_kwargs)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/addons/stock/stock.py", line 1475, in do_transfer
self.pool.get('stock.move').action_done(cr, uid, todo_move_ids, context=notrack_context)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 268, in wrapper
return old_api(self, *args, **kwargs)
File "/home/odoo/.local/share/Odoo/addons/8.0/picking_dispatch/stock.py", line 136, in action_done
status = super(StockMove, self).action_done(cr, uid, ids, context)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 268, in wrapper
return old_api(self, *args, **kwargs)
File "/home/odoo/.local/share/Odoo/addons/8.0/stock_no_negative/models/stock_move.py", line 92, in action_done
cr, uid, operation, lot_id, context=context)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 268, in wrapper
return old_api(self, *args, **kwargs)
File "/home/odoo/.local/share/Odoo/addons/8.0/stock_no_negative/models/stock_move.py", line 73, in check_before_action_done
context=context)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 268, in wrapper
return old_api(self, *args, **kwargs)
File "/home/odoo/.local/share/Odoo/addons/8.0/stock_no_negative/models/stock_move.py", line 136, in check_before_done_no_negative
context=context)[0]
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 268, in wrapper
return old_api(self, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/models.py", line 3144, in read
result = BaseModel.read(records, fields, load=load)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 266, in wrapper
return new_api(self, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/models.py", line 3179, in read
self._read_from_database(stored, inherited)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 266, in wrapper
return new_api(self, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/models.py", line 3400, in _read_from_database
forbidden = missing.exists()
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 266, in wrapper
return new_api(self, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/models.py", line 4901, in exists
self._cr.execute(query, [tuple(ids)])
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/sql_db.py", line 158, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/sql_db.py", line 234, in execute
res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: SELECT id FROM "product_product" WHERE id IN (false)
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
I can't explain why this happens, If someone is interested and want to help me, I can send also some screenshot or share credentials to let them see directly.
Thanks in advance
.
