c2c-oerpscenario team mailing list archive

[TeMPO <openerp@xxxxxxxxxxxxxxxxxxx>]

Public bug reported:

Using Web client #4046

with the demo data set the ARS currency to inactive, the ARS currency disapears from the list view
I then set the Active field to NO and do a Search to display again the ARS currency

I get the following traceback

Traceback (most recent call last):
  File "/home/tempo/openobject-server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/tempo/openobject-server/bin/service/web_services.py", line 596, in dispatch
    res = fn(db, uid, *params)
  File "/home/tempo/openobject-server/bin/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/tempo/openobject-server/bin/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/tempo/openobject-server/bin/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/tempo/openobject-server/bin/osv/orm.py", line 1848, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/tempo/openobject-server/bin/osv/orm.py", line 4060, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/home/tempo/openobject-server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/tempo/openobject-server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: ERREUR:  l'opérateur n'existe pas : boolean ~~* unknown
LIGNE 1 : ...id FROM "res_currency" WHERE (res_currency.active ilike E'%0...
                                                               ^
ASTUCE : Aucun opérateur ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.

** Affects: openobject-addons
     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/687259

Title:
  Filtering an inactive currency in Web mode crashes

Status in OpenObject Addons Modules:
  New

Bug description:
  Using Web client #4046

with the demo data set the ARS currency to inactive, the ARS currency disapears from the list view
I then set the Active field to NO and do a Search to display again the ARS currency

I get the following traceback

Traceback (most recent call last):
  File "/home/tempo/openobject-server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/tempo/openobject-server/bin/service/web_services.py", line 596, in dispatch
    res = fn(db, uid, *params)
  File "/home/tempo/openobject-server/bin/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/tempo/openobject-server/bin/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/tempo/openobject-server/bin/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/tempo/openobject-server/bin/osv/orm.py", line 1848, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/tempo/openobject-server/bin/osv/orm.py", line 4060, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/home/tempo/openobject-server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/tempo/openobject-server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: ERREUR:  l'opérateur n'existe pas : boolean ~~* unknown
LIGNE 1 : ...id FROM "res_currency" WHERE (res_currency.active ilike E'%0...
                                                               ^
ASTUCE : Aucun opérateur ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.