[rt-users] Mysql: transactions not supported...

[FLoh Leeber]

Hi there!

For whatever reason RT3 started to complain in the following way when 
doing updates on Tickets:

*System error*

*error:*  	Transactions not supported by database at 
/usr/lib/perl5/DBI.pm line 1625.
*context:*  	
*...*  	
*1621:*  	sub begin_work {
*1622:*  	my $dbh = shift;
*1623:*  	return $dbh->set_err(1, "Already in a transaction")
*1624:*  	unless $dbh->FETCH('AutoCommit');
*1625:*  	$dbh->STORE('AutoCommit', 0); # will croak if driver doesn't 
support it
*1626:*  	$dbh->STORE('BegunWork', 1); # trigger post commit/rollback 
action
*1627:*  	return 1;
*1628:*  	}
*1629:*  	
*...*  	

*code stack:*  	/usr/lib/perl5/DBI.pm:1625
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:669
/usr/share/request-tracker3/lib/RT/Ticket_Overlay.pm:3109
/usr/share/request-tracker3/lib/RT/Interface/Web.pm:1091
/usr/share/request-tracker3/html/Ticket/Display.html:111
/usr/share/request-tracker3/html/Ticket/Update.html:196
/usr/share/request-tracker3/html/autohandler:200

raw error <http://rt.happyserverfriends.info/rt/Ticket/Update.html#raw>

Apparently, some system updates may have caused this. When further 
investigating this I noticed that the DB tables were all MyISAM and 
InnoDB was disdabled. I corrected this, and converted all the tables to 
InnoDB, still the driver doesnt like the transactions.


Any ideas?

kind regards, F. Leeber