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:[EMAIL PROTECTED] 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
