After creating a new database object, and menu, accessing the new menu gives an error.

Bug #585199 reported by Carlos Almeida
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Server (MOVED TO GITHUB)
Invalid
Undecided
Unassigned

Bug Description

Open ERP 5.0.10.
How to reproduce:
1. Install new database, minimal profile;
2. Create new object x_object_a, fields x_name;
3. Create menu (for A);
4. Open menu A and insert records;
5. Create new object B (with a many2one field to x_object_a_id);
6. Save and create menu;
7. Accessing the menu gives the following error :(
.......................................................................................................

Traceback (most recent call last):
  File "/home/cmsa/openerp/server/bin/netsvc.py", line 247, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/home/cmsa/openerp/server/bin/netsvc.py", line 76, in __call__
    return getattr(self, method)(*params)
  File "/home/cmsa/openerp/server/bin/service/web_services.py", line 576, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/home/cmsa/openerp/server/bin/osv/osv.py", line 58, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/cmsa/openerp/server/bin/osv/osv.py", line 119, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/cmsa/openerp/server/bin/osv/osv.py", line 111, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/cmsa/openerp/server/bin/osv/orm.py", line 1369, in fields_view_get
    xarch, xfields = self.__view_look_dom_arch(cr, user, result['arch'], view_id, context=context)
  File "/home/cmsa/openerp/server/bin/osv/orm.py", line 1164, in __view_look_dom_arch
    cr.execute('select name, model from ir_ui_view where (id=%s or inherit_id=%s) and arch like %s', (view_id, view_id, '%%%s%%' % field))
  File "/home/cmsa/openerp/server/bin/sql_db.py", line 77, in wrapper
    return f(self, *args, **kwargs)
  File "/home/cmsa/openerp/server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINHA 1: select name, model from ir_ui_view where (id=false or inheri...
                                                     ^
DICA: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Carlos Almeida (cmsa)
description: updated
Revision history for this message
Jay Vora (Serpent Consulting Services) (jayvora) wrote :

Hi CMSA,
I followed the same steps and I could not face the error.
This code gets executed only when there is an inheritance of views.
Please try again and let us know the behaviour.

Thanks.

affects: openobject-client → openobject-server
Changed in openobject-server:
status: New → Invalid
milestone: none → 5.0.11
Revision history for this message
JK (xxxjulianoxxx) wrote :

Jay could you please write step by step how to make this working because i have the same problem as cmsa. Thank in advance

Revision history for this message
Jay Vora (Serpent Consulting Services) (jayvora) wrote :

Hello JK,

There is no such error in real, I assure you.

Tell me the steps you followed.

We would like to clean it,if its really an error.

Thanks for your time.

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.