Re: Re: HTTP Error 500 - IsapiModule

Stuart you have been very helpful thank you. I have learnt a number of valuable lessons this afternoon. - Gary ""Gary Maddock-Greene"" <gmg@maddock-greene.co.uk> wrote in message news:A4.34.09584.E39AB494@pb1.pair.com...

Yes .. thanks Stuart. If I comment out that line I now get a different problem!! Unable to connect to database. One step closer!!! "Stuart" <stuttle@gmail.com> wrote in message news:a5f019de0812190556g611cd672k25a30b77d02adbef@mail.gmail.com...

2008/12/19 Gary Maddock-Greene <gmg@maddock-greene.co.uk>:

$sql_query = mysql_query("SELECT * FROM products WHERE MATCH(product_name,product_image) AGAINST('$search_term')"); // This is line 20 where I am getting the parse error many mathces (too many matches cause returning of 0 results)

That line is not valid code. I'm guessing it's part of a comment that has mistakenly been broken across 2 lines. -Stuart -- http://stut.net/

"Stuart" <stuttle@gmail.com> wrote in message news:a5f019de0812190516r3cdcdacana356320f39a8d79d@mail.gmail.com...

2008/12/19 Gary Maddock-Greene <gmg@maddock-greene.co.uk>:

Thanks Stuart, Logs are no enabled and I generate this line: #Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status time-taken Sorry this is only my 2nd day with php/MySQL and I really need to get this working so I appreciate the help.

That's the IIS log not the PHP log. See here for details: http://uk.php.net/errorfunc.configuration Look for log_errors and error_log. They work together to give you a PHP error log file. Did you try using php -l on the file? -Stuart -- http://stut.net/

"Stut" <stuttle@gmail.com> wrote in message news:a5f019de0812190459w486205a4n5fe8fea317890b86@mail.gmail.com...

Please include the list when replying. 2008/12/19 G. Maddock-Greene <gmg@maddock-greene.co.uk>:

You may be right Stuart ... I am thinking this too. I can access my database with an auto generated call using say Dreamweaver, but my hand code is throwing the error ... though I cannot see why!! It's really frustrating

Look in your php.ini and make sure log_errors is on and the filename it's directed at is writable by IIS. Restart IIS and PHP errors should then appear in that file. Alternatively use the PHP command line executable with the -l (lint) argument to check the syntax of a file. -Stuart -- http://stut.net/

----- Original Message ----- From: "Stut" <stuttle@gmail.com> Newsgroups: php.general To: <robleyd@aapt.net.au> Cc: <php-general@lists.php.net> Sent: Friday, December 19, 2008 11:58 AM Subject: Re: [PHP] Re: HTTP Error 500 - IsapiModule

2008/12/19 David Robley <robleyd@aapt.net.au>:

Gary Maddock-Greene wrote:

Hi, Don't know if this is the right group but I am having real problems trying to connect to my MySQL db with php. I am trying to create a search form. I can connect and display in my browser a simple call to a db record but when I try to execute my search script I get a 500 Internal Server error: IsapiModule / ExecuterequestHandler. I'm stumped! Any help please or pointers. Thanks Gary

The first thing when you get a 500 error, which is a server error not php, is to check the server error log.

I might be wrong but I think syntax errors can cause a 500 status when using ISAPI. -Stuart -- http://stut.net/

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php