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:
Transactions not supported by database at module..... bla..bla
I realize this maybe a DBI question, but I thought I'd check here first incase
we missed something is the settings for the MySQL server
Version: 4.0.17-standard - Official MySQL-standard binary
and it has innodb enabled, the autocommit is set to 1, then when the transaction
is executed, the autocommit is set to 0 untill the commit is called....
Is there something in the variables I can check to make sure transaction have
been enabled ??
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
Quality Web Hosting