Step:
Create a two record for serial number (mrp_repair, enable manage serial numbers in advanced view of users)
Delete one of them from the list view.
Open the remaining record and click on pager, You will get the traceback.
Traceback (most recent call last):
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/addons/web/http.py", line 202, in dispatch
response["result"] = method(self, **self.params)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/addons/web/controllers/main.py", line 1121, in call_kw
return self._call_kw(req, model, method, args, kwargs)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/addons/web/controllers/main.py", line 1107, in _call_kw
records = req.session.model(model).read(*args, **kwargs)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/addons/web/session.py", line 43, in proxy
result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/addons/web/session.py", line 88, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/netsvc.py", line 242, in dispatch_rpc
result = dispatch(method, params)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/service/model.py", line 27, in dispatch
res = fn(db, uid, *params)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/service/model.py", line 138, in execute_kw
return execute(db, uid, obj, method, *args, **kw or {})
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/service/model.py", line 100, in wrapper
return f(dbname, *args, **kwargs)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/service/model.py", line 148, in execute
res = execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/addons/audittrail/audittrail.py", line 517, in execute_cr
return fct_src(cr, uid, model, method, *args, **kw)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/service/model.py", line 135, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/osv/orm.py", line 3601, in read
result = self._read_flat(cr, user, select, fields, context, load)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/osv/orm.py", line 3716, in _read_flat
res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/osv/fields.py", line 1131, in get
result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/addons/stock/stock.py", line 1433, in _get_stock
location_id IN %s and prodlot_id IN %s group by prodlot_id''',(tuple(locations),tuple(ids),))
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/sql_db.py", line 157, in wrapper
return f(self, *args, **kwargs)
File "/home/odoo/runbot/static/openerp-dev-trunk-5703/server/openerp/sql_db.py", line 222, in execute
res = self._obj.execute(query, params)
ProgrammingError: syntax error at or near ")"
LINE 7: ...7, 11, 23, 12, 19, 18, 21, 20) and prodlot_id IN () group by...
Hello,
It has been fix committed in https:/ /code.launchpad .net/~~ openerp- dev/openerp- web/7.0- bug-1161210- ishwar branch.
Revision No: 3868.
Revision ID: <email address hidden>.
Thanks,
Ishwar Malvi