Odoo Help

Welcome!

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.

0

Create contract results in "OpenERP Server Error"

By
Vitali Quiering
on 12/19/13, 6:01 AM 1,441 views

Hello,

we are currently evaluating OpenERP and I found this error I couldn't pass. Whenever I create a contract as a user I get the following python error. When I close this error and just create the contract, it works, but how can I avoid this message? It doesn't happen, when I create a contact with the admin account but also when I grant admin rights to my user.

Thank you very much.

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 1128, in call_kw return self._call_kw(req, model, method, args, kwargs) File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1120, 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 292, 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 188, in execute_kw return self.execute(db, uid, obj, method, *args, *kw or {}) File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, args, *kwargs) File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, args, *kw) File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, args, *kw) File "/opt/openerp/server/openerp/addons/hr_timesheet_invoice/hr_timesheet_invoice.py", line 81, in on_change_partner_id pricelist = part.property_product_pricelist and part.property_product_pricelist.id or False File "/opt/openerp/server/openerp/osv/orm.py", line 494, in __getattr__ return self[name] File "/opt/openerp/server/openerp/osv/orm.py", line 402, in __getitem__ field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write") File "/opt/openerp/server/openerp/osv/orm.py", line 3620, in read result = self._read_flat(cr, user, select, fields, context, load) File "/opt/openerp/server/openerp/osv/orm.py", line 3678, in _read_flat self.check_access_rule(cr, user, ids, 'read', context=context) File "/opt/openerp/server/openerp/osv/orm.py", line 3928, in check_access_rule [sub_ids] + where_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: operator does not exist: integer = boolean LINE 1: ...artner.id FROM "res_partner" WHERE res_partner.id IN (false)... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

0
Vitali Quiering
On 12/20/13, 8:14 AM

Does anyone know this? How can I get rid of this?

0
Erdem Uney
On 3/7/14, 11:21 PM

This was a bug that has been fixed and committed. You just need to upgrade to a current version.

~ 7Gates Interactive Technologies ~ 7gates.co ~ Istanbul - TR
0
Torsten Dörschel
On 2/5/14, 10:11 AM

We experience the same problem with our live system (administrated by external OpenERP partner), Version 7.0. Contracts Mgmt. module account_analytic_analysis version 7.0.1.1 Python 2.7.3-0ubuntu2.2 PostgreSQL 9.1+129 Ubuntu 12.04 64bit Server

In a test system with Debian Nightly Builds (Version 7.0-20140205-002759), the problem does not occur. Contracts Mgmt. module account_analytic_analysis version 7.0.1.1 as well. Python 2.7.5-5ubuntu1 PostgreSQL 9.3+146really9.1+148 Ubuntu 13.10 64bit Desktop

Hope someone can find the root of this error. In our live system, you can ignore it and go on creating the contract, but it is annoying for sure.

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

2 follower(s)

Stats

Asked: 12/19/13, 6:01 AM
Seen: 1441 times
Last updated: 3/16/15, 8:10 AM