Hi there!
For whatever reason RT3 started to complain in the following way when
doing updates on Tickets:
System error
error: Transactions not supported by database at
/usr/lib/perl5/DBI.pm line 1625.
context:
…
1621: sub begin_work {
1622: my $dbh = shift;
1623: return $dbh->set_err(1, “Already in a transaction”)
1624: unless $dbh->FETCH(‘AutoCommit’);
1625: $dbh->STORE(‘AutoCommit’, 0); # will croak if driver doesn’t
support it
1626: $dbh->STORE(‘BegunWork’, 1); # trigger post commit/rollback
action
1627: return 1;
1628: }
1629:
…
code stack: /usr/lib/perl5/DBI.pm:1625
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:669
/usr/share/request-tracker3/lib/RT/Ticket_Overlay.pm:3109
/usr/share/request-tracker3/lib/RT/Interface/Web.pm:1091
/usr/share/request-tracker3/html/Ticket/Display.html:111
/usr/share/request-tracker3/html/Ticket/Update.html:196
/usr/share/request-tracker3/html/autohandler:200
raw error http://rt.happyserverfriends.info/rt/Ticket/Update.html#raw
Apparently, some system updates may have caused this. When further
investigating this I noticed that the DB tables were all MyISAM and
InnoDB was disdabled. I corrected this, and converted all the tables to
InnoDB, still the driver doesnt like the transactions.
Any ideas?
kind regards, F. Leeber