I keep getting the below error every now and then when people perform searches, any ideas?
[24-Nov-2008 17:39:28] (shop: 24-Nov-2008 17:39:2
SQL error:
Site :
www.fragrancezone.co.uk
Remote IP : 92.3.152.216
Logged as :
SQL query : SELECT DISTINCT *, COUNT(*) AS score FROM xcart_products WHER) GROUP BY xcart_products.productid ORDER BY score DESC
Error code : 1064
Description : 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 xcart_products.productid ORDER BY score DESC' at line 1
Request URI: /_search.php?page=1&q=ck+in+2u
Backtrace:
/var/www/vhosts/fragrancezone.co.uk/httpdocs/include/func/func.db.php:180
/var/www/vhosts/fragrancezone.co.uk/httpdocs/include/func/func.db.php:106
/var/www/vhosts/fragrancezone.co.uk/httpdocs/include/func/func.db.php:322
/var/www/vhosts/fragrancezone.co.uk/httpdocs/modules/Smart_Search/smart_search_query.php:0
/var/www/vhosts/fragrancezone.co.uk/httpdocs/_search.php:165