openerp-india team mailing list archive

Thread
Date
[Bug 939526] [NEW] unaccent seems to break certain interfaces

To: openerp-india@xxxxxxxxxxxxxxxxxxx
From: risto3 <939526@xxxxxxxxxxxxxxxxxx>
Date: Thu, 23 Feb 2012 14:05:12 -0000
Reply-to: Bug 939526 <939526@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

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.

** Affects: openobject-server
     Importance: Undecided
         Status: New


** Tags: unaccent

-- 
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 seems to break certain interfaces

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
Follow ups

[Bug 939526] Re: unaccent() is applied to integer fields
From: Amit Parik (OpenERP), 2012-06-07
[Bug 939526] Re: unaccent() is applied to integer fields
From: risto3, 2012-05-24
[Bug 939526] Re: unaccent() is applied to integer fields
From: Amit Parik (OpenERP), 2012-05-24
[Bug 939526] Re: unaccent() is applied to integer fields
From: Amit Parik (OpenERP), 2012-04-09
[Bug 939526] Re: unaccent() is applied to integer fields
From: Vo Minh Thu (OpenERP), 2012-02-23
[Bug 939526] Re: unaccent seems to break certain interfaces
From: risto3, 2012-02-23
[Bug 939526] [NEW] unaccent seems to break certain interfaces
From: risto3, 2012-02-23
References

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