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=4&eqtype=All&cont=&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



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=4&eqtype=All&cont=&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
> 'debug\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 " HREF=\"$pass\" target='printerfriendly'>Plain text version\n";
> 
> 
> 
> Thanks in advance, and again, sorry if this is a FAQ, I just couldn't
> find the answer anywhere.
> 
> -Mike Forbes
> [EMAIL PROTECTED]
> 
> 





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
'debug\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 "Plain text version\n";
  


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

-Mike Forbes
[EMAIL PROTECTED]