works on my webserver, not another- cgi error

lockmac · October 6th, 2008, 06:28 AM

Hi guys. Just need some help- i did an assignment and it works perfectly on my php, iis and oracle install at home, but when i uploaded it to my schools webserver, some of the pages dont work, well i think they perform most of the database functions, but i then get the following:

CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers.

Any one know why? Attached is the code for one of my pages.
BTW my tutor said its generally because i dont have the oci_free_statement and oci_close, but i do have these...

any help would be great thanks

Aso · October 6th, 2008, 11:45 AM

The fact that it works on your development server does suggest it's a fault with your school's set-up.

I can't take a good look at the code right now (I need my syntax highlighter @ home!) but will do later

lockmac · October 7th, 2008, 07:27 PM

Am in need of urgent help! Its due on Friday and ive spent so long doing this and if doesnt work on their server ill get 0

majorly stressssing.

thanks guys

Aso · October 8th, 2008, 06:38 AM

Everything looks OK- would be a little unsure about lines78/79;

Code:


			
            include("dbconnection.php");
            $conn = oci_connect($dbusername,$dbpassword,$dbservicename)

If you're getting these values from dbconnection.php I would think they'd need to be declared global before you use them (better yet, use constants).

As I said before, the error message strongly hints that it is a server mis-configuration @ your school, since it runs fine at home.

lockmac · October 8th, 2008, 07:14 AM

Thanks for the reply mate. Figured out just before. Its because there are some $stmt variables in their (for connecting to oracle) which i hadnt closed off with oci_free_statement and oci_close.

Thanks for the help mate

Aso · October 8th, 2008, 10:43 AM

Nice one! Glad ya fixed it

luv2php · October 9th, 2008, 02:09 PM

This really has nothing to do with your problem but I am just here to suggest it....

at the top of your "images.php" file, you have an if, else statement.

Code:


			
    if($_SESSION["loggedin"]==true)
    {
    }
    else
    {
    header("location:login.php?login=fail&return=images.php");
    }

when session_loggedin is true, it does nothing, making that if satement pretty much useless....
you should instead ask if it is NOT true, and redirect them if so in one single if like so:

Code:


			
    if(!$_SESSION["loggedin"])
    {
    header("location:login.php?login=fail&return=images.php");
    }

this one is asking if session_loggedin is FALSE, and if so, it will redirect, otherwise...it will move on. not really a big deal, but something you should try to practice.