Skip to Content
Menu
This question has been flagged
2 Replies
6427 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.

Avatar
Discard

Did you installed a custom module?

Best Answer

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.

Avatar
Discard
Best Answer

The bug is fixed, see #1281762 on launchpad

Avatar
Discard
Related Posts Replies Views Activity
1
Aug 25
395
2
Jun 25
1817
0
Mar 25
1687
0
Feb 25
1326
3
Aug 24
6048