openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #00812
[Bug 823691] Re: Error when group by or order by with fields inherit from product
Hi,
I'm getting the same error working with version 6.0.3.
openerp-server: release 3533
I have 3 levels of inheritance as well hr_employee ->
hr_employee_employee -> hr_employee_secure and in the tree view I can't
order the columns and I get the error
ERROR:web-services:Uncaught exception
Traceback (most recent call last):
File "/home/yaiza/Development/openerp-6.0/server/bin/osv/osv.py", line 122, in wrapper
return f(self, dbname, *args, **kwargs)
File "/home/yaiza/Development/openerp-6.0/server/bin/osv/osv.py", line 176, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/yaiza/Development/openerp-6.0/server/bin/osv/osv.py", line 167, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/yaiza/Development/openerp-6.0/server/bin/osv/orm.py", line 1745, in search
return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
File "/home/yaiza/Development/openerp-6.0/server/bin/osv/orm.py", line 4018, in _search
order_by = self._generate_order_by(order, query)
File "/home/yaiza/Development/openerp-6.0/server/bin/osv/orm.py", line 3984, in _generate_order_by
order_column = parent_obj._columns[order_field]
KeyError: 'department_id'
Is this bug going to be merged in this stable version?
I have checked the same module with version 6.1 openerp-server release
3778 and it works perfectly there with the fix that you did, thanks for
that!
Regards,
Yaiza
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
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