← Back to team overview

c2c-oerpscenario team mailing list archive

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

 

Hello tnbui,

Thanks for your feedback !

Yes you are right...a small change is still required on the fix and its
already commented on the merge proposal. When the fix will be merged to
trunk server that change will be also included. For time being you can
test it by making these change in orm.py @ line 4051 (table, col,
col_detail) = self._inherit_fields[v] just replace this line by (table,
col, col_detail, original_parent) = self._inherit_fields[v]. along with
the merge proposal changes.

Sorry for the inconvenience caused.

Thanks

-- 
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:
  Fix Committed

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


References