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

Posts

Joined
Tue Nov 27, 2012 12:01 am

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

wxmysqli.php
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...
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
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

Image


User avatar
Guru Member

Posts

Joined
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]ost.agency
Skype - manish.osuniverse | Gtalk - manishmt

Extensions for Opencart @ https://www.ost.agency/product/product- ... extensions
ost.agency - ecommerce website design, development and digital company


User avatar
Active Member

Posts

Joined
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.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Who is online

Users browsing this forum: paulfeakins and 32 guests