models many2many field error

Asked by KennyLeung

Hi all,

I've tested the OpenERP7.0 for several latest versions.

Every time when I modify a model and create a field type many2many, then I save model, it occur an error. The messages it show:

OpenERP Server Error

Client Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/", line 203, in dispatch
    response["result"] = method(self, **self.params)
  File "/opt/openerp/server/openerp/addons/web/controllers/", line 1129, in call_kw
    return self._call_kw(req, model, method, args, kwargs)
  File "/opt/openerp/server/openerp/addons/web/controllers/", line 1121, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/opt/openerp/server/openerp/addons/web/", line 43, 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/", line 31, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/opt/openerp/server/openerp/addons/web/", line 104, in send
    raise xmlrpclib.Fault(, formatted_info)

Server Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/", line 90, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/openerp/server/openerp/", line 293, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/server/openerp/service/", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/server/openerp/osv/", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/openerp/server/openerp/osv/", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/server/openerp/osv/", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/server/openerp/osv/", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/server/openerp/addons/base/ir/", line 185, in write
    return super(ir_model,self).write(cr, user, ids, vals, context)
  File "/opt/openerp/server/openerp/osv/", line 4178, in write
    result += self._columns[field].set(cr, self, id, field, vals[field], user, context=rel_context) or []
  File "/opt/openerp/server/openerp/osv/", line 557, in set
    id_new = obj.create(cr, user, act[2], context=context)
  File "/opt/openerp/server/openerp/addons/base/ir/", line 357, in create
    self.pool.get(vals['model'])._auto_init(cr, ctx)
  File "/opt/openerp/server/openerp/osv/", line 3007, in _auto_init
    self._m2m_raise_or_create_relation(cr, f)
  File "/opt/openerp/server/openerp/osv/", line 3313, in _m2m_raise_or_create_relation
    self._save_relation_table(cr, m2m_tbl)
  File "/opt/openerp/server/openerp/osv/", line 2874, in _save_relation_table
    """, (relation_table, self._module))
  File "/opt/openerp/server/openerp/", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/server/openerp/", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: character varying = boolean
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Question information

English Edit question
Odoo Server (MOVED TO GITHUB) Edit question
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Serpent Consulting Services (serpent-consulting-services) said :

Are you trying this by a custom field?

Revision history for this message
KennyLeung (yyy886) said :

the channge is here:

but I can't login this server, so I can't verify the result.

I believe Ishwar Malvi has fixed this error.

I'm waiting offical version.

and now I'm using code rather than GUI to develop.


Kenny Leung

Revision history for this message
Serpent Consulting Services (serpent-consulting-services) said :


Kindly check if you still happen to see the error.


Can you help with this problem?

Provide an answer of your own, or ask KennyLeung for more information if necessary.

To post a message you must log in.