[TRUNK]:survey:ERROR:db.cursor:Programming error: operator does not exist: integer = boolean

Bug #880664 reported by Ajay Patel (OpenERP)
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
New
Undecided
Unassigned

Bug Description

Steps to reproduce the traceback :

Go to Tools -> Surveys -> Answer Surveys and run the wizard Answer Survey
select anyone from many2one field and answer the selected survey.
fill up all datas and while clicking on the next buttons will give the traceback :

[2011-10-24 06:06:57,215][?] ERROR:db.cursor:Programming error: operator does not exist: integer = boolean
LINE 1: ...survey_question_wiz" WHERE survey_question_wiz.id IN (true) ...
                                                             ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
, in query SELECT COALESCE(survey_question_wiz.write_date, survey_question_wiz.create_date, now())::timestamp AS __last_update,survey_question_wiz.id FROM "survey_question_wiz" WHERE survey_question_wiz.id IN %s ORDER BY id
[2011-10-24 06:06:57,216][?] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/home/amit/sources/server/trunk/openerp/osv/osv.py", line 120, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/amit/sources/server/trunk/openerp/osv/osv.py", line 172, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/amit/sources/server/trunk/openerp/osv/osv.py", line 163, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/amit/sources/server/trunk/openerp/osv/orm.py", line 3272, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/amit/sources/server/trunk/openerp/osv/orm.py", line 3331, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/home/amit/sources/server/trunk/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/home/amit/sources/server/trunk/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...survey_question_wiz" WHERE survey_question_wiz.id IN (true) ...
                                                             ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.