← Back to team overview

openerp-india team mailing list archive

[Bug 1101277] [NEW] --unaccent option does not work on v7.0

 

Public bug reported:

I have OpenERP v7.0 in Ubuntu 12.04 with PostgreSQL. I updated the
server with nightly builds,

I create a new OpenERP database called X.

I installed postgresql-contrib for using unaccent in PostgreSQL and
connect to the database X with psql. I execute "create extension
unaccent;" to have access to unaccent in the database X.

I start the OpenERP server with the '--unaccent' option.

After all this, if I search over product name, I do not receive the
expected result. For example, if I have products 'aeío' and 'aeio' and I
search with string 'aeí' I receive only the first product and not the
second.

I check the log (using option --log-sql in the server) and I don't see
any usage of unaccent function in the querys.

The same problem is present in v6.1 (https://bugs.launchpad.net
/openobject-server/+bug/1049653) and a solution have been proposed to
deal with this.

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

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

Title:
  --unaccent option does not work on v7.0

Status in OpenERP Server:
  New

Bug description:
  I have OpenERP v7.0 in Ubuntu 12.04 with PostgreSQL. I updated the
  server with nightly builds,

  I create a new OpenERP database called X.

  I installed postgresql-contrib for using unaccent in PostgreSQL and
  connect to the database X with psql. I execute "create extension
  unaccent;" to have access to unaccent in the database X.

  I start the OpenERP server with the '--unaccent' option.

  After all this, if I search over product name, I do not receive the
  expected result. For example, if I have products 'aeío' and 'aeio' and
  I search with string 'aeí' I receive only the first product and not
  the second.

  I check the log (using option --log-sql in the server) and I don't see
  any usage of unaccent function in the querys.

  The same problem is present in v6.1 (https://bugs.launchpad.net
  /openobject-server/+bug/1049653) and a solution have been proposed to
  deal with this.

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


Follow ups

References