Hi,

First I installed this:
http://www.jpdeni.com/dbman/Mods/short_html_pl.txt

Then I installed this:
http://www.jpdeni.com/dbman/Mods/secure_lookup.txt

Everything was fine and working well at this point.

Then I installed this:
http://www.jpdeni.com/dbman/Mods/validate1.txt

Everything works except when I Validate Records (http://defend.net/database/db.cgi?db=default&uid=admin.95743742490143&validate_form=1) I receive a 500 server error. The record is validated however. I assume there is a problem displaying the success page, but I'm not sure where to proceed from here.

Any ideas would be appreciated!!!

Thanks,

Tim

Tim:

500 server errors can mean different things and are not always easy to find.

Please install this small snippet to your script and see if it will help you to pinpoint the script error.

How To Obtain Useful Error Messages

To obtain useful error messages, add the following snippet to your script, just beneath the shebang line (the first line of the script; usually !#/usr/local/bin/perl or !#/usr/bin/perl):

BEGIN {
open (STDERR, ">/path/to/somewhere/error.txt");
}

Now create an empty plain text file named "error.txt" and upload it in ASCII mode to your somewhere/ directory. Chmod it to 777.

Now run your script from your browser. After it gives you its error message, call your error.txt from the browser (for example, http://www.your_site.com/somewhere/error.txt; you might make a
bookmark for it because, if you're like me, you'll be using it a lot!). The reason for your script's failure should be written there.

Note: If you call the error.txt file more than once, you may have to hit your browser's "reload" button.

Hope this helps many to find the errors they encounter and find the solutions faster.

Hi,

Thanks for you reply.

I tried that and the error.txt file was empty. I also tried this:

#!/usr/local/bin/perl
use CGI;
use CGI::Carp qw(fatalsToBrowser carpout);
open (LOG,">>/home/public_html/database/auth/error.txt") | |
die "couldn't open log file: $!";
carpout(LOG);

Still an empty error.txt file.

What a pain!

Tim

The only thing I can suggest is that I take a look at your files -- html.pl and db.cgi.

Do you know how to make them available in .txt form for me to see on the web?


------------------
JPD