c2c-oerpscenario team mailing list archive

["Nicolas Vanhoren \(OpenERP\)" <861350@xxxxxxxxxxxxxxxxxx>]

This error is caused by the openerp server throwing an exception when we
specify an ilike with an empty string on a many2one.

** Also affects: openobject-server
   Importance: Undecided
       Status: New

** Changed in: openobject-server
       Status: New => Confirmed

** Changed in: openobject-server
   Importance: Undecided => Medium

** Changed in: openobject-server
     Assignee: (unassigned) => Olivier Dony (OpenERP) (odo-openerp)

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/861350

Title:
  bug with advanced  filters

Status in OpenERP Web:
  Invalid
Status in OpenERP GTK Client:
  Fix Released
Status in OpenERP Server:
  Confirmed

Bug description:
  in a search view click on advanced filters _> bug :

  Client Traceback (most recent call last):
    File "/home/aline/openerp/web/openerp-web/addons/web/common/dispatch.py", line 161, in dispatch
      response["result"] = method(controller, self, **self.params)
    File "/home/aline/openerp/web/openerp-web/addons/web/controllers/main.py", line 628, in search_read
      return self.do_search_read(req, model, fields, offset, limit, domain, sort)
    File "/home/aline/openerp/web/openerp-web/addons/web/controllers/main.py", line 653, in do_search_read
      ids = Model.search(domain, 0, False, sort or False, context)
    File "/home/aline/openerp/web/openerp-web/addons/web/common/openerplib/main.py", line 367, in proxy
      *args)
    File "/home/aline/openerp/web/openerp-web/addons/web/common/openerplib/main.py", line 244, in proxy
      result = self.connector.send(self.service_name, method, *args)
    File "/home/aline/openerp/web/openerp-web/addons/web/common/openerplib/main.py", line 214, in send
      raise fault

  Server Traceback (most recent call last):
    File "/home/aline/openerp/server/trunk/openerp/netsvc.py", line 411, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/home/aline/openerp/server/trunk/openerp/service/web_services.py", line 575, in dispatch
      res = fn(db, uid, *params)
    File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 119, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 173, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 2138, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 4347, 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/aline/openerp/server/trunk/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/home/aline/openerp/server/trunk/openerp/sql_db.py", line 215, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: ERREUR:  l'opérateur n'existe pas : integer ~~* unknown
  LIGNE 1 : ...er."user_id" = 1)  AND  ((sale_order."project_id" ilike E'%%...
                                                                 ^
  ASTUCE : Aucun opérateur ne correspond au nom donné et aux types d'arguments.
  Vous devez ajouter des conversions explicites de type.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openerp-web/+bug/861350/+subscriptions