← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 689947] [NEW] [trunk] Can't list modules

 

Public bug reported:

Go to Sales / Sales / Sales Orders; get an exception:

operator does not exist: integer = record
LINE 1: ...parent,id,type,inherit_id FROM ir_ui_view WHERE id=(687, E's...
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Same happens if to go Administration / Modules / Modules.

bzr update reports that the server revision is 3103 and the addons
revision is 4711.

-----------------------------------------------------------------
The steps to set up for this bug were:

1. Installed Python 2.6, Postgresql 8.4 on Centos 5.5 as per instructions from here:
https://powerphil.wordpress.com/2010/12/01/how-to-install-openerp-6-on-centos/

2. Got the latest from trunk using:
bzr branch lp:~openerp/openobject-server/trunk
bzr branch lp:openobject-addons

3. Started the server.

4. Connect using the OpenERP GTK Client 6.0RC1 running on Windows 7
64-bit.

5. Created a new empty database ("openerp6trunk1") with extended UI, NO
demo data.

6. At the "Install Applications" screen, selected these to install:
  - Customer Relationship Management
  - Warehouse Management
  - Invoicing
  - Purchase Management
  - Extra Tools
  - Point of Sales
  - Sales Management
  - Accounting & Finance
  - Advanced Reporting
and clicked "Install".
-----------------------------------------------------------------

The exception report was:

Environment Information : 
System : Windows-Vista-6.1.7600
OS Name : nt
Operating System Release : Vista
Operating System Version : 6.1.7600
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 "/home/philu/work/openerp6/trunk/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/philu/work/openerp6/trunk/bin/service/web_services.py", line 598, in dispatch
    res = fn(db, uid, *params)
  File "/home/philu/work/openerp6/trunk/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/philu/work/openerp6/trunk/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/philu/work/openerp6/trunk/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/philu/work/openerp6/trunk/bin/osv/orm.py", line 1685, in fields_view_get
    cr.execute(query, params)
  File "/home/philu/work/openerp6/trunk/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/philu/work/openerp6/trunk/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=(687, E's...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

-----------------------------------

Excerpt from the Server log file:

[2010-12-14 10:27:23,297][?] DEBUG_RPC:service:'object'
[2010-12-14 10:27:23,298][?] DEBUG_RPC:method:'execute'
[2010-12-14 10:27:23,299][?] DEBUG_RPC:params:['openerp6trunk1',
[2010-12-14 10:27:23,300][?] DEBUG_RPC:params: 1,
[2010-12-14 10:27:23,300][?] DEBUG_RPC:params: '*',
[2010-12-14 10:27:23,300][?] DEBUG_RPC:params: 'ir.values',
[2010-12-14 10:27:23,301][?] DEBUG_RPC:params: 'get',
[2010-12-14 10:27:23,301][?] DEBUG_RPC:params: 'action',
[2010-12-14 10:27:23,301][?] DEBUG_RPC:params: 'tree_but_open',
[2010-12-14 10:27:23,301][?] DEBUG_RPC:params: [...],
[2010-12-14 10:27:23,302][?] DEBUG_RPC:params: False,
[2010-12-14 10:27:23,302][?] DEBUG_RPC:params: {...}]
[2010-12-14 10:27:23,537][?] DEBUG_RPC:service:'object'
[2010-12-14 10:27:23,537][?] DEBUG_RPC:method:'execute'
[2010-12-14 10:27:23,538][?] DEBUG_RPC:params:['openerp6trunk1',
[2010-12-14 10:27:23,539][?] DEBUG_RPC:params: 1,
[2010-12-14 10:27:23,539][?] DEBUG_RPC:params: '*',
[2010-12-14 10:27:23,539][?] DEBUG_RPC:params: u'sale.order',
[2010-12-14 10:27:23,540][?] DEBUG_RPC:params: 'fields_view_get',
[2010-12-14 10:27:23,540][?] DEBUG_RPC:params: (...),
[2010-12-14 10:27:23,540][?] DEBUG_RPC:params: 'search',
[2010-12-14 10:27:23,541][?] DEBUG_RPC:params: {...}]
[2010-12-14 10:27:23,543][openerp6trunk1] ERROR:db.cursor:Programming error: operator does not exist: integer = record
LINE 1: ...parent,id,type,inherit_id FROM ir_ui_view WHERE id=(687, E's...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
, in query SELECT arch,name,field_parent,id,type,inherit_id FROM ir_ui_view WHERE id=%s AND model=%s
[2010-12-14 10:27:23,544][openerp6trunk1] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/home/philu/work/openerp6/trunk/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/philu/work/openerp6/trunk/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/philu/work/openerp6/trunk/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/philu/work/openerp6/trunk/bin/osv/orm.py", line 1685, in fields_view_get
    cr.execute(query, params)
  File "/home/philu/work/openerp6/trunk/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/philu/work/openerp6/trunk/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=(687, E's...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

[2010-12-14 10:27:23,545][openerp6trunk1] DEBUG_RPC:exception:u"operator does not exist: integer = record\nLINE 1: ...parent,id,type,inherit_id FROM ir_ui_view WHERE id=(687, E's...\n                                                             ^\nHINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.\n"
[2010-12-14 10:27:23,546][openerp6trunk1] DEBUG:web-services:netrpc: rpc-dispatching exception
Traceback (most recent call last):
  File "/home/philu/work/openerp6/trunk/bin/service/netrpc_server.py", line 70, in run
    result = self.dispatch(msg[0], msg[1], msg[2:])
  File "/home/philu/work/openerp6/trunk/bin/netsvc.py", line 499, in dispatch
    raise OpenERPDispatcherException(e, tb_s)
OpenERPDispatcherException
[2010-12-14 10:27:23,653][?] DEBUG_RPC:service:'object'
[2010-12-14 10:27:23,654][?] DEBUG_RPC:method:'execute'
[2010-12-14 10:27:23,654][?] DEBUG_RPC:params:['openerp6trunk1', 1, '*', 'maintenance.contract', 'status']

-----------------------------------

Excerpt from Postgres log file from when double-clicked on "Sales":


LOG:  statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED
LOG:  statement: select id,name,value,object,meta, key from ir_values where key=E'action' and model=E'ir.ui.menu' and key2=E'tree_bu
t_open' and (res_id=306 or (res_id is null)) and (user_id=1 or (user_id IS NULL)) order by id
LOG:  statement: SELECT ir_act_window.domain,ir_act_window.help,ir_act_window.auto_search,ir_act_window.res_model,ir_act_window.view
_id,ir_act_window.search_view_id,ir_act_window.auto_refresh,ir_act_window.view_mode,ir_act_window.name,ir_act_window.multi,ir_act_wi
ndow.target,ir_act_window.src_model,ir_act_window.view_type,ir_act_window.filter,ir_act_window.menus,ir_act_window.limit,ir_act_wind
ow.context,ir_act_window.usage,ir_act_window.type,ir_act_window.id FROM "ir_act_window" WHERE ir_act_window.id IN (439) ORDER BY nam
e
LOG:  statement: SELECT ir_act_window_group_rel.gid, ir_act_window_group_rel.act_id                    FROM ir_act_window_group_rel, "res_groups"                   WHERE ir_act_window_group_rel.act_id IN (439)                     AND ir_act_window_group_rel.gid =
res_groups.id                                                                         OFFSET 0
LOG:  statement: SELECT "ir_act_window_view".id FROM "ir_act_window_view" WHERE (ir_act_window_view.act_window_id in (439)) ORDER BY sequence
LOG:  statement: SELECT ir_act_window.domain,ir_act_window.help,ir_act_window.auto_search,ir_act_window.res_model,ir_act_window.view_id,ir_act_window.search_view_id,ir_act_window.auto_refresh,ir_act_window.view_mode,ir_act_window.name,ir_act_window.multi,ir_act_window.target,ir_act_window.src_model,ir_act_window.view_type,ir_act_window.filter,ir_act_window.menus,ir_act_window.limit,ir_act_window.context,ir_act_window.usage,ir_act_window.type,ir_act_window.id FROM "ir_act_window" WHERE ir_act_window.id IN (439) ORDER BY name
LOG:  statement: SELECT ir_ui_view.name,ir_ui_view.id FROM "ir_ui_view" WHERE ir_ui_view.id IN (687) ORDER BY priority,name
LOG:  statement: SELECT "ir_act_window_view".id FROM "ir_act_window_view" WHERE (ir_act_window_view.act_window_id in (439)) ORDER BY sequence
LOG:  statement: SELECT res_users.menu_id,res_users.address_id,res_users.share,res_users.menu_tips,res_users.active,res_users.date,res_users.context_lang,res_users.password,res_users.context_tz,res_users.name,res_users.context_section_id,res_users.company_id,res_users.signature,res_users.login,res_users.action_id,res_users.email,res_users.id FROM "res_users" WHERE res_users.id IN (1) ORDER BY name
LOG:  statement: COMMIT
LOG:  statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED
LOG:  statement: SELECT arch,name,field_parent,id,type,inherit_id FROM ir_ui_view WHERE id=(687, E'sale.order.list.select') AND model=E'sale.order'
ERROR:  operator does not exist: integer = record at character 74
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT:  SELECT arch,name,field_parent,id,type,inherit_id FROM ir_ui_view WHERE id=(687, E'sale.order.list.select') AND model=E'sale.order'
LOG:  statement: ROLLBACK

--------------------------------------------------------------------

** Affects: openobject-server
     Importance: Undecided
         Status: New

-- 
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/689947

Title:
  [trunk] Can't list modules

Status in OpenObject Server:
  New

Bug description:
  Go to Sales / Sales / Sales Orders; get an exception:

operator does not exist: integer = record
LINE 1: ...parent,id,type,inherit_id FROM ir_ui_view WHERE id=(687, E's...
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Same happens if to go Administration / Modules / Modules.

bzr update reports that the server revision is 3103 and the addons revision is 4711.

-----------------------------------------------------------------
The steps to set up for this bug were:

1. Installed Python 2.6, Postgresql 8.4 on Centos 5.5 as per instructions from here:
https://powerphil.wordpress.com/2010/12/01/how-to-install-openerp-6-on-centos/

2. Got the latest from trunk using:
bzr branch lp:~openerp/openobject-server/trunk
bzr branch lp:openobject-addons

3. Started the server.

4. Connect using the OpenERP GTK Client 6.0RC1 running on Windows 7 64-bit.

5. Created a new empty database ("openerp6trunk1") with extended UI, NO demo data.

6. At the "Install Applications" screen, selected these to install:
  - Customer Relationship Management
  - Warehouse Management
  - Invoicing
  - Purchase Management
  - Extra Tools
  - Point of Sales
  - Sales Management
  - Accounting & Finance
  - Advanced Reporting
and clicked "Install".
-----------------------------------------------------------------

The exception report was:

Environment Information : 
System : Windows-Vista-6.1.7600
OS Name : nt
Operating System Release : Vista
Operating System Version : 6.1.7600
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 "/home/philu/work/openerp6/trunk/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/philu/work/openerp6/trunk/bin/service/web_services.py", line 598, in dispatch
    res = fn(db, uid, *params)
  File "/home/philu/work/openerp6/trunk/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/philu/work/openerp6/trunk/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/philu/work/openerp6/trunk/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/philu/work/openerp6/trunk/bin/osv/orm.py", line 1685, in fields_view_get
    cr.execute(query, params)
  File "/home/philu/work/openerp6/trunk/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/philu/work/openerp6/trunk/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=(687, E's...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

-----------------------------------

Excerpt from the Server log file:

[2010-12-14 10:27:23,297][?] DEBUG_RPC:service:'object'
[2010-12-14 10:27:23,298][?] DEBUG_RPC:method:'execute'
[2010-12-14 10:27:23,299][?] DEBUG_RPC:params:['openerp6trunk1',
[2010-12-14 10:27:23,300][?] DEBUG_RPC:params: 1,
[2010-12-14 10:27:23,300][?] DEBUG_RPC:params: '*',
[2010-12-14 10:27:23,300][?] DEBUG_RPC:params: 'ir.values',
[2010-12-14 10:27:23,301][?] DEBUG_RPC:params: 'get',
[2010-12-14 10:27:23,301][?] DEBUG_RPC:params: 'action',
[2010-12-14 10:27:23,301][?] DEBUG_RPC:params: 'tree_but_open',
[2010-12-14 10:27:23,301][?] DEBUG_RPC:params: [...],
[2010-12-14 10:27:23,302][?] DEBUG_RPC:params: False,
[2010-12-14 10:27:23,302][?] DEBUG_RPC:params: {...}]
[2010-12-14 10:27:23,537][?] DEBUG_RPC:service:'object'
[2010-12-14 10:27:23,537][?] DEBUG_RPC:method:'execute'
[2010-12-14 10:27:23,538][?] DEBUG_RPC:params:['openerp6trunk1',
[2010-12-14 10:27:23,539][?] DEBUG_RPC:params: 1,
[2010-12-14 10:27:23,539][?] DEBUG_RPC:params: '*',
[2010-12-14 10:27:23,539][?] DEBUG_RPC:params: u'sale.order',
[2010-12-14 10:27:23,540][?] DEBUG_RPC:params: 'fields_view_get',
[2010-12-14 10:27:23,540][?] DEBUG_RPC:params: (...),
[2010-12-14 10:27:23,540][?] DEBUG_RPC:params: 'search',
[2010-12-14 10:27:23,541][?] DEBUG_RPC:params: {...}]
[2010-12-14 10:27:23,543][openerp6trunk1] ERROR:db.cursor:Programming error: operator does not exist: integer = record
LINE 1: ...parent,id,type,inherit_id FROM ir_ui_view WHERE id=(687, E's...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
, in query SELECT arch,name,field_parent,id,type,inherit_id FROM ir_ui_view WHERE id=%s AND model=%s
[2010-12-14 10:27:23,544][openerp6trunk1] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/home/philu/work/openerp6/trunk/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/philu/work/openerp6/trunk/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/philu/work/openerp6/trunk/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/philu/work/openerp6/trunk/bin/osv/orm.py", line 1685, in fields_view_get
    cr.execute(query, params)
  File "/home/philu/work/openerp6/trunk/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/philu/work/openerp6/trunk/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=(687, E's...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

[2010-12-14 10:27:23,545][openerp6trunk1] DEBUG_RPC:exception:u"operator does not exist: integer = record\nLINE 1: ...parent,id,type,inherit_id FROM ir_ui_view WHERE id=(687, E's...\n                                                             ^\nHINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.\n"
[2010-12-14 10:27:23,546][openerp6trunk1] DEBUG:web-services:netrpc: rpc-dispatching exception
Traceback (most recent call last):
  File "/home/philu/work/openerp6/trunk/bin/service/netrpc_server.py", line 70, in run
    result = self.dispatch(msg[0], msg[1], msg[2:])
  File "/home/philu/work/openerp6/trunk/bin/netsvc.py", line 499, in dispatch
    raise OpenERPDispatcherException(e, tb_s)
OpenERPDispatcherException
[2010-12-14 10:27:23,653][?] DEBUG_RPC:service:'object'
[2010-12-14 10:27:23,654][?] DEBUG_RPC:method:'execute'
[2010-12-14 10:27:23,654][?] DEBUG_RPC:params:['openerp6trunk1', 1, '*', 'maintenance.contract', 'status']

-----------------------------------

Excerpt from Postgres log file from when double-clicked on "Sales":


LOG:  statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED
LOG:  statement: select id,name,value,object,meta, key from ir_values where key=E'action' and model=E'ir.ui.menu' and key2=E'tree_bu
t_open' and (res_id=306 or (res_id is null)) and (user_id=1 or (user_id IS NULL)) order by id
LOG:  statement: SELECT ir_act_window.domain,ir_act_window.help,ir_act_window.auto_search,ir_act_window.res_model,ir_act_window.view
_id,ir_act_window.search_view_id,ir_act_window.auto_refresh,ir_act_window.view_mode,ir_act_window.name,ir_act_window.multi,ir_act_wi
ndow.target,ir_act_window.src_model,ir_act_window.view_type,ir_act_window.filter,ir_act_window.menus,ir_act_window.limit,ir_act_wind
ow.context,ir_act_window.usage,ir_act_window.type,ir_act_window.id FROM "ir_act_window" WHERE ir_act_window.id IN (439) ORDER BY nam
e
LOG:  statement: SELECT ir_act_window_group_rel.gid, ir_act_window_group_rel.act_id                    FROM ir_act_window_group_rel, "res_groups"                   WHERE ir_act_window_group_rel.act_id IN (439)                     AND ir_act_window_group_rel.gid =
res_groups.id                                                                         OFFSET 0
LOG:  statement: SELECT "ir_act_window_view".id FROM "ir_act_window_view" WHERE (ir_act_window_view.act_window_id in (439)) ORDER BY sequence
LOG:  statement: SELECT ir_act_window.domain,ir_act_window.help,ir_act_window.auto_search,ir_act_window.res_model,ir_act_window.view_id,ir_act_window.search_view_id,ir_act_window.auto_refresh,ir_act_window.view_mode,ir_act_window.name,ir_act_window.multi,ir_act_window.target,ir_act_window.src_model,ir_act_window.view_type,ir_act_window.filter,ir_act_window.menus,ir_act_window.limit,ir_act_window.context,ir_act_window.usage,ir_act_window.type,ir_act_window.id FROM "ir_act_window" WHERE ir_act_window.id IN (439) ORDER BY name
LOG:  statement: SELECT ir_ui_view.name,ir_ui_view.id FROM "ir_ui_view" WHERE ir_ui_view.id IN (687) ORDER BY priority,name
LOG:  statement: SELECT "ir_act_window_view".id FROM "ir_act_window_view" WHERE (ir_act_window_view.act_window_id in (439)) ORDER BY sequence
LOG:  statement: SELECT res_users.menu_id,res_users.address_id,res_users.share,res_users.menu_tips,res_users.active,res_users.date,res_users.context_lang,res_users.password,res_users.context_tz,res_users.name,res_users.context_section_id,res_users.company_id,res_users.signature,res_users.login,res_users.action_id,res_users.email,res_users.id FROM "res_users" WHERE res_users.id IN (1) ORDER BY name
LOG:  statement: COMMIT
LOG:  statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED
LOG:  statement: SELECT arch,name,field_parent,id,type,inherit_id FROM ir_ui_view WHERE id=(687, E'sale.order.list.select') AND model=E'sale.order'
ERROR:  operator does not exist: integer = record at character 74
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT:  SELECT arch,name,field_parent,id,type,inherit_id FROM ir_ui_view WHERE id=(687, E'sale.order.list.select') AND model=E'sale.order'
LOG:  statement: ROLLBACK

--------------------------------------------------------------------





Follow ups

References