[PHP-DB] Lock wait timeout error
Hello, I have trouble with php-4.3.0 en mysql max 4.0.9 gamma. If I use innodb and I want to use rollback and commit i got an error. If I set auto commit=0 and try to insert a record I recieve the message Lock wait timeout try to restart transactions. I look into de newsgroup and don't find the answer. Can someone tell me what is going wrong? Arno Kruit -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Question about rollback in mysql
Arno Kruit wrote: I have php 4.2.3 and Mysql- Max 3.23.54b. If I use the rollback or Commit function it wil work until the scripts ends Is it possible to rollback or commit commands after the scripts ends with a another script? or is rollback only possible in the same script? A.J. Kruit I have sold the problem I upgrade to php 4.3.0 and the problem was sold. A.J. Kruit -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php