traceback when i clear an item in search of Inventory analysis

Bug #997616 reported by Aline (OpenERP)
40
This bug affects 5 people
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Fix Released
Medium
OpenERP R&D Addons Team 2
OpenERP Community Backports (Addons)
Fix Released
Undecided
Unassigned
6.1
Fix Released
Undecided
Yann Papouin

Bug Description

can be reproduced in runbot, trunk _all

Go to "Reporting/ Warehouse/Inventory Analysis

in the report, clear the search criteria "Filter: Product"

traceback:

Client Traceback (most recent call last):
  File "/home/aline/source/web/trunk/addons/web/common/http.py", line 180, in dispatch
    response["result"] = method(controller, self, **self.params)
  File "/home/aline/source/web/trunk/addons/web/controllers/main.py", line 914, in search_read
    return self.do_search_read(req, model, fields, offset, limit, domain, sort)
  File "/home/aline/source/web/trunk/addons/web/controllers/main.py", line 951, in do_search_read
    records = Model.read(ids, fields or False, context)
  File "/home/aline/source/web/trunk/addons/web/common/openerplib/main.py", line 250, in proxy
    args, kw)
  File "/home/aline/source/web/trunk/addons/web/common/openerplib/main.py", line 117, in proxy
    result = self.connector.send(self.service_name, method, *args)
  File "/home/aline/source/web/trunk/addons/web/common/http.py", line 611, in send
    raise fault

Server Traceback (most recent call last):
  File "/home/aline/source/web/trunk/addons/web/common/http.py", line 592, in send
    result = openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/aline/source/server/trunk/openerp/netsvc.py", line 362, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/aline/source/server/trunk/openerp/service/web_services.py", line 586, in dispatch
    res = fn(db, uid, *params)
  File "/home/aline/source/server/trunk/openerp/osv/osv.py", line 167, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/home/aline/source/server/trunk/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/aline/source/server/trunk/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/aline/source/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/aline/source/server/trunk/openerp/osv/orm.py", line 3409, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/aline/source/server/trunk/openerp/osv/orm.py", line 3468, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/home/aline/source/server/trunk/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/home/aline/source/server/trunk/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column report_stock_inventory.year does not exist
LINE 1: SELECT report_stock_inventory."date",report_stock_inventory....
                                             ^

Related branches

Amit Parik (amit-parik)
Changed in openobject-addons:
assignee: nobody → OpenERP R&D Addons Team 2 (openerp-dev-addons2)
importance: Undecided → Medium
status: New → Confirmed
Changed in openobject-addons:
status: Confirmed → In Progress
Revision history for this message
Ajay Chauhan(OpenERP) (cha-tinyerp) wrote :

Hello,
it has been fixed lp:~openerp-commiter/openobject-addons/trunk-bug-997616-cha name with following revision number & revision id
    Revision no : 6888
    Revision id : <email address hidden>

Thanks,
Ajay Chauhan

Changed in openobject-addons:
status: In Progress → Fix Committed
Revision history for this message
qdp (OpenERP) (qdp) wrote :

Hello Aline (OpenERP),

i'm glad and proud to announce that THIS BUG HAS BEEN FIXED!! yeaaah

It landed in trunk in revision 7295
revision-id: <email address hidden>

tata,
Quentin

Changed in openobject-addons:
status: Fix Committed → Fix Released
Revision history for this message
Stefan Rijnhart (Opener) (stefan-opener) wrote :

Fixed in ocb-addons/6.1 here: http://bazaar.launchpad.net/~ocb/ocb-addons/6.1/revision/6822. Seems like the branch has been reused and the MP deleted afterwards.

Changed in ocb-addons:
status: New → 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.