c2c-oerpscenario team mailing list archive

["Amit \(Open ERP\)" <apa@xxxxxxxxxxx>]

Public bug reported:

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.

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/880664

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

Status in OpenERP Addons (modules):
  New

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 manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/880664/+subscriptions