c2c-oerpscenario team mailing list archive

["Saz\(OpenERP\)" <693619@xxxxxxxxxxxxxxxxxx>]

Hello,

I have tested your scenario with the latest code and it is working fine
at my end. I have made the user with Unicode character name "$%%&*" and
also with korean "태양". In both cases it is working good. This might be
possible when you are using the outdated gtk-client with latest server.
Would you please check the issue with the latest code and notify me, if
problem still persists at your end.

Thanks.

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

-- 
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 Server:
  Invalid

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.