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

Bug #882288 reported by Raphaël Valyi - http://www.akretion.com
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Confirmed
Undecided
Unassigned

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

Related branches

Revision history for this message
Serpent Consulting Services (serpent-consulting-services) wrote :

I confirm the problem,

Attached fix solves the issue, but there we meet another error.

Looking forward to fix it.

Thanks.

affects: openobject-client → openobject-addons
Changed in openobject-addons:
status: New → Confirmed
Revision history for this message
Serpent Consulting Services (serpent-consulting-services) wrote :

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.

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.