I have checked you Issue, I have faced the same problem and traceback.
------------------------------------------
Traceback
-----------------
2012-06-25 06:27:33,967 3128 ERROR None openerp.sql_db: Programming error: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (134060... ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
, in query SELECT "mail_message".id FROM "mail_message" WHERE (mail_message."message_id" in (%s)) ORDER BY date desc
2012-06-25 06:27:33,968 3128 ERROR None openerp.osv.osv: Uncaught exception
Traceback (most recent call last):
File "/home/amb/rdtolls/server/trunk/openerp/osv/osv.py", line 121, in wrapper
return f(self, dbname, *args, **kwargs)
File "/home/amb/rdtolls/server/trunk/openerp/osv/osv.py", line 176, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/amb/rdtolls/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/amb/rdtolls/addons/trunk/plugin/plugin_handler.py", line 51, in document_get
msg_ids = mail_message_obj.search(cr, uid, [('message_id','in',references)])
File "/home/amb/rdtolls/server/trunk/openerp/osv/orm.py", line 2264, in search
return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
File "/home/amb/rdtolls/server/trunk/openerp/osv/orm.py", line 4627, in _search
cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
File "/home/amb/rdtolls/server/trunk/openerp/sql_db.py", line 152, in wrapper
return f(self, *args, **kwargs)
File "/home/amb/rdtolls/server/trunk/openerp/sql_db.py", line 212, in execute
res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (134060... ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2012-06-25 06:27:34,099 3128 ERROR None openerp.netsvc: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (134060... ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
================================================================================
Also I have attached the screen-cast for reproduce. So I confirm this Issue with medium Importance.
@Team : please give look into lp: 931523
Hello Jad Tabet,
I have checked you Issue, I have faced the same problem and traceback. ------- ------- ------- ------- ------- "message_ id" in (134060...
^ "message_ id" in (%s)) ORDER BY date desc amb/rdtolls/ server/ trunk/openerp/ osv/osv. py", line 121, in wrapper amb/rdtolls/ server/ trunk/openerp/ osv/osv. py", line 176, in execute amb/rdtolls/ server/ trunk/openerp/ osv/osv. py", line 164, in execute_cr amb/rdtolls/ addons/ trunk/plugin/ plugin_ handler. py", line 51, in document_get obj.search( cr, uid, [('message_ id','in' ,references) ]) amb/rdtolls/ server/ trunk/openerp/ osv/orm. py", line 2264, in search amb/rdtolls/ server/ trunk/openerp/ osv/orm. py", line 4627, in _search execute( 'SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_ params) amb/rdtolls/ server/ trunk/openerp/ sql_db. py", line 152, in wrapper amb/rdtolls/ server/ trunk/openerp/ sql_db. py", line 212, in execute execute( query, params) "message_ id" in (134060...
^
-------
Traceback
-----------------
2012-06-25 06:27:33,967 3128 ERROR None openerp.sql_db: Programming error: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message.
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
, in query SELECT "mail_message".id FROM "mail_message" WHERE (mail_message.
2012-06-25 06:27:33,968 3128 ERROR None openerp.osv.osv: Uncaught exception
Traceback (most recent call last):
File "/home/
return f(self, dbname, *args, **kwargs)
File "/home/
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/
msg_ids = mail_message_
File "/home/
return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
File "/home/
cr.
File "/home/
return f(self, *args, **kwargs)
File "/home/
res = self._obj.
ProgrammingError: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message.
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2012-06-25 06:27:34,099 3128 ERROR None openerp.netsvc: operator does not exist: character varying = numeric "message_ id" in (134060...
^ ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ===
LINE 1: ...M "mail_message" WHERE (mail_message.
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
=======
Also I have attached the screen-cast for reproduce. So I confirm this Issue with medium Importance.
@Team : please give look into lp: 931523
Thanks for reporting!