c2c-oerpscenario team mailing list archive

[hardboiledbaby <693619@xxxxxxxxxxxxxxxxxx>]

Thank you.

I have tested some more and found out that this only happens in web-
client

Below are procedures to reproduce the error:

1.  Save the user's name in unicode (korean)

2. Enter either 'Sales Order" or "Purchase Order" window. (The default
Search screen)

3. The Programming error.

I have tested this with latest GTK-client from launchpad and it works
fine.


2010. 12. 23., 오후 3:37, Saz(OpenERP) 작성:

> 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 direct subscriber
> of the bug.
> 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.
> 
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/openobject-server/+bug/693619/+subscribe

-- 
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.