Re: hangs on $ENV{'QUERY_STRING'}

2002-10-31 Thread Michael Forbes
Well, I've managed to make some significant progress:  I got past that
hang (apparently modperl was having problems with the URL b/c some of
the values were being passed empty... i.e.,
stage=4eqtype=Allcont=restrictflags=12... notice that cont has no
value.

At any rate, I solved that problem by forcing the form that passes the
information in to always have at least a bare minimum of data in each
field... and it seems to be working.

My next problem, which took four hours to track down, is that it turns
out that mod_perl is choking on null values being retrieved from MySQL. 
I'm using DBI for the interface, and the actual fetch_row is performing
exactly the way it should... but when it tries to do anything with my
scalar once it has a null in it, it just chokes  sits there until it
times out.  Is this a known bug?  Is there a known fix for it, other
than ensuring I never have null values in my database?

Thanks,

Mike Forbes
[EMAIL PROTECTED]


On Wed, 2002-10-30 at 17:53, Michael Forbes wrote:
 My apologies in advance if this is something that's been described 
 solved before... I can't seem to find the answer in archival searches
 (maybe I'm just using the wrong terms).
 
 At any rate, I have a fairly large script that I wrote when operating
 under Apache 1.3, perl 5.8.0, Redhat 7.3.  I'm now running Apache 2.0,
 perl 5.8.0, and Redhat 8.0... and it stopped working when I performed
 the upgrade.
 
  
 Anywhere, what's happening is that the code below this paragraph is just
 hanging...(on the second line, I've inserted a few print
 'debugBR\n'; lines in the real thing to make sure.) it does finally
 time out, without producing any output.
 
 here's the relevant code:
 
 $pass = /cgi-bin/plaintextresult.cgi?$ENV{'QUERY_STRING'};
 
 print TD WIDTH='33%' ALIGN='CENTER' BGCOLOR='#22'A
 HREF=\$pass\ target='printerfriendly'Plain text version/A/TD\n;
 
 
 
 Thanks in advance, and again, sorry if this is a FAQ, I just couldn't
 find the answer anywhere.
 
 -Mike Forbes
 [EMAIL PROTECTED]
 
 





Re: hangs on $ENV{'QUERY_STRING'}

2002-10-31 Thread Perrin Harkins
Michael Forbes wrote:


Well, I've managed to make some significant progress:  I got past that
hang (apparently modperl was having problems with the URL b/c some of
the values were being passed empty... i.e.,
stage=4eqtype=Allcont=restrictflags=12... notice that cont has no
value.



That sounds pretty bad.  Maybe you should go back to mod_perl 1.3, which 
definitely does not have problems with that.

My next problem, which took four hours to track down, is that it turns
out that mod_perl is choking on null values being retrieved from MySQL. 
I'm using DBI for the interface, and the actual fetch_row is performing
exactly the way it should... but when it tries to do anything with my
scalar once it has a null in it, it just chokes  sits there until it
times out.


Are you using the pre-fork MPM?  If not, do you know if your DBD driver 
is threadsafe?

- Perrin



hangs on $ENV{'QUERY_STRING'}

2002-10-30 Thread Michael Forbes
My apologies in advance if this is something that's been described 
solved before... I can't seem to find the answer in archival searches
(maybe I'm just using the wrong terms).

At any rate, I have a fairly large script that I wrote when operating
under Apache 1.3, perl 5.8.0, Redhat 7.3.  I'm now running Apache 2.0,
perl 5.8.0, and Redhat 8.0... and it stopped working when I performed
the upgrade.

 
Anywhere, what's happening is that the code below this paragraph is just
hanging...(on the second line, I've inserted a few print
'debugBR\n'; lines in the real thing to make sure.) it does finally
time out, without producing any output.

here's the relevant code:

$pass = /cgi-bin/plaintextresult.cgi?$ENV{'QUERY_STRING'};

print TD WIDTH='33%' ALIGN='CENTER' BGCOLOR='#22'A
HREF=\$pass\ target='printerfriendly'Plain text version/A/TD\n;
  


Thanks in advance, and again, sorry if this is a FAQ, I just couldn't
find the answer anywhere.

-Mike Forbes
[EMAIL PROTECTED]