Odoo Help


Error (column "stock_move__product_id.name_template" must appear in the GROUP BY clause or be used in an aggregate function) on

Ortaine Devian
on 2/20/14, 3:55 PM 2,231 views

I am getting error while clicking on product menu, and on the kanban view,

File "/opt/openerp/server/openerp/addons/stock/product.py", line 36, in _stock_move_count ], ['product_id'], ['product_id']) File "/opt/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/server/openerp/sql_db.py", line 161, in wrapper return f(self, args, *kwargs) File "/opt/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

Any Idea why this is occurred?

can anyone help me on this.

Did you installed a custom module?

GH Mediacloud, Grover Menacho
on 2/20/14, 5:59 PM
On 2/21/14, 7:08 AM

The bug is fixed, see #1281762 on launchpad

Open Net Sarl
On 2/21/14, 6:16 AM


It's an error related to this view stock.product_kanban_stock_view

As long as OpenERP does not provide a fix, you can hide it by granting the access permission to this view to a group, no one is a member of.

About This Community

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


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 2/20/14, 3:55 PM
Seen: 2231 times
Last updated: 3/16/15, 8:10 AM