[rt-users] Upgraded MySQl to 4.1.21 - nowgetting "transactionsnotsupported"

[Peake, Jeremy]

Ahhhhh, thanks a lot!!!  That did it.


-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of David
Oberlitner
Sent: Tuesday, August 15, 2006 9:23 AM
To: 
Subject: Re: [rt-users] Upgraded MySQl to 4.1.21 - nowgetting
"transactionsnotsupported"

Jeremy,

The MySQL client library has changed.

Recompiling DBD::mysql solved the same problem for me.

David

Peake, Jeremy wrote:
> ooops, nevermind.  it doesn't work after the downgrade.  I can "OPEN" 
> a ticket.  but cannot "TAKE" "COMMENT" "REPLY" "RESOLVE"
> 
> ----------------------------------------------------------------------
> --
> *From:* rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] *On Behalf Of 
> *Peake, Jeremy
> *Sent:* Tuesday, August 15, 2006 8:56 AM
> *To:* rt-users at lists.bestpractical.com
> *Subject:* RE: [rt-users] Upgraded MySQl to 4.1.21 - now getting 
> "transactionsnotsupported"
> 
> I downgraded to MySQL 4.1.20 and it works fine. 
> 
> ----------------------------------------------------------------------
> --
> *From:* rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] *On Behalf Of 
> *Peake, Jeremy
> *Sent:* Tuesday, August 15, 2006 8:30 AM
> *To:* rt-users at lists.bestpractical.com
> *Subject:* [rt-users] Upgraded MySQl to 4.1.21 - now getting 
> "transactions notsupported"
> 
> 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    
> 
> 
> ----------------------------------------------------------------------
> --
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com Commercial support: 
> sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support:
sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com