Problems with DBD::mysql

Previously I had submitted this problem to the group.

DBI::db=HASH(0x848dae4)->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.

While I have been swamped, I finally configured a Finish statement in
advance of the disconnect. Now I get the following:

Can't locate object method "finish" via package "DBI::db" at
/var/www/html/.ServAdmin/ServerAdministrator.pm line 70.

This same package runs well on another server.

I have verified all of the installed perl RPMs. There are multiple
versions of perl on this machine. Could the DBI or DBD::mysql be
installed in a previous version?

Is there a method to validate the installed Perl Modules?

--
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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Problems with DBD::mysql

Albert,

----- Original Message -----
From: "Albert E. Whale"
To:
Sent: Tuesday, July 25, 2006 10:09 AM
Subject: Problems with DBD::mysql


> Previously I had submitted this problem to the group.
>
> DBI::db=HASH(0x848dae4)->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.
>
> While I have been swamped, I finally configured a Finish statement in advance
> of the disconnect. Now I get the following:
>
> Can't locate object method "finish" via package "DBI::db" at
> /var/www/html/.ServAdmin/ServerAdministrator.pm line 70.
>
> This same package runs well on another server.
>
> I have verified all of the installed perl RPMs. There are multiple versions
> of perl on this machine. Could the DBI or DBD::mysql be installed in a
> previous version?
>
> Is there a method to validate the installed Perl Modules?

how are you calling your 'finish()' statement? are using a statement handle, IE:
$sth->finish() after process your 'fetch()' ?


Mike(mickalo)Blezien
===============================
Thunder Rain Internet Publishing
Providing Internet Solution that Work
http://www.thunder-rain.com
===============================


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Problems with DBD::mysql

Mike Blezien wrote:
> Albert,

> how are you calling your 'finish()' statement? are using a statement
> handle, IE: $sth->finish() after process your 'fetch()' ?
>

OK, that eliminated the issue. I changed the call from

$dbh->finish();

to

$sth->finish();

That eliminates the Error message as well.

Thanks.

--
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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org