c2c-oerpscenario team mailing list archive

["sma \(Open ERP\)" <sma@xxxxxxxxxxx>]

Hello barge,

Its fixed in trunk web-client. Please update your code.

Revision-info:
4163 sma@xxxxxxxxxxx-20101223133139-fm0wd992du3cbmwo

Thanks.

** Changed in: openobject-client-web
       Status: In Progress => Fix Released

** Changed in: openobject-client-web
    Milestone: None => 6.0-rc2

-- 
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/693619

Title:
  [trunk] unicode username gives programming error

Status in OpenObject Web Client:
  Fix Released

Bug description:
  when i have a user's name in unicode (korean in my case), it gives below programming error which didn't happen before:


Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py", line 598, in dispatch
    res = fn(db, uid, *params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 1872, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 4095, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer ~~* unknown
Line 1: ...r".id FROM "sale_order" WHERE (sale_order.user_id ilike E'%3...
                                                           ^
Hint:  No operator matches the given name and argument type(s). You might need to add explicit type casts.


As it says in the hint, it seems to be the typecast problem in res.users module.