Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Error Message loading Products (without having changed anything...)

on 2/19/14, 4:22 PM 1,404 views

Without having changed anything regarding product model, I get the error message below when opening my product overview. Any idea how to solve this?

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

Server Traceback (most recent call last): File "/opt/openerp/openerp7/openerp-web/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/opt/openerp/openerp7/openerp-server/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/opt/openerp/openerp7/openerp-server/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, params) File "/opt/openerp/openerp7/openerp-server/openerp/osv/osv.py", line 190, in execute_kw return self.execute(db, uid, obj, method, *args, *kw or {}) File "/opt/openerp/openerp7/openerp-server/openerp/osv/osv.py", line 132, in wrapper return f(self, dbname, args, *kwargs) File "/opt/openerp/openerp7/openerp-server/openerp/osv/osv.py", line 199, in execute res = self.execute_cr(cr, uid, obj, method, args, *kw) File "/opt/openerp/openerp7/openerp-server/openerp/osv/osv.py", line 187, in execute_cr return getattr(object, method)(cr, uid, args, *kw) File "/opt/openerp/openerp7/openerp-server/openerp/osv/orm.py", line 3652, in read result = self._read_flat(cr, user, select, fields, context, load) File "/opt/openerp/openerp7/openerp-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 "/opt/openerp/openerp7/openerp-server/openerp/osv/fields.py", line 1142, in get result = self._fnct(obj, cr, uid, ids, name, self._arg, context) File "/opt/openerp/openerp7/openerp-addons/stock/product.py", line 36, in _stock_move_count ], ['product_id'], ['product_id']) File "/opt/openerp/openerp7/openerp-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 "/opt/openerp/openerp7/openerp-server/openerp/sql_db.py", line 161, in wrapper return f(self, args, *kwargs) File "/opt/openerp/openerp7/openerp-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...

On 2/19/14, 4:34 PM

Forget about it. I have just seen that this is a known bug (Bug #1281762 ) occuring after manual bzr pull on all 3 repos... Hope it will be fine again after next pull.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


Asked: 2/19/14, 4:22 PM
Seen: 1404 times
Last updated: 3/16/15, 8:10 AM