How to reproduce: Sales --> Products [Kanban view] --> error
Trace:
Client Traceback (most recent call last):
File "/usr/lib/pymodules/python2.7/openerp/addons/web/http.py", line 204, in dispatch
response["result"] = method(self, **self.params)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1051, in search_read
return self.do_search_read(req, model, fields, offset, limit, domain, sort)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1086, in do_search_read
records = Model.read(ids, fields or False, req.context)
File "/usr/lib/pymodules/python2.7/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 "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/usr/lib/pymodules/python2.7/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 "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 89, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, *params)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 190, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 132, in wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 199, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 187, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3652, in read
result = self._read_flat(cr, user, select, fields, context, load)
File "/usr/lib/pymodules/python2.7/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 "/usr/lib/pymodules/python2.7/openerp/osv/fields.py", line 1142, in get
result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
File "/usr/lib/pymodules/python2.7/openerp/addons/stock/product.py", line 36, in _stock_move_count
], ['product_id'], ['product_id'])
File "/usr/lib/pymodules/python2.7/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 "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 161, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/pymodules/python2.7/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... ^
OpenERP version: openerp 7.0-20140219- 002632- 1
How to reproduce: Sales --> Products [Kanban view] --> error
Trace:
Client Traceback (most recent call last): pymodules/ python2. 7/openerp/ addons/ web/http. py", line 204, in dispatch "result" ] = method(self, **self.params) pymodules/ python2. 7/openerp/ addons/ web/controllers /main.py" , line 1051, in search_read search_ read(req, model, fields, offset, limit, domain, sort) pymodules/ python2. 7/openerp/ addons/ web/controllers /main.py" , line 1086, in do_search_read pymodules/ python2. 7/openerp/ addons/ web/session. py", line 42, in proxy execute_ kw(self. session. _db, self.session._uid, self.session. _password, self.model, method, args, kw) pymodules/ python2. 7/openerp/ addons/ web/session. py", line 30, in proxy_method send(self. service_ name, method, *args) pymodules/ python2. 7/openerp/ addons/ web/session. py", line 103, in send Fault(openerp. tools.ustr( e), formatted_info)
File "/usr/lib/
response[
File "/usr/lib/
return self.do_
File "/usr/lib/
records = Model.read(ids, fields or False, req.context)
File "/usr/lib/
result = self.proxy.
File "/usr/lib/
result = self.session.
File "/usr/lib/
raise xmlrpclib.
Server Traceback (most recent call last): pymodules/ python2. 7/openerp/ addons/ web/session. py", line 89, in send netsvc. dispatch_ rpc(service_ name, method, args) pymodules/ python2. 7/openerp/ netsvc. py", line 292, in dispatch_rpc getService( service_ name).dispatch( method, params) pymodules/ python2. 7/openerp/ service/ web_services. py", line 626, in dispatch pymodules/ python2. 7/openerp/ osv/osv. py", line 190, in execute_kw pymodules/ python2. 7/openerp/ osv/osv. py", line 132, in wrapper pymodules/ python2. 7/openerp/ osv/osv. py", line 199, in execute pymodules/ python2. 7/openerp/ osv/osv. py", line 187, in execute_cr pymodules/ python2. 7/openerp/ osv/orm. py", line 3652, in read pymodules/ python2. 7/openerp/ osv/orm. py", line 3761, in _read_flat val[0]] .get(cr, self, ids, val, user, context=context, values=res) pymodules/ python2. 7/openerp/ osv/fields. py", line 1142, in get pymodules/ python2. 7/openerp/ addons/ stock/product. py", line 36, in _stock_move_count pymodules/ python2. 7/openerp/ osv/orm. py", line 2717, in read_group 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) pymodules/ python2. 7/openerp/ sql_db. py", line 161, in wrapper pymodules/ python2. 7/openerp/ sql_db. py", line 226, in execute execute( query, params) move__product_ id.name_ template" must appear in the GROUP BY clause or be used in an aggregate function move__product_ id"."default_ code" ,"stock_mov...
^
File "/usr/lib/
return openerp.
File "/usr/lib/
result = ExportService.
File "/usr/lib/
res = fn(db, uid, *params)
File "/usr/lib/
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/usr/lib/
return f(self, dbname, *args, **kwargs)
File "/usr/lib/
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/lib/
return getattr(object, method)(cr, uid, *args, **kw)
File "/usr/lib/
result = self._read_flat(cr, user, select, fields, context, load)
File "/usr/lib/
res2 = self._columns[
File "/usr/lib/
result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
File "/usr/lib/
], ['product_id'], ['product_id'])
File "/usr/lib/
cr.
File "/usr/lib/
return f(self, *args, **kwargs)
File "/usr/lib/
res = self._obj.
ProgrammingError: column "stock_
LINE 1: ...RDER BY "stock_