----- Forwarded message from John Rowan <[EMAIL PROTECTED]> -----
Date: Wed, 22 Oct 2008 09:50:23 -0400
From: John Rowan <[EMAIL PROTECTED]>
Subject: DBI.pm
Good day Tim. I need to steal some of your time.
I run a content management system from PlainBlack Software called WebGUI.
This software uses DBI to interact with the underlying MySQL database.
Two days ago the software stopped updating the web site when users
added or deleted content using Save or Save and Commit. The errors in the
webgui.log say the root cause is:
2008/10/22 09:21:51 - WARN - PaperStrategies.conf - main::[[undef]] -
Couldn't call method editSave on
asset for url: home/contact-us/untitled Root cause: Transactions not
supported by database at
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBI.pm line 1674.
Line 1674 is bolded below
sub begin_work {
my $dbh = shift;
return $dbh->set_err($DBI::stderr, "Already in a transaction")
unless $dbh->FETCH('AutoCommit');
$dbh->STORE('AutoCommit', 0); # will croak if driver doesn't support
it
$dbh->STORE('BegunWork', 1); # trigger post commit/rollback action
return 1;
}
I restarted MySQL and it says:
081021 13:48:17 InnoDB: Started; log sequence number 0 43644
/usr/libexec/mysqld: ready for connections.
Version: '4.1.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source
distribution
Someone thougnt my implementation did not include InnoDB. This had been
working for 15 months then
stopped this week. I've posted to the PlainBlack forums but none of the
feedback has helped resolve the
problem. I thought since CPAN shows you as the author I might ask you for
your thoughts on how to test
or resolve. I did update the module to version 1.607 yesterday hoping that
might fix but it did not. I
also rebooted the server last night and ran a database check with mysqlcheck
-c -v -p --all-databases.
Thanks in advance.
----- End forwarded message -----
