c2c-oerpscenario team mailing list archive

[tnbui <858006@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

This bug is another improvement of comment 10 from bug:
https://bugs.launchpad.net/openobject-server/+bug/823691

Steps to reproduce:
+ In object "hotel.room" of module "hotel", set "_order = 'name'" to order Room list by name
+ View list of Rooms, then below error occurred

Traceback (most recent call last):
  File "/home/tubui/source_code/trunk6-new/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/tubui/source_code/trunk6-new/server/bin/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/home/tubui/source_code/trunk6-new/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/tubui/source_code/trunk6-new/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/tubui/source_code/trunk6-new/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/tubui/source_code/trunk6-new/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 "/home/tubui/source_code/trunk6-new/server/bin/osv/orm.py", line 4045, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/home/tubui/source_code/trunk6-new/server/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/home/tubui/source_code/trunk6-new/server/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "name" does not exist
LINE 1: SELECT "hotel_room".id FROM "hotel_room" ORDER BY name limi...

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

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

Title:
  Could not set "_order=name" for object which inherits from product

Status in OpenERP Server:
  New

Bug description:
  This bug is another improvement of comment 10 from bug:
  https://bugs.launchpad.net/openobject-server/+bug/823691

  Steps to reproduce:
  + In object "hotel.room" of module "hotel", set "_order = 'name'" to order Room list by name
  + View list of Rooms, then below error occurred

  Traceback (most recent call last):
    File "/home/tubui/source_code/trunk6-new/server/bin/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/home/tubui/source_code/trunk6-new/server/bin/service/web_services.py", line 599, in dispatch
      res = fn(db, uid, *params)
    File "/home/tubui/source_code/trunk6-new/server/bin/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/tubui/source_code/trunk6-new/server/bin/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/tubui/source_code/trunk6-new/server/bin/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/tubui/source_code/trunk6-new/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 "/home/tubui/source_code/trunk6-new/server/bin/osv/orm.py", line 4045, in _search
      cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
    File "/home/tubui/source_code/trunk6-new/server/bin/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/home/tubui/source_code/trunk6-new/server/bin/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column "name" does not exist
  LINE 1: SELECT "hotel_room".id FROM "hotel_room" ORDER BY name limi...

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