[SOLVED] Error in SVN revision downloaded today

[jesusangel]

Database error in Product when selecting warehouse or provider

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY pac.id_product_attribute' at line 7

 

SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pac.id_product_attribute IN ()
GROUP BY pac.id_product_attribute

 

In the line 7, in the where clause the select inside () is empty.

Edited September 14, 2012 by jesusangel (see edit history)

[Vincent Augagneur]

Hi,

 

Thanks for your report, this bug will be fixed in a minute on the svn.

I will give you the fix as soon as possible

 

Vincent

[Vincent Augagneur]

Hi,

 

To fix this problem juste add this code at the line 1644 in /classes/Product.php.

 

 

 

if (!$combinations)
return false;

[jesusangel]

Fixed,

 

 

Thank you