← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 823691] [NEW] Error when group by or order by with fields inherit from product

 

Public bug reported:

This bug happened on v6.

In hotel module, I have a Room object which is inherited from
"product.product". I got below error message when I tried to "order by"
or group by field "categ_id".

I searched around and found bug https://bugs.launchpad.net/openobject-
client-web/+bug/362280 which may related to this error.

Error message:

Traceback (most recent call last):
  File "/usr/local/openerp-fullmoon-integration/current/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/usr/local/openerp-fullmoon-integration/current/server/bin/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/usr/local/openerp-fullmoon-integration/current/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/openerp-fullmoon-integration/current/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/openerp-fullmoon-integration/current/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/openerp-fullmoon-integration/current/server/bin/osv/orm.py", line 1743, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/usr/local/openerp-fullmoon-integration/current/server/bin/osv/orm.py", line 4012, in _search
    order_by = self._generate_order_by(order, query)
  File "/usr/local/openerp-fullmoon-integration/current/server/bin/osv/orm.py", line 3978, in _generate_order_by
    order_column = parent_obj._columns[order_field]
KeyError: 'categ_id'

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

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/823691

Title:
  Error when group by or order by with fields inherit from product

Status in OpenERP Server:
  New

Bug description:
  This bug happened on v6.

  In hotel module, I have a Room object which is inherited from
  "product.product". I got below error message when I tried to "order
  by" or group by field "categ_id".

  I searched around and found bug https://bugs.launchpad.net/openobject-
  client-web/+bug/362280 which may related to this error.

  Error message:

  Traceback (most recent call last):
    File "/usr/local/openerp-fullmoon-integration/current/server/bin/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/usr/local/openerp-fullmoon-integration/current/server/bin/service/web_services.py", line 599, in dispatch
      res = fn(db, uid, *params)
    File "/usr/local/openerp-fullmoon-integration/current/server/bin/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/local/openerp-fullmoon-integration/current/server/bin/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/local/openerp-fullmoon-integration/current/server/bin/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/usr/local/openerp-fullmoon-integration/current/server/bin/osv/orm.py", line 1743, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/usr/local/openerp-fullmoon-integration/current/server/bin/osv/orm.py", line 4012, in _search
      order_by = self._generate_order_by(order, query)
    File "/usr/local/openerp-fullmoon-integration/current/server/bin/osv/orm.py", line 3978, in _generate_order_by
      order_column = parent_obj._columns[order_field]
  KeyError: 'categ_id'

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


Follow ups

References