regression due to commit 5237

Bug #1282485 reported by OpenEduCat
This bug report is a duplicate of:  Bug #1281762: [7.0]SQL server error on products. Edit Remove
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Server (MOVED TO GITHUB)
Confirmed
High
Unassigned

Bug Description

unable to open product screen after installing product, purchase and sale_stock module.

Rev. Details :
    server (5238)
    addons (9849)
    web (4144)

Getting following traceback :

Client Traceback (most recent call last):
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/addons/web/http.py", line 204, in dispatch
    response["result"] = method(self, **self.params)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/addons/web/controllers/main.py", line 1051, in search_read
    return self.do_search_read(req, model, fields, offset, limit, domain, sort)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/addons/web/controllers/main.py", line 1086, in do_search_read
    records = Model.read(ids, fields or False, req.context)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/addons/web/session.py", line 42, 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-7-0-30892/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-7-0-30892/server/openerp/addons/web/session.py", line 103, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last):
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/osv/osv.py", line 190, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/osv/osv.py", line 132, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/osv/osv.py", line 199, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/addons/audittrail/audittrail.py", line 522, in execute_cr
    return fct_src(cr, uid, model, method, *args, **kw)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/osv/osv.py", line 187, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/osv/orm.py", line 3652, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/osv/orm.py", line 3761, in _read_flat
    res2 = self._columns[val[0]].get(cr, self, ids, val, user, context=context, values=res)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/osv/fields.py", line 1142, in get
    result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/addons/stock/product.py", line 36, in _stock_move_count
    ], ['product_id'], ['product_id'])
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/osv/orm.py", line 2717, in read_group
    cr.execute('SELECT min(%s.id) AS id, count(%s.id) AS %s_count' % (self._table, self._table, group_count) + (flist and ',') + flist + ' FROM ' + from_clause + where_clause + gb + (ob and ',') + ob + orderby_clause + limit_str + offset_str, where_clause_params)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/home/odoo/runbot/static/openerp-dev-7-0-30892/server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "stock_move__product_id.name_template" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...RDER BY "stock_move__product_id"."default_code" ,"stock_mov.

Changed in openobject-server:
status: New → Confirmed
importance: Undecided → High
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.