models many2many field error

[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/http.py", line 203, in dispatch
    response["result"] = method(self, **self.params)
  File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1129, in call_kw
    return self._call_kw(req, model, method, args, kwargs)
  File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1121, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/opt/openerp/server/openerp/addons/web/session.py", 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/session.py", line 31, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/opt/openerp/server/openerp/addons/web/session.py", line 104, 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 90, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/openerp/server/openerp/netsvc.py", line 293, 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/base/ir/ir_model.py", line 185, in write
    return super(ir_model,self).write(cr, user, ids, vals, context)
  File "/opt/openerp/server/openerp/osv/orm.py", 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/fields.py", line 557, in set
    id_new = obj.create(cr, user, act[2], context=context)
  File "/opt/openerp/server/openerp/addons/base/ir/ir_model.py", line 357, in create
    self.pool.get(vals['model'])._auto_init(cr, ctx)
  File "/opt/openerp/server/openerp/osv/orm.py", line 3007, in _auto_init
    self._m2m_raise_or_create_relation(cr, f)
  File "/opt/openerp/server/openerp/osv/orm.py", line 3313, in _m2m_raise_or_create_relation
    self._save_relation_table(cr, m2m_tbl)
  File "/opt/openerp/server/openerp/osv/orm.py", line 2874, in _save_relation_table
    """, (relation_table, self._module))
  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: character varying = boolean
LINE 5: AND ir_module_module.name=false
                                                 ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

[KennyLeung (yyy886)]

env: both ubuntu12.10 and windows XP, OpenERP 7.0( 2013-03-21, 2013-03-28, 2013-03-29）， PostgreSQL9.1(ubuntu)/PostgreSQL9.2（windows XP）

[Serpent Consulting Services (serpent-consulting-services)]

Kenny,

Would you please share how you edit?

by GUI ? or by code? and whats the definition you write for m2m?

Thanks.

[KennyLeung (yyy886)]

Serpent,

Thank you.

Here's my operations by GUI.

Settings --> Database Structure --> Models --> Edit --> Add an item --> (add a field type many2many) --> Save & Close --> Save

Then the error occurs.

See the image attached.

Thanks a lot.

[Ishwar Malvi(OpenERP) (ima-openerp)]

Hello,

  It has been fix committed in https://code.launchpad.net/~openerp-dev/openobject-server/trunk-bug-1161881-ishwar branch.
  Revision No: 4853.
  Revision ID: <email address hidden>

Thanks,
Ishwar Malvi

[KennyLeung (yyy886)]

Hi Ishwar,

   Thank you very much.

   But I updated from http://nightly.openerp.com/7.0/nightly/deb/openerp_7.0-20130409-232349-1_all.deb

and test it. the error is still exists.

  Thanks,

  Kenny Leung

[Ishwar Malvi(OpenERP) (ima-openerp)]

Hello Kenny Leung,

             I have fixed the same in http://trunk-bug-1161881-ishwar-6680.runbot.openerp.com/?db=trunk-bug-1161881-ishwar-6680-all#menu_id=494&action=567

 with custom model " x_test " as well as added "x_dummy" m2m field in crm.lead in form view

 Thanks,
 Ishwar Malvi

[KennyLeung (yyy886)]

 Ishwar Malvi,

really a nice work.

Thanks,

Kenny Leung