[rt-users] rt-3.6.1 glitch

[Odhiambo Washington]

I have rt-3.6.1 installed on a host different than the DB server. Today 
I moved my database from one server to the other (dump then import).
MySQL-4.0.26 was in the old box, while the new box is MySQL-4.0.27.
Both support InnoDB.

Now when I try to "Take" a ticket, the following error pops up:


error:   	Transactions not supported by database at /usr/local/lib/perl5/site_perl/5.8.8/mach/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/local/lib/perl5/site_perl/5.8.8/mach/DBI.pm:1657
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:682
/opt/rt3/lib/RT/Ticket_Overlay.pm:3044
/opt/rt3/lib/RT/Ticket_Overlay.pm:3111
/opt/rt3/share/html/Ticket/Display.html:128
/opt/rt3/share/html/autohandler:279


Not sure what changed, really, and neither can I figure out the fix..



        cheers
       - wash 
+----------------------------------+-----------------------------------------+
Odhiambo Washington            		. WANANCHI ONLINE LTD (Nairobi, KE)  |
wash () WANANCHI ! com			. 1ere Etage, Loita Hse, Loita St.,  |
GSM: (+254) 722 743 223			. # 10286, 00100 NAIROBI             |
GSM: (+254) 733 744 121			. (+254) 020 313 985 - 9             |
+---------------------------------+------------------------------------------+
"Oh My God! They killed init! You Bastards!"  
						 --from a /. post