I am trying to fix a an error in a set of scripts I purchased, but cannot seem to get
support for.
I am getting the following error in my server log, which coincides with a
"configuration" error seen by the user in their browser. What is odd, is that even
though we are being told in the log and in the browser that there is an error, the
signup process that was initiated DOES complete.
Here is the error from the server log:
[Sun Oct 27 10:37:35 2002] signup.cgi: DBI::db=HASH(0x81ca284)->disconnect invalidates
1 active statement handle (either destroy statement handles or call finish on them
before disconnecting) at
/home/admin/vhosts/safelistsmart/cgi-bin/safeemailmarketing/data/iSubs.pm line 87.
The file iSubs.pm is a collection of subroutines called by other scripts. I suspect
that the handles in question are from the calling script signup.cgi. I am getting the
same errors when the MySQL disconnect is called from other scripts as well. Should I
be looking at the way the disconnect is written, or should I be looking for ways to
destroy or call finish on statement handles in the calling scripts? Here is the
related section of code form iSubs.pm. As you can see, this is where MySQL sessions
are started and stopped for every script in the package.
sub OpenMySQL {
use DBI;
$dbh =
DBI->connect("DBI:mysql:$mysql_dbname:$mysql_host","$mysql_username","$mysql_password");
return; }
sub CloseMySQL {
$dbh->disconnect();
return; }
Thanks for any help you can give. Mike
