[6.0] Error message after creation of new database || base_setup : correction on action definition, misses _rec_name

[Paul Korotkov]

I made completely new fresh branched installation from launchpad (server 6.0, addons 6.0, web-client 6.0)
creation of new database results in error below (ususally wizard starts at this point)

Traceback (most recent call last):
  File "/home/prospwro/openerp/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/prospwro/openerp/server/bin/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/home/prospwro/openerp/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/prospwro/openerp/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/prospwro/openerp/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/prospwro/openerp/server/bin/osv/orm.py", line 1630, in fields_view_get
    xml = self.__get_default_search_view(cr, user, context)
  File "/home/prospwro/openerp/server/bin/osv/orm.py", line 1394, in __get_default_search_view
    tree_view = self.fields_view_get(cr, uid, False, 'tree', context=context)
  File "/home/prospwro/openerp/server/bin/osv/orm.py", line 1645, in fields_view_get
    xarch, xfields = self.__view_look_dom_arch(cr, user, result['arch'], view_id, context=ctx)
  File "/home/prospwro/openerp/server/bin/osv/orm.py", line 1336, 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/prospwro/openerp/server/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/home/prospwro/openerp/server/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
СТРОКА 1:select name, model from ir_ui_view where (id=false or inheri...
                                                     ^
ПОДСКАЗКА: No operator matches the given name and argument type(s). You might need to add explicit type casts.

[Paul Korotkov (korotkov-paul)]

This is web-client bug, gtk client creates database normally and starts wizard

[Olivier Lenoir (olivier-lenoir-free)]

It looks like 886697

[Olivier Lenoir (olivier-lenoir-free)]

See 886697, my last comment

[Serpent Consulting Services (serpent-consulting-services)]

Paul,

IMO, this bug should be given HIGH priority(Importance if we talk about launchpad terminology).

Thanks for reporting, herewith are attached 2 merge proposals which contain the proper fix.

Its not the bug of web client, rather its the bug of server/addons altogether.

Addons: Originally, its the bug of module base_setup which misses the 2 important fields view_mode,view_type in the action definition of setup wizard(especially they are needed when the model is osv_memory because we always display the form view).

Server : Mainly the correction on addons will fix the bug. But some bugs are like the Sun(or the Truth), they disappear, but they ain't going away. When the model contains no columns, there will be a real mess. Also when there is no 'name' field in columns and no tree view defined, there will be a problem again(because technically speaking, system assigns _rec_name, but uses self._rec_name).
For a similar bug : see https://bugs.launchpad.net/openobject-server/+bug/878432/comments/5

The attached 2 merge proposals will fix the issues altogether.

Thanks,
Serpent Consulting Services.
http://www.serpentcs.com

[Ravi Gohil (OpenERP) (rgo-openerp)]

Hello Paul Korotkov ,

This problem has been fixed with following branch authored to Serpent Consulting Services:
Branch: lp:~openerp-dev/openobject-addons/6.0-opw-32662-rgo
Revision ID: <email address hidden>
Revision#: 4913

We really appreciate the efforts and fix provided by Serpent Consulting Services.

Regards,
Ravi Gohil.

[Vicente (jviares)]

Sorry, i change server bug status accidentally.

[Olivier Dony (Odoo) (odo-openerp)]

Marking as Invalid for server, as the problem was exposed by a change in web-6.0, that in turn revealed a design issue in an addons.
We should not make the server more lenient for such issues, and here the bug really needs to be corrected in addons.

This problem is now gone if web client 6.0 is updated to a revision after [1], as the change that exposed it has been reverted.
I'm leaving the bug open for addons as there is a valid merge proposal for fixing it, even though it will not be reproducible after [1].

[1] web-6.0 rev.4729 revision-id: <email address hidden>

[Olivier Dony (Odoo) (odo-openerp)]

As mentioned in previous comment, this was fixed in web client 6.0 by rev.4729 rev-id: <email address hidden>

[Olivier Dony (Odoo) (odo-openerp)]

Changing importance of addons affect, since the bug is now fixed in web client and not reproducible anymore.