A Database Error Occurred

Error Number: 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 ') = GROUP BY `searchIndexObjectId` ORDER BY `score` DESC LIMIT 24' at line 8

SELECT SQL_CALC_FOUND_ROWS productId, `search_index`.*, (SUM(searchIndexWeight)*(1/STD(searchIndexPosition))) as score, (1/STD(searchIndexPosition)) as stddev, GROUP_CONCAT(DISTINCT searchIndexTerm SEPARATOR ", ") as indexTerms, GROUP_CONCAT(DISTINCT CONCAT(boutique_product_images.productImageThumbFile, ":", boutique_product_images.productImageOrder) SEPARATOR ", ") as productImages, `boutique_products`.* FROM `search_index` LEFT JOIN `boutique_products` ON `boutique_products`.`productId` = `search_index`.`searchIndexObjectId` LEFT JOIN `boutique_product_images` ON `boutique_product_images`.`productImageProductId` = `boutique_products`.`productId` AND `productImageStatus` = "active" AND `productImageOrder` < 10 WHERE `searchIndexScope` = 'product' AND `boutique_products`.`productStatus` = 'active' AND `boutique_products`.`productIsVisible` = 1 AND () = GROUP BY `searchIndexObjectId` ORDER BY `score` DESC LIMIT 24

Filename: libraries/Boutique.php

Line Number: 5951