I always got the mysql error messages when customers click smart search, does any one know why, below is the detail message:
[09-Feb-2010 16:23:59] (shop: 09-Feb-2010 16:23:59) SQL error:
Site :
https://www.fineartonsale.com
Remote IP : 66.249.65.21
Logged as :
SQL query : INSERT INTO xcart_benchmark_pages (`script`, `method`, `data`) VALUES ('_search.php', 'G', 'q=whittington's')
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 's')' at line 1
Request URI: /_search.php?q=whittington's
Backtrace:
/home/fineart/public_html/include/func/func.db.php:180
/home/fineart/public_html/include/func/func.db.php:106
/home/fineart/public_html/include/func/func.db.php:395
/home/fineart/public_html/include/bench.php:231