c2c-oerpscenario team mailing list archive

[Graeme Gellatly <686005@xxxxxxxxxxxxxxxxxx>]

Not sure this is invalid.  Had same issue using latest code, so
installed new database to test and still error opening any views - this
one from sale order - get operator does not exist integer = record

Environment Information : 
System : Linux-2.6.35-22-generic-x86_64-with-Ubuntu-10.10-maverick
OS Name : posix
Distributor ID:	Ubuntu
Description:	Ubuntu 10.10
Release:	10.10
Codename:	maverick
Operating System Release : 2.6.35-22-generic
Operating System Version : #35-Ubuntu SMP Sat Oct 16 20:45:36 UTC 2010
Operating System Architecture : 64bit
Operating System Locale : en_NZ.UTF8
Python Version : 2.6.6
OpenERP-Client Version : 6.0.0-rc1-1
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/home/graemeg/workspace/openerp-server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/graemeg/workspace/openerp-server/bin/service/web_services.py", line 596, in dispatch
    res = fn(db, uid, *params)
  File "/home/graemeg/workspace/openerp-server/bin/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/graemeg/workspace/openerp-server/bin/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/graemeg/workspace/openerp-server/bin/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/graemeg/workspace/openerp-server/bin/osv/orm.py", line 1672, in fields_view_get
    cr.execute(query, params)
  File "/home/graemeg/workspace/openerp-server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/graemeg/workspace/openerp-server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = record
LINE 1: ...parent,id,type,inherit_id FROM ir_ui_view WHERE id=(662, E's...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

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

Title:
  [Trunk] Views don't work anymore

Status in OpenObject Server:
  Invalid

Bug description:
  Hi,

On the last trunk version, there is a big problem.

On all views, I have the error : 

[2010-12-06 16:06:05,931][alfea] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/home/laurent/workspace/OpenERP trunk server/bin/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/laurent/workspace/OpenERP trunk server/bin/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/laurent/workspace/OpenERP trunk server/bin/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/laurent/workspace/OpenERP trunk server/bin/osv/orm.py", line 1672, in fields_view_get
    cr.execute(query, params)
  File "/home/laurent/workspace/OpenERP trunk server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/laurent/workspace/OpenERP trunk server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
DataError: invalid input syntax for integer: "CRM - Leads Search"
LINE 1: ...pe,inherit_id FROM ir_ui_view WHERE id=ARRAY[521, E'CRM - Le...
                                                             ^

> /home/laurent/workspace/OpenERP trunk server/bin/sql_db.py(129)execute()
-> res = self._obj.execute(query, params)