c2c-oerpscenario team mailing list archive

Thread
Date
[Bug 689947] Re: [trunk] Can't list modules

To: c2c-oerpscenario@xxxxxxxxxxxxxxxxxxx
From: "Saz\(OpenERP\)" <689947@xxxxxxxxxxxxxxxxxx>
Date: Thu, 16 Dec 2010 09:17:24 -0000
Reply-to: Bug 689947 <689947@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Hello,

I have tested your scenario at my end with the latest code and it works
fine at my end. Would you please check the issue again with the latest
bzr install on your cent o.s server as it may be problematic due to some
missing packages of bzr. For the sake of clarity in launchpad i am
closing this bug.

Thanks.

** Changed in: openobject-server
       Status: Triaged => Invalid

-- 
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:
  Invalid

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

--------------------------------------------------------------------
References

[Bug 689947] [NEW] [trunk] Can't list modules
From: philu, 2010-12-13