openerp-india team mailing list archive

[Francesco Apruzzese <1288205@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

When I go to menu Sales -> Products -> Products I receive this error:

Client Traceback (most recent call last):
  File "/home/openerp/web/addons/web/http.py", line 204, in dispatch
    response["result"] = method(self, **self.params)
  File "/home/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 "/home/openerp/web/addons/web/controllers/main.py", line 1086, in do_search_read
    records = Model.read(ids, fields or False, req.context)
  File "/home/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 "/home/openerp/web/addons/web/session.py", line 30, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/home/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 "/home/openerp/web/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/openerp/server/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/home/openerp/server/openerp/osv/osv.py", line 190, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/home/openerp/server/openerp/osv/osv.py", line 132, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/openerp/server/openerp/osv/osv.py", line 199, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/openerp/server/openerp/osv/osv.py", line 187, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/openerp/server/openerp/osv/orm.py", line 3653, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/openerp/server/openerp/osv/orm.py", line 3762, in _read_flat
    res2 = self._columns[val[0]].get(cr, self, ids, val, user, context=context, values=res)
  File "/home/openerp/server/openerp/osv/fields.py", line 1142, in get
    result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
  File "/home/openerp/addons/stock/product.py", line 36, in _stock_move_count
    ], ['product_id'], ['product_id'])
  File "/home/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 "/home/openerp/server/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/home/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...
                                                             ^

OCB addons to revision 9940

** Affects: openobject-addons
     Importance: Undecided
         Status: New


** Tags: menu product sale

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1288205

Title:
  Error from menu Sales -> Products -> Products

Status in OpenERP Addons (modules):
  New

Bug description:
  When I go to menu Sales -> Products -> Products I receive this error:

  Client Traceback (most recent call last):
    File "/home/openerp/web/addons/web/http.py", line 204, in dispatch
      response["result"] = method(self, **self.params)
    File "/home/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 "/home/openerp/web/addons/web/controllers/main.py", line 1086, in do_search_read
      records = Model.read(ids, fields or False, req.context)
    File "/home/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 "/home/openerp/web/addons/web/session.py", line 30, in proxy_method
      result = self.session.send(self.service_name, method, *args)
    File "/home/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 "/home/openerp/web/addons/web/session.py", line 89, in send
      return openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/home/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/openerp/server/openerp/service/web_services.py", line 626, in dispatch
      res = fn(db, uid, *params)
    File "/home/openerp/server/openerp/osv/osv.py", line 190, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/home/openerp/server/openerp/osv/osv.py", line 132, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/openerp/server/openerp/osv/osv.py", line 199, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/openerp/server/openerp/osv/osv.py", line 187, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/openerp/server/openerp/osv/orm.py", line 3653, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/home/openerp/server/openerp/osv/orm.py", line 3762, in _read_flat
      res2 = self._columns[val[0]].get(cr, self, ids, val, user, context=context, values=res)
    File "/home/openerp/server/openerp/osv/fields.py", line 1142, in get
      result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
    File "/home/openerp/addons/stock/product.py", line 36, in _stock_move_count
      ], ['product_id'], ['product_id'])
    File "/home/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 "/home/openerp/server/openerp/sql_db.py", line 161, in wrapper
      return f(self, *args, **kwargs)
    File "/home/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...
                                                               ^

  OCB addons to revision 9940

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1288205/+subscriptions