openerp-india team mailing list archive

Thread
Date
[Bug 939526] Re: unaccent() is applied to integer fields

To: openerp-india@xxxxxxxxxxxxxxxxxxx
From: "Vo Minh Thu \(OpenERP\)" <939526@xxxxxxxxxxxxxxxxxx>
Date: Thu, 23 Feb 2012 21:07:34 -0000
Reply-to: Bug 939526 <939526@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
** Summary changed:

- unaccent seems to break certain interfaces
+ unaccent() is applied to integer fields

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/939526

Title:
  unaccent() is applied to integer fields

Status in OpenERP Server:
  New

Bug description:
  Thought I'd try to add --unaccent to the server command line after enabling the extension on an existing database.
  (perhaps it needs to be added immediately after création and prior to any operation)..
  starting the server without --unaccent seems to work fine.

  Via the web interface as admin, I selected 'Settings' and received no
  configuration and the following output:

  2012-02-23 13:57:21,092 23948 INFO ? werkzeug: 127.0.0.1 - - [23/Feb/2012 13:57:21] "GET /web/static/src/img/icons/terp-go-year.png HTTP/1.1" 200 -
  2012-02-23 13:57:21,095 23948 INFO ? werkzeug: 127.0.0.1 - - [23/Feb/2012 13:57:21] "GET /web/static/src/img/icons/terp-gtk-go-back-rtl.png HTTP/1.1" 304 -
  2012-02-23 13:57:21,096 23948 INFO ? werkzeug: 127.0.0.1 - - [23/Feb/2012 13:57:21] "GET /web/static/src/img/icons/terp-go-month.png HTTP/1.1" 200 -
  2012-02-23 13:57:21,099 23948 INFO ? werkzeug: 127.0.0.1 - - [23/Feb/2012 13:57:21] "GET /web/static/src/img/icons/terp-go-home.png HTTP/1.1" 200 -
  2012-02-23 13:57:21,101 23948 INFO ? werkzeug: 127.0.0.1 - - [23/Feb/2012 13:57:21] "GET /web/static/src/img/icons/terp-partner.png HTTP/1.1" 200 -
  2012-02-23 13:57:21,105 23948 INFO ? werkzeug: 127.0.0.1 - - [23/Feb/2012 13:57:21] "GET /web/static/src/img/icons/terp-accessories-archiver.png HTTP/1.1" 200 -
  2012-02-23 13:57:21,106 23948 INFO ? werkzeug: 127.0.0.1 - - [23/Feb/2012 13:57:21] "GET /web/static/src/img/icons/terp-stock_symbol-selection.png HTTP/1.1" 200 -
  2012-02-23 13:57:21,107 23948 INFO ? werkzeug: 127.0.0.1 - - [23/Feb/2012 13:57:21] "GET /web/static/src/img/icons/terp-gtk-jump-to-rtl.png HTTP/1.1" 200 -
  2012-02-23 13:57:21,110 23948 INFO ? werkzeug: 127.0.0.1 - - [23/Feb/2012 13:57:21] "GET /web/static/src/img/icons/terp-stock_effects-object-colorize.png HTTP/1.1" 200 -
  2012-02-23 13:57:21,112 23948 INFO ? werkzeug: 127.0.0.1 - - [23/Feb/2012 13:57:21] "GET /web/static/src/img/icons/terp-go-today.png HTTP/1.1" 200 -
  2012-02-23 13:57:21,115 23948 INFO ? werkzeug: 127.0.0.1 - - [23/Feb/2012 13:57:21] "GET /web/static/src/img/ui/field_calendar.png HTTP/1.1" 200 -
  2012-02-23 13:57:21,207 23948 ERROR ? openerp.sql_db: Programming error: function unaccent(integer) does not exist
  LINE 1: ... (report_stock_move."day" > '2012-02-08'))  AND  (unaccent(r...
                                                               ^
  HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
  , in query SELECT "report_stock_move".id FROM "report_stock_move" WHERE (((((((((report_stock_move."type" = %s)  AND  (report_stock_move."day" <= %s))  AND  (report_stock_move."day" > %s))  AND  (unaccent(report_stock_move."product_id") ilike unaccent(%s)))  AND  (unaccent(report_stock_move."partner_id") ilike unaccent(%s)))  AND  (unaccent(report_stock_move."location_id") ilike unaccent(%s)))  AND  (unaccent(report_stock_move."location_dest_id") ilike unaccent(%s)))  AND  (unaccent(report_stock_move."categ_id") ilike unaccent(%s)))  AND  (unaccent(report_stock_move."stock_journal") ilike unaccent(%s))) ORDER BY id 
  2012-02-23 13:57:21,208 23948 ERROR ? openerp.osv.osv: Uncaught exception
  Traceback (most recent call last):
    File "/usr/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/osv/osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/osv/osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/usr/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/osv/orm.py", line 2241, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/usr/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/osv/orm.py", line 4561, 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/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/sql_db.py", line 152, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: function unaccent(integer) does not exist
  LINE 1: ... (report_stock_move."day" > '2012-02-08'))  AND  (unaccent(r...
                                                               ^
  HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

  2012-02-23 13:57:21,211 23948 ERROR ? openerp.netsvc: function unaccent(integer) does not exist
  LINE 1: ... (report_stock_move."day" > '2012-02-08'))  AND  (unaccent(r...
                                                               ^
  HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

  2012-02-23 13:57:21,216 23948 INFO ? werkzeug: 127.0.0.1 - - [23/Feb/2012 13:57:21] "POST /web/dataset/search_read HTTP/1.1" 200 -
  2012-02-23 13:57:21,235 23948 ERROR ? openerp.sql_db: Programming error: function unaccent(integer) does not exist
  LINE 1: ... (report_stock_move."day" > '2012-02-08'))  AND  (unaccent(r...
                                                               ^
  HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
  , in query SELECT "report_stock_move".id FROM "report_stock_move" WHERE (((((((((report_stock_move."type" = %s)  AND  (report_stock_move."day" <= %s))  AND  (report_stock_move."day" > %s))  AND  (unaccent(report_stock_move."product_id") ilike unaccent(%s)))  AND  (unaccent(report_stock_move."partner_id") ilike unaccent(%s)))  AND  (unaccent(report_stock_move."location_id") ilike unaccent(%s)))  AND  (unaccent(report_stock_move."location_dest_id") ilike unaccent(%s)))  AND  (unaccent(report_stock_move."categ_id") ilike unaccent(%s)))  AND  (unaccent(report_stock_move."stock_journal") ilike unaccent(%s))) ORDER BY id 
  2012-02-23 13:57:21,236 23948 ERROR ? openerp.osv.osv: Uncaught exception
  Traceback (most recent call last):
    File "/usr/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/osv/osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/osv/osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/usr/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/osv/orm.py", line 2241, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/usr/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/osv/orm.py", line 4561, 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/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/sql_db.py", line 152, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/lib/python2.6/site-packages/openerp-6.1-py2.6.egg/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: function unaccent(integer) does not exist
  LINE 1: ... (report_stock_move."day" > '2012-02-08'))  AND  (unaccent(r...
                                                               ^
  HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

  2012-02-23 13:57:21,236 23948 ERROR ? openerp.netsvc: function unaccent(integer) does not exist
  LINE 1: ... (report_stock_move."day" > '2012-02-08'))  AND  (unaccent(r...
                                                               ^
  HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/939526/+subscriptions
References

[Bug 939526] [NEW] unaccent seems to break certain interfaces
From: risto3, 2012-02-23