[rt-users] RT Transactions Failing with mod_php5 installed

[Matt Juszczak]

Hi all,

I've been setting up RT all day, and I've got it mostly functioning 
properly.  I installed all perl modules, installed mod_perl, configured rt 
to work, and it does.... except...

When I try to create a new queue, I get the following error:


"error:   	Transactions not supported by database at 
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBI.pm line 1665."


Research on this indicated that I needed to reinstall DBD::mysql.  This 
did not help.  What DID help; however, was disabling mod_php5.  If i 
comment the loadmodule for mod_php5 out of the httpd.conf file (and hence, 
causes php scripts to stop functioning), then RT functions fine and I can 
create queues.

Does anyone know why this may be the case?  I'd consider the option of 
conflicting mysql client libraries...

More information from the error is below:



context:
...
1661:  	sub begin_work {
1662:  	my $dbh = shift;
1663:  	return $dbh->set_err(1, "Already in a transaction")
1664:  	unless $dbh->FETCH('AutoCommit');
1665:  	$dbh->STORE('AutoCommit', 0); # will croak if driver doesn't 
support it
1666:  	$dbh->STORE('BegunWork', 1); # trigger post commit/rollback action
1667:  	return 1;
1668:  	}
1669:
...
code stack: 
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBI.pm:1665
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm:720
/opt/rt3/lib/RT/Queue_Overlay.pm:371
/opt/rt3/share/html/Admin/Queues/Modify.html:130
/opt/rt3/share/html/Admin/autohandler:49
/opt/rt3/share/html/autohandler:291