← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 882288] [NEW] [trunk][survey] regression: answering survey with GTK generates a server SQL bug

 

Public bug reported:

Hello this is using trunk / 6.1 with revisions:
client #1986
server #3776
addons #5466

Try to answer the "Odoo feedback" survey with the GK client with default
demo data. Try to switch from page 1 to page 2.

On the GTK log you'll get this error:

Distributor ID:	Ubuntu
Description:	Ubuntu 11.10
Release:	11.10
Codename:	oneiric
Operating System Release : 3.0.0-12-generic
Operating System Version : #20-Ubuntu SMP Fri Oct 7 14:56:25 UTC 2011
Operating System Architecture : 64bit
Operating System Locale : en_US.UTF-8
Python Version : 2.7.2+
OpenERP-Client Version : 6.1dev
Last revision No. & ID :1986 launchpad_translations_on_behalf_of_openerp-20111025045256-anw0ci19i32luvoo
Traceback (most recent call last):
  File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/service/netrpc_server.py", line 62, in run
    result = netsvc.dispatch_rpc(msg[0], msg[1], msg[2:])
  File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/netsvc.py", line 325, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/service/web_services.py", line 580, in dispatch
    res = fn(db, uid, *params)
  File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/osv/osv.py", line 120, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/osv/osv.py", line 172, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/osv/osv.py", line 163, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/osv/orm.py", line 3272, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/osv/orm.py", line 3331, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/home/rvalyi/DEV/openerp/openerp6.1/server/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.


/home/rvalyi/DEV/openerp/openerp6.1/openobject-client/bin/common/common.py:230: GtkWarning: No object called: textbuffer1
  ui.add_objects_from_file(terp_path(openerp_file), objects)


actually, it seems that the GTK is passing something wrong to the server that make it crash because using the web-client the same action works. This is why I set it up as a GTK bug here.

Hope this helps

** Affects: openobject-client
     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/882288

Title:
  [trunk][survey] regression: answering survey with GTK generates a
  server SQL bug

Status in OpenERP GTK Client:
  New

Bug description:
  Hello this is using trunk / 6.1 with revisions:
  client #1986
  server #3776
  addons #5466

  Try to answer the "Odoo feedback" survey with the GK client with
  default demo data. Try to switch from page 1 to page 2.

  On the GTK log you'll get this error:

  Distributor ID:	Ubuntu
  Description:	Ubuntu 11.10
  Release:	11.10
  Codename:	oneiric
  Operating System Release : 3.0.0-12-generic
  Operating System Version : #20-Ubuntu SMP Fri Oct 7 14:56:25 UTC 2011
  Operating System Architecture : 64bit
  Operating System Locale : en_US.UTF-8
  Python Version : 2.7.2+
  OpenERP-Client Version : 6.1dev
  Last revision No. & ID :1986 launchpad_translations_on_behalf_of_openerp-20111025045256-anw0ci19i32luvoo
  Traceback (most recent call last):
    File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/service/netrpc_server.py", line 62, in run
      result = netsvc.dispatch_rpc(msg[0], msg[1], msg[2:])
    File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/netsvc.py", line 325, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/service/web_services.py", line 580, in dispatch
      res = fn(db, uid, *params)
    File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/osv/osv.py", line 120, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/osv/osv.py", line 172, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/osv/osv.py", line 163, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/osv/orm.py", line 3272, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/osv/orm.py", line 3331, in _read_flat
      cr.execute(query, (tuple(sub_ids),))
    File "/home/rvalyi/DEV/openerp/openerp6.1/server/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/home/rvalyi/DEV/openerp/openerp6.1/server/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.

  
  /home/rvalyi/DEV/openerp/openerp6.1/openobject-client/bin/common/common.py:230: GtkWarning: No object called: textbuffer1
    ui.add_objects_from_file(terp_path(openerp_file), objects)

  
  actually, it seems that the GTK is passing something wrong to the server that make it crash because using the web-client the same action works. This is why I set it up as a GTK bug here.

  Hope this helps

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-client/+bug/882288/+subscriptions


Follow ups

References