Odoo Help


Error with res.partner or hr.employee many2one

Saghir A. Khatri
on 1/13/15, 1:12 AM 1,821 views

I am stuck in an error, which i am unable to figure out. I have field like this:


It was working fine. I replaced it with:


but i am getting exception like this:


    OpenERP Server Error
    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 1051, in search_read
        return self.do_search_read(req, model, fields, offset, limit, domain, sort)
      File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1086, in do_search_read
        records = Model.read(ids, fields or False, req.context)
      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 3679, in read
        result = self._read_flat(cr, user, select, fields, context, load)
      File "/opt/openerp/server/openerp/osv/orm.py", line 3800, in _read_flat
        res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
      File "/opt/openerp/server/openerp/osv/fields.py", line 468, in get
      File "/opt/openerp/server/openerp/osv/orm.py", line 2393, in name_get
        load='_classic_write', context=context)]
      File "/opt/openerp/server/openerp/addons/base/res/res_users.py", line 830, in read
        res = super(users_view, self).read(cr, uid, ids, fields, context=context, load=load)
      File "/opt/openerp/server/openerp/addons/base/res/res_users.py", line 292, in read
        result = super(res_users, self).read(cr, uid, ids, fields=fields, context=context, load=load)
      File "/opt/openerp/server/openerp/osv/orm.py", line 3679, in read
        result = self._read_flat(cr, user, select, fields, context, load)
      File "/opt/openerp/server/openerp/osv/orm.py", line 3731, in _read_flat
        cr.execute(query, [tuple(sub_ids)] + rule_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: ...,res_users.id FROM "res_users" WHERE res_users.id IN (false)...
    HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

I have used same syntax with other modules and they are working fine. I tried to replace `res.partner` with `hr.employee` and `res.users` but issue remains same. Kindly guide me to right direction.



Have you restarted the server and then upgrade your module?

on 1/13/15, 1:15 AM

Med Said BARA

--Med Said BARA--

| 5 5 7
--Med Said BARA--
Med Said BARA
On 1/13/15, 4:32 AM

Maybe, you forgot to inherit from res.partner 

Michael Telahun
On 1/13/15, 3:17 AM

You didn't give the situation in which this error triggers. Does it happen when you load the module? Start odoo? When?

Never the less, I've seen this type of error before when the logged in user isn't linked to an employee record. In the employee record form near the bottom there is a field that says: "Related User". Make sure it's filled in.

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 1/13/15, 1:12 AM
Seen: 1821 times
Last updated: 3/16/15, 8:10 AM