Post by lipps199 » 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.

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

Active Member


Tue Nov 27, 2012 12:01 am

Post by IP_CAM » Sat Feb 20, 2016 1:46 am

what the heck is that?
And since you mentioned neither OC Version, nor anything else, such as Theme, Extensions, e.t.c.,
there is a very slim chance, to get some light into this...

I'm no longer active at the OC Forum. To reach me, contact:
A Demoversion of my free Opencart LIGHT v. Software
can be seen in Action here:
930+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site:

User avatar
Legendary Member


Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by JAY6390 » Sat Feb 20, 2016 2:26 am

wxmysqli is the custom file from wxhosting. You should contact Jeff about this as its a server issue


SEO MEGA KIT PLUS - Get your site ranking higher in the search engines
Better Product SEO URL's - Perfectly structured product links
SEO URL's Route Editor PRO - Make ANY url on your site have clean keywords - even third party extensions (remove index.php)

User avatar
Guru Member


Wed May 26, 2010 11:47 pm
Location - United Kingdom

Post by ostechnologies » Sat Feb 20, 2016 3:18 am

If you still need help then please let me know.

Opencart Expert | sales[at]
Skype - manish.osuniverse | Gtalk - manishmt

Extensions for Opencart @ ... extensions - ecommerce website design, development and digital company

User avatar
Active Member


Mon Apr 06, 2015 1:30 pm

Post by paulfeakins » Mon Feb 22, 2016 11:36 pm

Agree with Jay, it's a server issue.

For quick, professional OpenCart support please email

User avatar
Expert Member


Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom
Who is online

Users browsing this forum: No registered users and 12 guests