perl cgi problems on a redhat 8 box

ken

unread,

Oct 21, 2002, 1:00:23 PM10/21/02

to

Hi there,

I have an old redhat server that I took over with a bunch of sites that
use perl and MySQL. The box blew up a few days ago and I had to
reinstall. I put everything back from backup and now some of the sites
don't work. I see this in the error logs.

[Tue Oct 22 00:54:20 2002] [error] [client 67.38.255.125] DBD::mysql::st
fetchrow_hashref failed: fetch() without execute() at
/home/kerendiamonds/www/diamonds/diamonds.cgi line 202., referer:
http://kerendiamonds.com/diamonds/diamonds.cgi?searchfield=SHAPE&searchfor=Marquise

Now other sites work however some of them do not. I am wondering if
there is anyone who might know what the problem is. I don't think it is
a problem with the code as it used to work... I am thinking there is a
change to the some module? I don't know.

I am hoping someone could give a lead.

The box is a redhat 8 box with these perl modules installed.

perl-BSD-Resource-1.15-4
perl-Crypt-SSLeay-0.45-2
perl-DBD-Pg-1.13-5
perl-Digest-HMAC-1.01-8
perl-Filter-Simple-0.78-8
perl-Inline-0.43-7
perl-Net-DNS-0.26-2
perl-PDL-2.3.2-10
perl-TermReadKey-2.20-2
perl-URI-1.21-3
perl-XML-Parser-2.31-12
perl-5.8.0-55
perl-Bit-Vector-6.1-28
perl-CGI-2.81-55
perl-CPAN-1.61-55
perl-Date-Calc-5.0-25
perl-DBD-MySQL-2.1017-3
perl-DB_File-1.804-55
perl-Devel-Symdump-2.03-9
perl-Digest-SHA1-2.01-6
perl-Filter-1.28-9
perl-Frontier-RPC-0.06-33
perl-HTML-Tagset-3.03-25
perl-libwww-perl-5.65-2
perl-libxml-perl-0.07-25
perl-NKF-1.71-7
perl-Parse-Yapp-1.05-26
perl-RPM2-0.45-1
perl-suidperl-5.8.0-55
perl-Text-Kakasi-1.05-2
perl-Time-HiRes-1.20-23
perl-XML-Dumper-0.4-22
perl-XML-Grove-0.46alpha-21
perl-XML-Twig-3.05-3
perl-Archive-Tar-0.22-26
perl-Compress-Zlib-1.16-8
perl-DateManip-5.40-27
perl-DBI-1.30-1
perl-File-MMagic-1.15-2
perl-HTML-Parser-3.26-14
perl-libxml-enno-1.02-25
perl-Parse-RecDescent-1.80-8
perl-SGMLSpm-1.03ii-6
perl-TimeDate-1.1301-2
perl-XML-Encoding-1.01-20

Thank you
Ken

Matt Garrish

unread,

Oct 22, 2002, 12:16:58 AM10/22/02

to

"ken" <ke...@pcintelligent.com> wrote in message
news:3DB40826...@pcintelligent.com...

> Hi there,
>
> I have an old redhat server that I took over with a bunch of sites that
> use perl and MySQL. The box blew up a few days ago and I had to
> reinstall. I put everything back from backup and now some of the sites
> don't work. I see this in the error logs.
>
> [Tue Oct 22 00:54:20 2002] [error] [client 67.38.255.125] DBD::mysql::st
> fetchrow_hashref failed: fetch() without execute() at
> /home/kerendiamonds/www/diamonds/diamonds.cgi line 202., referer:
>
http://kerendiamonds.com/diamonds/diamonds.cgi?searchfield=SHAPE&searchfor=M
arquise
>

Looks like a domino effect from a failed/improper prepare statement. If you
don't prepare a valid SQL statement to execute, it won't. And if it doesn't
execute, you're not going to get any values back from the database.

For more information on what is going wrong you should see the DBI module
documentation (specifically about using RaiseError and PrintError to catch
errors in your SQL statements).

Matt

ken

unread,

Oct 22, 2002, 12:51:07 AM10/22/02

to

Hi there,

I thank you for taking the time to respond. I have located the problem.
It was a databse that was moved over and I had some screwed up perms in
the .frm file... All is well at the moment.

Thank you
Ken