Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: read database 500 error

by haukex (Archbishop)
on Aug 08, 2021 at 20:14 UTC ( [id://11135715]=note: print w/replies, xml ) Need Help??


in reply to read database 500 error

But for some reason the script keeps popping a 500 error and there is nothing in my log files.

When running a script as a CGI script, it needs to output headers before anything else. Please see one of the alternatives to CGI.pm for which modules you could use. As one example, you might try:

use CGI::Simple; my $q = CGI::Simple->new; print $q->header();

In general, Use strict and warnings, and see also Basic debugging checklist, CGI Help Guide, and Troubleshooting Perl CGI scripts. Note you can always run your CGI script from the command line first to see any errors.

Update: Also, note print ("--", @row), "\n\n"; is not doing what you think, and warnings would have given you some hints about that: it's being interpreted as ( print("--", @row), "\n\n" ); - that is, print is only getting the arguments "--", @row, but not "\n\n". You need to write print "--", @row, "\n\n"; or print(("--", @row), "\n\n"); instead. And it's best not to use $a and $b as variable names as those get special treatment by sort.

Replies are listed 'Best First'.
Re^2: read database 500 error
by Anonymous Monk on Aug 09, 2021 at 09:37 UTC

    When running a script as a CGI script, it needs to output headers before anything else. Please see one of the alternatives to CGI.pm for which modules you could use. As one example, you might try: use CGI::Simple;

    CGI::Simple is just an old stripped version of CGI.pm. CGI.pm is king of that old gateway tech. CGI::Alternatives explains

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11135715]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (4)
As of 2024-04-20 15:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found