Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
Error (column "stock_move__product_id.name_template" must appear in the GROUP BY clause or be used in an aggregate function) on
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.
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 2/20/14, 3:55 PM|
|Seen: 1884 times|
|Last updated: 3/16/15, 8:10 AM|