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

[tonnyz]

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

 

[tonnyz]

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.

 

[Paul B]

You may need to tune various MySQL and PHP settings on your localhost.

I would also recommend upgrading to the latest XenForo version.

 

[tonnyz]

You may need to tune various MySQL and PHP settings on your localhost.

Could you be more specific for this one , please ?

 

[Paul B]

Not really.

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

 

[TPerry]

Could you be more specific for this one , please ?

yeah, you will need to tune your my.cnf and your php.ini in your localhost.

The settings will depend on your setup - that's why nobody can tell you exactly what to put.

 

[tonnyz]

Not really.

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

yeah, you will need to tune your my.cnf and your php.ini in your localhost.
.

Ow, I see..
Where should I find the conf.my ? I tried searching it inside my XAMPP folder without any result .

 

[Paul B]

xampp/php/php.ini
xampp/mysql/bin/my.ini

 

[tonnyz]

xampp/php/php.ini
xampp/mysql/bin/my.ini

ok, thx

I'm trying experimenting with this now