Need help with fatal error
Posted: Sat Feb 20, 2016 12:43 am
I keep getting this error and its intermittant. Sometimes I site is super fast with no issues and other times I get this error. I have no idea how to fix it.
If someone could help me out that would be great.
If someone could help me out that would be great.
Code: Select all
Fatal error: Uncaught exception 'ErrorException' with message 'Error: Lock wait timeout exceeded; try restarting transaction<br />Error No: 1205<br />UPDATE product SET viewed = (viewed + 1) WHERE product_id = '8'' in /home/bathcom/pirch/system/database/wxmysqli.php:46 Stack trace: #0 /home/bathcom/pirch/vqmod/vqcache/vq2-system_library_db.php(26): WXMySQLi->query('UPDATE product ...') #1 /home/bathcom/pirch/vqmod/vqcache/vq2-catalog_model_catalog_product.php(4): DB->query('UPDATE product ...') #2 /home/bathcom/pirch/vqmod/vqcache/vq2-catalog_controller_product_product.php(708): ModelCatalogProduct->updateViewed('8') #3 [internal function]: ControllerProductProduct->index() #4 /home/bathcom/pirch/vqmod/vqcache/vq2-system_engine_front.php(42): call_user_func_array(Array, Array) #5 /home/bathcom/pirch/vqmod/vqcache/vq2-system_engine_front.php(29): Front->execute(Object(Action)) #6 /home/bathcom/pirch/index.php(247): Front->dispatch(Object(Action), Object(Action)) #7 {main} thrown in /home/bathcom/pirch/system/database/wxmysqli.php on line 46