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 OpenERP
sa GTK client R&D, which is a bug assignee.
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
_______________________________________________
Mailing list: https://launchpad.net/~openerp-dev-gtk
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-dev-gtk
More help : https://help.launchpad.net/ListHelp
