Odoo Help

Welcome!

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.

1

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

By
Ortaine Devian
on 2/20/14, 3:55 PM 1,605 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
0
Youri
On 2/21/14, 7:08 AM

The bug is fixed, see #1281762 on launchpad

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

Hello,

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.

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)

Stats

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