ERROR db_7_10 openerp.sql_db: Programming error: operator does not exist: character varying = integer LINE 1: ...l_exercise" WHERE ("all_exercise"."exercise_name" in (41)) O... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. , in query SELECT "all_exercise".id FROM "all_exercise" WHERE ("all_exercise"."exercise_name" in (%s)) ORDER BY "all_exercise"."id"
2013-10-09 10:44:37,239 1473 ERROR db_7_10 openerp.osv.osv: Uncaught exception Traceback (most recent call last): File "/home/mvt/workspace/server/7.0/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, args, *kwargs) File "/home/mvt/workspace/server/7.0/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, args, *kw) File "/home/mvt/workspace/server/7.0/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, args, *kw) File "/home/mvt/workspace/server/7.0/openerp/osv/orm.py", line 3606, in read result = self._read_flat(cr, user, select, fields, context, load) File "/home/mvt/workspace/server/7.0/openerp/osv/orm.py", line 3726, in _read_flat res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res) File "/home/mvt/workspace/server/7.0/openerp/osv/fields.py", line 536, in get ids2 = obj.pool.get(self._obj).search(cr, user, domain + [(self._fields_id, 'in', ids)], limit=self._limit, context=context) File "/home/mvt/workspace/server/7.0/openerp/osv/orm.py", line 2356, in search return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count) File "/home/mvt/workspace/server/7.0/openerp/osv/orm.py", line 4860, 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/mvt/workspace/server/7.0/openerp/sql_db.py", line 161, in wrapper return f(self, args, *kwargs) File "/home/mvt/workspace/server/7.0/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) ProgrammingError: operator does not exist: character varying = integer LINE 1: ...l_exercise" WHERE ("all_exercise"."exercise_name" in (41)) O... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.