This only happens 1 or 2 times a week. Only thing that has changed was my template.
Each time the error may vary.
Not sure if someone or something it trying to hack my sql or some other problem. I see the word in this wood grain and wondering of someone was searching the site for wood grain and got an error. I went to our site and searched for this but no errors on page or admin log.
I have cleared cache and temp files and did database maintenance.
I am not using any quick search addons as they don’t work good with this template. Just the regular search feature.
website is
http://CutRiteFX.com
Error: Duplicate entry ‘2177-261fd43d60e2b7311b231e7cc12a6860’ for key 1 (1062)
Query: INSERT INTO cscart_stat_product_search (sess_id, search_string, md5, quantity) VALUES (‘2177’, ‘a:9:{s:5:"match";s:3:"any";s:5:"pfull";s:1:"Y";s:9:"pkeywords";s:1:"Y";s:5:"pname";s:1:"Y";s:6:"pshort";s:1:"Y";s:1:"q";s:10:"wood grain";s:16:"search_performed";s:1:"Y";s:6:"status";s:1:"A";s:7:"subcats";s:1:"Y";}’, ‘261fd43d60e2b7311b231e7cc12a6860’, ‘0’)
Backtrace››
/home/content/07/4755107/html/core/fn.database.php (db_error): 259
/home/content/07/4755107/html/addons/statistics/controllers/customer/products.post.php (db_query): 59
/home/content/07/4755107/html/core/fn.control.php (include): 580
/home/content/07/4755107/html/core/fn.control.php (fn_run_controller): 434
/home/content/07/4755107/html/index.php (fn_dispatch): 31
I too have seen these specific database errors in the admin log.
I use v2.14 and hoped that moving up to 2.2 would fix these errors. I see that it has to do with cscart_stat_product_search table. I usually check the table and optimizing it in phpMyAdmin, to make sure MySQL doesn't report any errors.
As last resort, I clear my temporary cache files from site root /var/cache, but these files help the site run fast so I do it sparingly. This gives relief to the errors, but after time I get the errors again. The worst side effect of these errors is that they overload MySQL (long queries).
Also, I have made sure that php, apache and MySQL are up to date on the server (if you use a dedicated server or choose a better host). This has gone a long way towards fixing long queries with cs-cart.
My guess is the error is a result of the /var/cache getting corrupted.
Just my 2 cents.