Re: Problems connecting

The error "disconnect invalidates 1 active statement handle" implies
you have an active statement for which all results have not been fetched
when you call disconnect. e.g.

prepare(some sql)
execute
fetch one row when there are 20 rows
disconnect (or script terminates)

As the error states, if you don't fetch all the results from a select
then call finish first or fetch all the results.

I cannot tell from your description how "this works on one server"
and not another.

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com

On Thu, 2006-07-20 at 16:33 -0400, Albert E. Whale wrote:
> I am having a problem diagnosing the reason I am getting an error on one 
> of my MySQL Servers.  The script I am running works on one server, and 
> not another.  The Script connects to the MySQL Database and collects 
> information.  Here is one of the Errors I am receiving.
> 
> DBI::db=HASH(0x846067c)->disconnect invalidates 1 active statement 
> handle (either destroy statement handles or call finish on them before 
> disconnecting) at /var/www/html/.ServAdmin/ServerAdministrator.pm line 70.
> 
> Line 70 is:
> 
>     $dbh->disconnect();
> 
> I have un-installed and re-installed the DBD::mysql module, but I do not 
> know why this is still failing.  Any suggestions?
> 
> Here is a list of RPMs involved.
> 
>  rpm -qa | grep -i mysql
> php-mysql-4.3.10-7mdk
> MySQL-client-4.1.12-2.1.101mdk
> libmysql14-4.1.12-2.1.101mdk
> libmysql14-devel-4.1.12-2.1.101mdk
> libmysql15-5.0.2-0.3mdk
> libmysql12-4.0.20-3.5.101mdk
> perl-DBD-mysql-3.0002-1mdk
> MySQL-common-4.1.12-2.1.101mdk
> MySQL-4.1.12-2.1.101mdk
> 
> I have no idea where to look for this issue.
> 
> I am also aware that the following Perl Directories are on the server:
> 
>  cd /usr/lib/perl5
> ls
> 5.8.5/  5.8.6/  site_perl/  vendor_perl/
> 
> Any suggestion where I should look for this error?
> 
> -- 
> Albert E. Whale, CHS CISA CISSP
> Sr. Security, Network, Risk Assessment and Systems Consultant
> -------------------------------------------------------------------
> ABS Computer Technology, Inc. - www.ABS-CompTech.com
> SPAM Zapper - No-JunkMail.com - Spam-Zapper.com - SPAM Stops Here.
> 
> 



-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]