perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian Gaber" <Brian.Ga...@PWGSC.GC.CA>
Subject RE: mod_perl2 newbie DBI question
Date Thu, 12 Jun 2008 18:54:30 GMT
Answers:

Is there anything useful in the Apache error log?  Works fine a few
times and then
DBD::mysql::st execute failed: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '' at line 1 at
/usr/local/apache2/perl-run/regDelLocks.pl line 191.\n

What happens in the browser when it stops working?
The server encountered an internal error or misconfiguration and was
unable to complete your request.

What platform are you running on (windows, linux, etc.)?
Server is AIX.  Client is Windows.

Are you seeing this in your development environment? Yes

Can you reproduce the problem reliably? Yes

Thanks.

-----Original Message-----
From: Jim Brandt [mailto:cbrandt@buffalo.edu] 
Sent: Thursday, June 12, 2008 2:36 PM
To: Michael Peters
Cc: Brian Gaber; modperl@perl.apache.org
Subject: Re: mod_perl2 newbie DBI question



Michael Peters wrote:
> Brian Gaber wrote:
> 
>>         I have modified scripts to work in mod_perl2, but they don't 
>> work reliably.  Sometimes they work and then they stop working and 
>> then I have to stop and start Apache to get it working again.
> 
> "stop working" is really too generic a description for anyone to 
> really diagnose. It's kind of like telling your doctor "I'm sick, 
> here's my picture, tell me what's wrong" :)

Some information that can help:

Is there anything useful in the Apache error log?

What happens in the browser when it stops working?

What platform are you running on (windows, linux, etc.)?

Are you seeing this in your development environment?

Can you reproduce the problem reliably?


> 
>> I am hoping if
>> I supply one of my scripts someone can advise me what needs to be 
>> done to make in work fast and reliably and then I can use this as an 
>> example to fix my other scripts.  Here is the one script:
> 
> The best way to get help is to make the problem script as small as 
> possible. As it stands right now, it's a bit like homework trying to
read through your problem.
> 

--
Jim Brandt
Administrative Computing Services
University at Buffalo


Mime
View raw message