[starwest]

Originally Posted by cycloneuk

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

I have the exact same problem. If you notice, your query contains only 2-letter phrases. The error on my site also occurs for only 2-letter search phrases. I've emailed Bill multiple times with no response, but I assume that he's cleared it up for the next version because in his above post he mentions that the new version will contain:

"Improved support for 1-3 letter words."

I'd hope that for those of us who don't wish to upgrade he releases a fix, but we'll see. You may want to contact him through his website and see if you have better luck then I did.