<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Upgraded MySQl to 4.1.21 - now getting "transactions not supported"</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Verdana color=#0000ff size=2><SPAN
class=404020014-15082006>ooops, nevermind. it doesn't work after the
downgrade. I can "OPEN" a ticket. but cannot "TAKE" "COMMENT"
"REPLY" "RESOLVE"</SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>On Behalf Of </B>Peake,
Jeremy<BR><B>Sent:</B> Tuesday, August 15, 2006 8:56 AM<BR><B>To:</B>
rt-users@lists.bestpractical.com<BR><B>Subject:</B> RE: [rt-users] Upgraded
MySQl to 4.1.21 - now getting "transactionsnotsupported"<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=342465513-15082006><FONT face=Verdana
color=#0000ff size=2>I downgraded to MySQL 4.1.20 and it works
fine. </FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>On Behalf Of </B>Peake,
Jeremy<BR><B>Sent:</B> Tuesday, August 15, 2006 8:30 AM<BR><B>To:</B>
rt-users@lists.bestpractical.com<BR><B>Subject:</B> [rt-users] Upgraded MySQl to
4.1.21 - now getting "transactions notsupported"<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Verdana size=1>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 face=Verdana size=1>error:</FONT></B><FONT face=Verdana
size=1> </FONT> <FONT face=Arial></FONT> <FONT face=Verdana
size=1>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
face=Verdana size=1>context:</FONT></B><FONT face=Verdana
size=1> </FONT> <FONT
face=Arial></FONT><B></B><B> <FONT face=Verdana size=1>...</FONT></B><FONT
face=Verdana size=1> </FONT> <FONT face=Arial>
</FONT><BR><B><FONT face=Verdana
size=1>1653:</FONT></B><FONT face=Verdana size=1> </FONT> <FONT
face=Arial></FONT> <FONT face=Verdana size=1>sub begin_work
{</FONT> <FONT face=Arial>
</FONT><BR><B><FONT face=Verdana size=1>1654:</FONT></B><FONT face=Verdana
size=1> </FONT> <FONT face=Arial></FONT> <FONT face=Verdana
size=1>my $dbh = shift;</FONT> <FONT
face=Arial> </FONT><BR><B><FONT face=Verdana size=1>1655:</FONT></B><FONT
face=Verdana size=1> </FONT> <FONT face=Arial></FONT> <FONT
face=Verdana size=1>return $dbh->set_err(1, "Already in a
transaction")</FONT> <FONT face=Arial>
</FONT><BR><B><FONT face=Verdana size=1>1656:</FONT></B><FONT face=Verdana
size=1> </FONT> <FONT face=Arial></FONT> <FONT face=Verdana
size=1>unless
$dbh->FETCH('AutoCommit');</FONT> <FONT
face=Arial> </FONT><BR><B><FONT face=Verdana size=1>1657:</FONT></B><FONT
face=Verdana size=1> </FONT> <FONT face=Arial></FONT> <FONT
face=Verdana color=#ff0000 size=1>$dbh->STORE('AutoCommit', 0); # will croak
if driver doesn't support
it</FONT> <FONT face=Arial>
</FONT><BR><B><FONT face=Verdana size=1>1658:</FONT></B><FONT face=Verdana
size=1> </FONT> <FONT face=Arial></FONT> <FONT face=Verdana
size=1>$dbh->STORE('BegunWork', 1); # trigger post commit/rollback
action</FONT> <FONT face=Arial> </FONT><BR><B><FONT
face=Verdana size=1>1659:</FONT></B><FONT face=Verdana
size=1> </FONT> <FONT face=Arial></FONT> <FONT face=Verdana
size=1>return 1;</FONT> <FONT face=Arial>
</FONT><BR><B><FONT face=Verdana size=1>1660:</FONT></B><FONT face=Verdana
size=1> </FONT> <FONT face=Arial></FONT> <FONT face=Verdana
size=1>}</FONT> <FONT face=Arial>
</FONT><BR><B><FONT face=Verdana size=1>1661:</FONT></B><FONT face=Verdana
size=1> </FONT> <FONT face=Arial>
</FONT><BR><B><FONT face=Verdana
size=1>...</FONT></B><FONT face=Verdana
size=1> </FONT> <FONT face=Arial>
</FONT><BR><B><FONT face=Verdana
size=1>code stack:</FONT></B><FONT face=Verdana
size=1> </FONT> <FONT face=Arial></FONT> <FONT
face=Verdana
size=1>/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>