[resolved] Bug in Agile Multiple Sellers - filtering issue
Posted: Tue Apr 23, 2013 10:46 amHi,
I have a bug (PrestaShopDatabaseException) with Agile Multiple Sellers.
What I do to get the bug :
1 - Go on Catalog > Bulk Approval.
2 - I search a product by name.
3 - The search does not work (not considered).
4 - Go on Catalog > products (list products).
5 - Error SQL :
6 - I clear cache and the error disappears.
I have a bug (PrestaShopDatabaseException) with Agile Multiple Sellers.
What I do to get the bug :
1 - Go on Catalog > Bulk Approval.
2 - I search a product by name.
3 - The search does not work (not considered).
4 - Go on Catalog > products (list products).
5 - Error SQL :
Unknown column 'pl.name' in 'where clause' SELECT SQL_CALC_FOUND_ROWS a.`id_product`,b.name as name,`reference`,a.price as price,a.active as active,ao.approved as approved , cl.name `name_category` , i.`id_image`, a.`price`, 0 AS price_final, sav.`quantity` as sav_quantity, a.`active`,ams.company AS seller,IFNULL(ao.approved,0) AS approved FROM `ps_product` a LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 5) LEFT JOIN `ps_image` i ON (i.`id_product` = a.`id_product` AND i.cover=1)LEFT JOIN `ps_category_lang` cl ON (a.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = 1) LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0 AND sav.id_shop = 1 ) LEFT JOIN `ps_product_owner` ao ON (a.`id_product`=ao.`id_product`) LEFT JOIN `ps_sellerinfo` ams ON (ao.`id_owner` = ams.`id_seller`) WHERE 1 AND b.`name` LIKE '%Product Test%' AND pl.`name` LIKE '%Product Test%' ORDER BY a.id_product DESC LIMIT 0,50
at line 605 in file classes/db/Db.php
6 - I clear cache and the error disappears.