[Menu] there is several problem when "Rooms" clicked

[AgusSalim]

i have problem when i clicked Rooms menu on HMS, here is the error notifications:
Client Traceback (most recent call last):
  File "/home/agussalim/Documents/openerp/openerp/addons/web/http.py", line 204, in dispatch
    response["result"] = method(self, **self.params)
  File "/home/agussalim/Documents/openerp/openerp/addons/web/controllers/main.py", line 1128, in call_kw
    return self._call_kw(req, model, method, args, kwargs)
  File "/home/agussalim/Documents/openerp/openerp/addons/web/controllers/main.py", line 1120, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/home/agussalim/Documents/openerp/openerp/addons/web/session.py", line 42, in proxy
    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
  File "/home/agussalim/Documents/openerp/openerp/addons/web/session.py", line 30, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/home/agussalim/Documents/openerp/openerp/addons/web/session.py", line 103, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last):
  File "/home/agussalim/Documents/openerp/openerp/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/agussalim/Documents/openerp/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/agussalim/Documents/openerp/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/home/agussalim/Documents/openerp/openerp/osv/osv.py", line 190, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/home/agussalim/Documents/openerp/openerp/osv/osv.py", line 132, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/agussalim/Documents/openerp/openerp/osv/osv.py", line 199, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/agussalim/Documents/openerp/openerp/osv/osv.py", line 187, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/agussalim/Documents/openerp/openerp/osv/orm.py", line 2689, in read_group
    cr.execute('SELECT min(%s.id) AS id, count(%s.id) AS %s_count' % (self._table, self._table, group_count) + (flist and ',') + flist + ' FROM ' + from_clause + where_clause + gb + limit_str + offset_str, where_clause_params)
  File "/home/agussalim/Documents/openerp/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/home/agussalim/Documents/openerp/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: invalid reference to FROM-clause entry for table "product_product"
LINE 1: ...("hotel_room__product_id"."active" = 'True') AND ("product_p...
                                                             ^
HINT: Perhaps you meant to reference the table alias "hotel_room__product_id".

[ahmed (ah-mnasri)]

I have a same broblem

[Lorenzo Battistini (elbati)]

A workaround is to remove the 'kanban' mode from the views of the 'Hotel Room' action

[AgusSalim (agussalim87)]

yup, the kanban view is the problem..

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.