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

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

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 :)
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. :(


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

I would also recommend upgrading to the latest XenForo version.


XenForo moderator
Staff member
Not really.

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