[Trunk/7.0]pager value is wrong when delete the record on serial number.

Bug #1161210 reported by BrowseInfo
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Web (MOVED TO GITHUB)
Fix Released
Medium
Unassigned

Bug Description

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

Related branches

Amit Parik (amit-parik)
Changed in openobject-addons:
assignee: nobody → OpenERP R&D Addons Team 1 (openerp-dev-addons1)
importance: Undecided → Medium
status: New → Confirmed
summary: - Error when delete the serial number
+ [Trunk/7.0]pager value is wrong when delete the record on serial number.
affects: openobject-addons → openerp-web
Changed in openerp-web:
assignee: OpenERP R&D Addons Team 1 (openerp-dev-addons1) → nobody
Amit Parik (amit-parik)
Changed in openerp-web:
assignee: nobody → OpenERP R&D Web Team (openerp-dev-web)
Changed in openerp-web:
status: Confirmed → In Progress
Revision history for this message
Ishwar Malvi(OpenERP) (ima-openerp) wrote :

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

Changed in openerp-web:
status: In Progress → Fix Committed
Changed in openerp-web:
assignee: OpenERP R&D Web Team (openerp-dev-web) → Xavier (Open ERP) (xmo)
Changed in openerp-web:
assignee: Xavier (Open ERP) (xmo) → Fabien Meghazi (OpenERP) (fme)
description: updated
Changed in openerp-web:
assignee: Fabien Meghazi (OpenERP) (fme) → Xavier (Open ERP) (xmo)
status: Fix Committed → In Progress
Revision history for this message
Xavier (Open ERP) (xmo-deactivatedaccount) wrote :

So this fails when switching by clicking on a list row, but works when switching by clicking on the view toggle.

The reason for this is that, when a record is activated, the listview will do some jiggling around assigning the ids of internal dataset to the one shared between all views, this is mostly for the case where one switches from a "grouped" list view, so the form view only cycles on the "current" group.

Problem is, that internal dataset is not correctly synchronized with the shared one, so when the id is removed from the shared dataset it is *not* removed from the internal one(s), and when the switch is made the ids from the internal dataset are set on the shared one and reintroduce the deleted record, leading to the form view's incorrect state.

Revision history for this message
Xavier (Open ERP) (xmo-deactivatedaccount) wrote :

Should be fixed in 7.0 as of revision <email address hidden>

Changed in openerp-web:
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.