[PHP-DB] Lock wait timeout error

2003-01-23 Thread A.J. Kruit
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

[PHP-DB] Re: Question about rollback in mysql

2002-12-31 Thread A.J. Kruit
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