Error Creating Many to Many Relationships

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

Error Creating Many to Many Relationships

1 Reply

5340 Views

Darryn Parker

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

Author

Fixed.

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.

dave ellis

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

This question has been flagged