• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.3 Error "lock wait timeout exceeded: while trying to disable template modifications

#1
I encountered this very error while trying to uncheck my template modifications (the one inside http://mysite/community/admin.php?template-modifications/)

Code:
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library\Zend\Db\Statement\Mysqli.php:215
No change is able to be saved for the template modification's checkbox after this error

I'm running XF1.3.3 in localhost. What should I do here ? thx :)
 
#2
Update for this: sometimes it'll save the change I made, and sometimes not: as if the server error above occurs fortuitously.

What might be causing this ?
#sigh, this really gonna be a long waiting for changing this. :(
 

Brogan

XenForo moderator
Staff member
#3
You may need to tune various MySQL and PHP settings on your localhost.

I would also recommend upgrading to the latest XenForo version.
 

Brogan

XenForo moderator
Staff member
#5
Not really.

It's unlikely your computer is optimised to run a server stack so you may have to tune it accordingly.