[trunk/7.0]Advanced Filter when product.description is not set. error "No operator matches the given name and argument type"

Bug #1242144 reported by Moisés López - http://www.vauxoo.com
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Status tracked in Trunk
7.0
Fix Released
Undecided
OpenERP Publisher's Warranty Team
Trunk
Confirmed
Medium
OpenERP R&D Addons Team 2

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

Tags: maintenance

Related branches

Revision history for this message
Twinkle Christian(OpenERP) (tch-openerp) wrote :

Hello,

It also happens with English language. So, I am confirming this issue.

Thanks,

Changed in openobject-addons:
assignee: nobody → OpenERP R&D Addons Team 2 (openerp-dev-addons2)
importance: Undecided → Medium
status: New → Confirmed
summary: - Advanced Filter when product.description is not set. error "No operator
- matches the given name and argument type"
+ [trunk/7.0]Advanced Filter when product.description is not set. error
+ "No operator matches the given name and argument type"
tags: added: maintenance
Revision history for this message
Amit Dodiya (OpenERP) (ado-openerp) wrote :

Hello,

This issue is fixed with following branches:
Fix contains changes on web-client and server both.
On Server:
branch: lp:~openerp-dev/openobject-server/7.0-opw-599579-ado
revision-id: <email address hidden>

On Web:
branch: lp:~openerp-dev/openerp-web/7.0-opw-599579-ado
revision-id: <email address hidden>

Soon our experts will review and merge it with stable branches.

Regards,
Amit

Revision history for this message
Amit Dodiya (OpenERP) (ado-openerp) wrote :

Hello,

The fix is merged in 7.0 with following:
revno: 5214 [merge]
revision-id: <email address hidden>

Regards,
Amit

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.