Search

Array
(
[0] => 42000
[1] => 1064
[2] => 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 'ORDER BY weight ASC' at line 1
)

Database error: SQL Error:
SELECT AG.name as groupName, A.name as name, AP.value FROM attributePairMapping as APM
INNER JOIN attributePair as AP on AP.id = APM.attributePair
INNER JOIN attribute as A on A.id = AP.attribute
LEFT JOIN attributeGroup as AG on AG.id = A.attributeGroup
WHERE
APM.item =
AND
A.active = 1
AND
AP.active = 1
AND
FIND_IN_SET(A.id,(SELECT multiAttribute FROM attributeCategoryGroup WHERE category = 29 AND active=1))
ORDER BY AG.weight asc, A.weight asc
MySQL Error: 1064 (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 'AND
A.active = 1
AND
AP.active = 1
AND
FIND_IN_SET(A.id,(SELECT multiAttrib' at line 7)
Session halted.