[Solved] best-sales page empty after upgrade to 1.5.6.1

[E-raser]

Hi,

 

Since I upgraded tot 1.5.6.1 my best-sales page is empty (saying no products), the block best-sales is still working.

Does anybody has the same problem? or even better a solution?

 

br,

E-raser

Edited November 24, 2013 by E-raser (see edit history)

[Taey]

Hello E-raser,

 

Edit function getBestSales in classes/ProductSale.php

 

//Subquery: get product ids in a separate query to (greatly!) improve performances and RAM usage

$sql = 'SELECT cp.`id_product`

FROM `'._DB_PREFIX_.'category_group` cg

LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)

WHERE cg.`id_group` '.$sql_groups;

 

Add

 

//Subquery: get product ids in a separate query to (greatly!) improve performances and RAM usage

$sql = 'SELECT cp.`id_product`

FROM `'._DB_PREFIX_.'category_group` cg

LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)

WHERE cg.`id_group` '.$sql_groups.' AND cp.`id_product` IS NOT NULL';

 

[E-raser]

thx, this solved my problem

 

br,

E-raser

[erotikat]

Thanks, it's work fine

[Fuz]

Great, works fine... Thanks Taey...

[Tahar R]

Thanks Dude! 2 months I was looking for the solution

[Tia©]

It works for me too! Mods made in override!

Thank you very much!!!!

 

 

Prestashop Version 1.5.6.1