← Back to team overview

c2c-oerpscenario team mailing list archive

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

 

Raphaël,

The errors come into a sequence one by one. Fixing one would give you a
hint of another error.

The merge attached here does:
1. Fixes the very first error you reported.
2. Fixes the problem of fetching address from user record, which is no more a case in 6.1.
3. Fixes the problem of default_get() at the end of the survey.
4. Correction over the YML string.
5. Better notification as an email message with enhanced body mEssage.

Thanks,
Serpent Consulting Services.

-- 
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 Addons (modules):
  Confirmed

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-addons/+bug/882288/+subscriptions


References