Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Error for hotel reservation ,when i try to create a room i got this error Why?

on 11/20/14, 4:54 AM 1,192 views

Client Traceback (most recent call last): File "/opt/openerp/server/openerp/addons/web/http.py", line 204, in dispatch response["result"] = method(self, **self.params) File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1133, in call_kw return self._call_kw(req, model, method, args, kwargs) File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1125, in _call_kw return getattr(req.session.model(model), method)(*args, **kwargs) File "/opt/openerp/server/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 "/opt/openerp/server/openerp/addons/web/session.py", line 30, in proxy_method result = self.session.send(self.service_name, method, *args) File "/opt/openerp/server/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 "/opt/openerp/server/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/opt/openerp/server/openerp/netsvc.py", line 296, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, *params) File "/opt/openerp/server/openerp/osv/osv.py", line 190, in execute_kw return self.execute(db, uid, obj, method, *args, **kw or {}) File "/opt/openerp/server/openerp/osv/osv.py", line 132, in wrapper return f(self, dbname, *args, **kwargs) File "/opt/openerp/server/openerp/osv/osv.py", line 199, in execute res = self.execute_cr(cr, uid, obj, method, *args, **kw) File "/opt/openerp/server/openerp/osv/osv.py", line 187, in execute_cr return getattr(object, method)(cr, uid, *args, **kw) File "/opt/openerp/server/openerp/osv/orm.py", line 2768, in read_group cr.execute(query, where_clause_params) File "/opt/openerp/server/openerp/sql_db.py", line 161, in wrapper return f(self, *args, **kwargs) File "/opt/openerp/server/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 5: ...("hotel_room__product_id"."active" = 'True') AND ("product_p... ^ HINT: Perhaps you meant to reference the table alias "hotel_room__product_id".

What it was mentioned?

I have the same error. Posted an Issue in github https://github.com/JayVora-SerpentCS/hotelmgmt_v8/issues/8 Seems that the project is not active. Last commit is from 6 months ago. I will try to find the cause of the problem... thing that comes from xml, but I find that the trace is not specific with the line.. like many of the xml exceptions.

Daniel Blanco
on 3/22/15, 11:57 PM

@Daniel: I know that this project has made a pull request OCA project vertical-hotel (github.com/OCA/vertical-hotel). OCA projects have a certain formal coding standard and as far as I understand the matter the author Jay Vora is adjusting the code to meet that standard. So in theory this code is going through a formal revision now. Practially I have the impression the original authors are busy with other things and do not have highest priority on this Pull Request.

on 3/23/15, 3:12 AM
On 5/17/15, 10:54 PM

Dear all,

i find a solution who work for me it a SQL error compare table with alias table Level 3 joints

To resolve it i apply the fix issue from emiprotechnologies (on github)

[Fix] to manage multi level of _inherits structure.

inside openerp/models.py and test_inherits.py

work well for me.

Regards all

[FIX] model: wrong alias used in read query for multi-inherited field. https://github.com/odoo-dev/odoo/commit/78a20a3dba07762d2

on 6/12/15, 8:12 AM


| 5 2 5
kerala, India

Working as a Odoo Functional and Technical Expert

On 3/23/15, 1:13 AM

remove order_by="room" from kanban view of prodcut.product,If it resloved Please Upvoted my Answer

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 11/20/14, 4:54 AM
Seen: 1192 times
Last updated: 5/17/15, 10:54 PM