c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #31192
[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