[rt-users] Upgraded MySQl to 4.1.21 - now getting "transactions not supported"

[Peake, Jeremy]

After the MySQL upgrade, it appears the Rt database was set to myisam.  I changed it back to innodb, restarted Mysql and the web server.  Still getting this error when I try to comment, reply or resolve any ticket.  Any ideas?



error: 	 Transactions not supported by database at /usr/lib/perl5/vendor_perl/5.8.7/i686-linux/DBI.pm line 1657.
	
context: 	 ... 	 	
1653: 	 sub begin_work {	 
1654: 	 my $dbh = shift;	 
1655: 	 return $dbh->set_err(1, "Already in a transaction")	 
1656: 	 unless $dbh->FETCH('AutoCommit');	 
1657: 	 $dbh->STORE('AutoCommit', 0); # will croak if driver doesn't support it	 
1658: 	 $dbh->STORE('BegunWork', 1); # trigger post commit/rollback action	 
1659: 	 return 1;	 
1660: 	 }	 
1661: 	 	
... 	 	
code stack: 	 /usr/lib/perl5/vendor_perl/5.8.7/i686-linux/DBI.pm:1657
/usr/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm:682
/opt/rt3/lib/RT/Ticket_Overlay.pm:2302
/opt/rt3/share/html/Ticket/Elements/PreviewScrips:82
/opt/rt3/share/html/Ticket/Update.html:137
/opt/rt3/share/html/autohandler:279	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060815/caded2fb/attachment.htm>