Odoo Help

Welcome!

This community 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.

0

click on save occure Error not Properly create ??

By
sunil
on 10/9/13, 8:58 AM 1,030 views

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.

Please give more details, are you using a normal OpenERP install, or are you in the process of writing and testing a module of your own.

IBS
on 10/9/13, 10:37 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 10/9/13, 8:58 AM
Seen: 1030 times
Last updated: 3/16/15, 8:10 AM