<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7650.28">
<TITLE>Upgraded MySQl to 4.1.21 - now getting "transactions not supported"</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=1 FACE="Verdana">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?</FONT></P>
<BR>
<BR>
<P><B><FONT SIZE=1 FACE="Verdana">error:</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Verdana">Transactions not supported by database at /usr/lib/perl5/vendor_perl/5.8.7/i686-linux/DBI.pm line 1657.<BR>
</FONT>
<BR><B><FONT SIZE=1 FACE="Verdana">context:</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"></FONT><B></B><B> <FONT SIZE=1 FACE="Verdana">...</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"> </FONT>
<BR><B><FONT SIZE=1 FACE="Verdana">1653:</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Verdana">sub begin_work {</FONT> <FONT FACE="Arial"> </FONT>
<BR><B><FONT SIZE=1 FACE="Verdana">1654:</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Verdana">my $dbh = shift;</FONT> <FONT FACE="Arial"> </FONT>
<BR><B><FONT SIZE=1 FACE="Verdana">1655:</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Verdana">return $dbh->set_err(1, "Already in a transaction")</FONT> <FONT FACE="Arial"> </FONT>
<BR><B><FONT SIZE=1 FACE="Verdana">1656:</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Verdana">unless $dbh->FETCH('AutoCommit');</FONT> <FONT FACE="Arial"> </FONT>
<BR><B><FONT SIZE=1 FACE="Verdana">1657:</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"></FONT> <FONT COLOR="#FF0000" SIZE=1 FACE="Verdana">$dbh->STORE('AutoCommit', 0); # will croak if driver doesn't support it</FONT> <FONT FACE="Arial"> </FONT>
<BR><B><FONT SIZE=1 FACE="Verdana">1658:</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Verdana">$dbh->STORE('BegunWork', 1); # trigger post commit/rollback action</FONT> <FONT FACE="Arial"> </FONT>
<BR><B><FONT SIZE=1 FACE="Verdana">1659:</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Verdana">return 1;</FONT> <FONT FACE="Arial"> </FONT>
<BR><B><FONT SIZE=1 FACE="Verdana">1660:</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Verdana">}</FONT> <FONT FACE="Arial"> </FONT>
<BR><B><FONT SIZE=1 FACE="Verdana">1661:</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"> </FONT>
<BR><B><FONT SIZE=1 FACE="Verdana">...</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"> </FONT>
<BR><B><FONT SIZE=1 FACE="Verdana">code stack:</FONT></B><FONT SIZE=1 FACE="Verdana"> </FONT> <FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Verdana">/usr/lib/perl5/vendor_perl/5.8.7/i686-linux/DBI.pm:1657<BR>
/usr/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm:682<BR>
/opt/rt3/lib/RT/Ticket_Overlay.pm:2302<BR>
/opt/rt3/share/html/Ticket/Elements/PreviewScrips:82<BR>
/opt/rt3/share/html/Ticket/Update.html:137<BR>
/opt/rt3/share/html/autohandler:279</FONT>
</P>
</BODY>
</HTML>