← Back to team overview

openerp-india team mailing list archive

[Bug 1242144] [NEW] Advanced Filter when product.description is not set. error "No operator matches the given name and argument type"

 

Public bug reported:

1) Steps to reproduce the issue you have observed
  Install  a new translation (es_MX)
  Change user translate configuration (to es_MX)
  Open tree view products 
  Open advanced filter and set next filter:
     Description not set
     See image: https://docs.google.com/file/d/0BwPeHBuUYqNsUDJpamhLWVFuTTQ/edit?usp=drivesdk
2) The result you observed
   Next error
File "/home/odoo/runbot/static/openerp-dev-7-0-23036/server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: text = boolean
LINE 1: ...ng = 'es_MX'     AND type = 'model'     AND value = false) U...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

3) The result you expected
   Show products with filter
4) The platform you are using (and browser version, if relevant)
   runbot 7.0
5) The OpenERP version you are using (e.g. 6.1.1-20120910-233309), if possible including the specific revision (e.g. r.2824) if you use the source repositories.
   OpenERP 7.0 runbot 
   Build 23036

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

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

Title:
  Advanced Filter when product.description is not set. error "No
  operator matches the given name and argument type"

Status in OpenERP Addons (modules):
  New

Bug description:
  1) Steps to reproduce the issue you have observed
    Install  a new translation (es_MX)
    Change user translate configuration (to es_MX)
    Open tree view products 
    Open advanced filter and set next filter:
       Description not set
       See image: https://docs.google.com/file/d/0BwPeHBuUYqNsUDJpamhLWVFuTTQ/edit?usp=drivesdk
  2) The result you observed
     Next error
  File "/home/odoo/runbot/static/openerp-dev-7-0-23036/server/openerp/sql_db.py", line 226, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: operator does not exist: text = boolean
  LINE 1: ...ng = 'es_MX'     AND type = 'model'     AND value = false) U...
                                                               ^
  HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

  3) The result you expected
     Show products with filter
  4) The platform you are using (and browser version, if relevant)
     runbot 7.0
  5) The OpenERP version you are using (e.g. 6.1.1-20120910-233309), if possible including the specific revision (e.g. r.2824) if you use the source repositories.
     OpenERP 7.0 runbot 
     Build 23036

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


Follow ups

References