Bug when we select a currency in marketplace search

[YannickB]

When we select a currency in marketplace search (for example COM) and we click on the search button, we have an error 500

Looking at the log, I have this sql request error

2014-11-04 13:27:03,766 9397 ERROR ocm_dev_ocm_yolo_consulting_net openerp.sql_db: Programming error: column cl.announcement_id does not exist LINE 1: ...LECT 1 FROM account_wallet_currency_line cl WHERE cl.announc... ^ , in query (SELECT a.id, a.delivery_date FROM marketplace_announcement a LEFT JOIN res_partner p on p.id = a.partner_id WHERE state='open' AND a.type = 'want' AND EXISTS(SELECT 1 FROM account_wallet_currency_line cl WHERE cl.announcement_id = a.id AND cl.currency_id = %(currency)s) GROUP BY a.id ORDER BY a.delivery_date ASC LIMIT %(limit)s ) UNION (SELECT a.id, a.delivery_date FROM marketplace_announcement a LEFT JOIN res_partner p on p.id = a.partner_id WHERE state='open' AND a.type = 'offer' AND EXISTS(SELECT 1 FROM account_wallet_currency_line cl WHERE cl.announcement_id = a.id AND cl.currency_id = %(currency)s) GROUP BY a.id ORDER BY a.delivery_date ASC LIMIT %(limit)s ) ORDER BY delivery_date ASC 2014-11-04 13:27:03,767 9397 ERROR ocm_dev_ocm_yolo_consulting_net openerp.sql_db: bad query: SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."type" = 'binary') AND ("ir_attachment"."url" = '/marketplace/search')) ORDER BY "ir_attachment"."id" desc Traceback (most recent call last): File "/opt/odoo/production/files/parts/odoo/openerp/sql_db.py", line 234, in execute res = self._obj.execute(query, params) InternalError: current transaction is aborted, commands ignored until end of transaction block

[okuryan]

Looking into this

[veryberry]

Fixed in commit https://github.com/xpansa/community-web/commit/f2dba174f54e2fdd226482a2df3e1450ad1b6f80

[YannickB]

Seems ok