[SOLVED] [PrestaShopDatabaseException] best-sales

[romienas]

Hi,

have problems with best-sales

I don't understand whats wrong

Edited January 20, 2014 by romienas (see edit history)

[Alex Simonchik BelVG]

Hi,

 

check you sql-query, your "IN" parametr has wrong content becose starting from "," (AND p.`id_product` IN (,8,9,10...)

 

Regards

[romienas]

Hi,

 

check you sql-query, your "IN" parametr has wrong content becose starting from "," (AND p.`id_product` IN (,8,9,10...)

 

Regards

 

Hi Alexander,

thank you for your replay. I'm not good at coding, so  please, can you tell me what exactly I should to do?

[NemoPS]

THat IN statement is broken, look:

 

IN (,8,9,1

 

It can't start with a comma, are you using any third party module for this page?

[romienas]

THat IN statement is broken, look:

 

IN (,8,9,1

 

It can't start with a comma, are you using any third party module for this page?

hi Nemo1,

no, I do not use third party module for this page. How I should fix this issue, in which file is that?

[NemoPS]

What about advanced stock management?

[romienas]

What about advanced stock management?

I didn't install this module, just allowed.

[NemoPS]

Can you try disabling that, and see if it helps?

[romienas]

Can you try disabling that, and see if it helps?

disabled, but nothing

[NemoPS]

At this point, try and edit ProductSale::getBestSales

 

FInd this:

AND p.`id_product` IN ('.$ids.')

ANd change it to

AND p.`id_product` IN ('.ltrim($ids,',').')

[romienas]

Thank you Nemo1 it helped

but for other who have same problem, for clarity file is classes/ProductSale.php there is two plases with code:

AND p.`id_product` IN ('.$ids.')

and in first plase replace that code with:

AND p.`id_product` IN ('.ltrim($ids,',').')

[nag]

Thank you Nemo1.

 

For French people: le bug concerne la page « Meilleures ventes ».