ProgrammingError: operator does not exist: integer = record

Bug #691408 reported by OpenBMS JSC
20
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Odoo Server (MOVED TO GITHUB)
Fix Released
Medium
OpenERP's Framework R&D

Bug Description

When accessing "Administration => Modules => Modules", it generates error below

addons/ : 4017 <email address hidden>
addons-community/ : 292 fran@fran-pc-20101213182241-2fogs8yh5u4ma31q
addons-extra/ : 5098 <email address hidden>
server/ : 3120 <email address hidden>

Environment Information :
System : Windows-XP-5.1.2600-SP3
OS Name : nt
Operating System Release : XP
Operating System Version : 5.1.2600
Operating System Architecture : 32bit
Operating System Locale : en_AU.cp1252
Python Version : 2.5.2
OpenERP-Client Version : 6.0.0-rc1-1
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/var/local/software/openerp-v6.0dev/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/var/local/software/openerp-v6.0dev/server/bin/service/web_services.py", line 598, in dispatch
    res = fn(db, uid, *params)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 1688, in fields_view_get
    cr.execute(query, params)
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = record
LINE 1: ...,id,type,inherit_id,model FROM ir_ui_view WHERE id=(98, E'ir...
                                                             ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Changed in openobject-server:
status: New → Confirmed
assignee: nobody → OpenERP's Framework R&D (openerp-dev-framework)
Revision history for this message
Somesh Khare (somesh.khare) wrote :

Hello,

This bug occurred when I used the Client on XP and Server on linux.

Thanks

Changed in openobject-server:
importance: Undecided → Medium
Revision history for this message
OpenBMS JSC (openbmsjsc) wrote :

There are several places where this bug happens, e.g. it also happens in "Warehouse => Product => Products".
I think this should be justify for "High" priority as it stop a lot of functionality from being usable.

Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

This is because there was an old bug in GTK client that was fixed recently, and thus the workaround has been removed from the server. But of course if you are using an old GTK client with a recent server you will get this error.

The fix happened with revisions:
GTK: rev 1704 <email address hidden>
Server: rev 3071 <email address hidden>

I suppose your problem is that you are working with the GTK 6.0-rc1 version, and with a more recent server

Possible workarounds for those that have this issue:
 - wait for an updated version of GTK client build for windows (6.0-rc2 is coming before end of the month)
 - patch your windows GTK client with the bin/modules/action/main.py file of a more recent GTK version
 - or downgrade your server to a revision before 3071: e.g. bzr up -r 3070

I hope this helps...

Changed in openobject-server:
milestone: none → 6.0-rc2
status: Confirmed → Fix Released
Revision history for this message
Cristian Salamea (ovnicraft) wrote :

@Olivier yes the error comes from client but in Windows RC1 from site is not updated i built my own but i getting problems with delete button in O2M fields, can OpenERP provide us a Windows Client updated with this fix, many people udpate the server but in windows as final user cant update the client.

Regards,

Revision history for this message
OpenBMS JSC (openbmsjsc) wrote :

I cannot find bin/modules/action/main.py in the Windows GTK client. Could you please provide me with a more specific information?

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

Duplicates of this bug

Other bug subscribers

Remote bug watches

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