Odoo Help


Error Creating Many to Many Relationships

Darryn Parker
on 8/28/13, 11:49 PM 2,476 views

Every time I try to create a many to many relationship between two simple models I get this error.

I have version 7.0-20130828-231133 running on Windows 2008 R2.

^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. Traceback (most recent call last): File "d:\OpenERP\Server\server.\openerp\netsvc.py", line 292, in dispatch_rpc File "d:\OpenERP\Server\server.\openerp\service\web_services.py", line 626, in dispatch File "d:\OpenERP\Server\server.\openerp\osv\osv.py", line 188, in execute_kw File "d:\OpenERP\Server\server.\openerp\osv\osv.py", line 131, in wrapper File "d:\OpenERP\Server\server.\openerp\osv\osv.py", line 197, in execute File "d:\OpenERP\Server\server\openerp\addons\audittrail\audittrail.py", line 514, in execute_cr File "d:\OpenERP\Server\server.\openerp\osv\osv.py", line 185, in execute_cr File "d:\OpenERP\Server\server\openerp\addons\base\ir\ir_model.py", line 185, in write File "d:\OpenERP\Server\server.\openerp\osv\orm.py", line 4180, in write File "d:\OpenERP\Server\server.\openerp\osv\fields.py", line 557, in set File "d:\OpenERP\Server\server\openerp\addons\base\ir\ir_model.py", line 358, in create File "d:\OpenERP\Server\server.\openerp\osv\orm.py", line 3009, in _auto_init File "d:\OpenERP\Server\server.\openerp\osv\orm.py", line 3315, in _m2m_raise_or_create_relation File "d:\OpenERP\Server\server.\openerp\osv\orm.py", line 2876, in _save_relation_table File "d:\OpenERP\Server\server.\openerp\sql_db.py", line 161, in wrapper File "d:\OpenERP\Server\server.\openerp\sql_db.py", line 226, in execute ProgrammingError: operator does not exist: character varying = boolean LINE 5: AND ir_module_module.name=false

Darryn Parker
On 9/3/13, 11:48 PM


The issue was not the new field that I was creating but an existing Many to Many field that wasn't created properly.

I only found this as a trial and error on new test models which the creation of the Many to Many fields were working just fine. I also was unable to create even the most basic new fields on the model that was producing this error.

OpenERP seems to be working fine now but wish that the error handling and messaging would be more helpful.

Spot on, had a relationship field that generated this error. Thanks for the advice!

dave ellis
on 9/10/13, 11:48 AM

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

0 follower(s)


Asked: 8/28/13, 11:49 PM
Seen: 2476 times
Last updated: 3/16/15, 8:10 AM