Versions: DBI: - 1.14 DBD::mysql: - 2.0415
Does the DBI module need to be updated ??
TIA -- Mike<mickalo>Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Rudy Lippan wrote:
On Tue, 30 Mar 2004, Mike Blezien wrote:
Hello,
I keep getting this error when attempting to utilize a database that has Innodb tables, and using transactions. This is from a Perl/DBI script too:
Error: Transactions not supported by database at module..... bla..bla
What version of DBD::mysql are you using?
MySQL Version: 4.0.17-standard - Official MySQL-standard binary
and it has innodb enabled, the autocommit is set to 1 on the inital 'connect', no errors, then when the transaction is executed, the autocommit is set to 0 until the commit is called, of if an error occurs, the rollback is called.
Is there something in the variables I can check to make sure transaction have been enabled for this particular database ??
You can use transactions with non-innodb tables, IIRC. You will just get warnings on rollback.
Rudy
