today for the first time I get this error
Lock wait timeout exceeded; try restarting transaction
when using sentence
UPDATE info_psl SET eil_nr = eil_nr + 1 WHERE eil_nr >= 4
The table is such
CREATE TABLE IF NOT EXISTS `info_psl` ( `psl_id` int(11) NOT NULL auto_increment, `pavadinimas` varchar(20) default NULL, `tekstas` text, `eil_nr` int(11) NOT NULL, PRIMARY KEY (`psl_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
Never had problems using this, just made some correntions in my php file, but they should not affetct that.
I tried running this query in phpMyAdmin and of course get the same error. What should I do?
Edit: after writing this post I tested again and it works without errors :D what the hell was that? :D it would be interesting to know.