Solved

PHP5 + MySQL gives Internal Server Error

Posted on 2008-06-23
6
342 Views
Last Modified: 2013-12-13
I get an HTTP 500 Internal Server Error when I execute some scripts.

I have narrowed it down to sections of the scripts that use the mysql_connect(). Other scripts, that don't reference the database, work.

It seems like when it tries to use the DB library it throws an error. How do I troubleshoot this error?

Fresh installation of XP Professional, PHP5 (current General Release) and MySQL5 (current generally available release) and Apache 1.3.41.
0
Comment
Question by:DrDamnit
  • 3
  • 2
6 Comments
 
LVL 32

Author Comment

by:DrDamnit
ID: 21847285
Found a clue?
PHP Warning:  require_once(./includes/Defines.php): failed to open stream: No such file or directory in C:\Webroot\somedomain.com\wikimanual\index.php on line 30
PHP Fatal error:  require_once(): Failed opening required './includes/Defines.php' (include_path='.;c:\php\includes') in C:\Webroot\somedomain.com\wikimanual\index.php on line 30

Open in new window

0
 
LVL 82

Expert Comment

by:hielo
ID: 21847288
update mysql_connect(...) to:
mysql_connect(...) or die( "Error: ".mysql_error() );

0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 21847312
>PHP Warning:  require_once(./includes/Defines.php): failed to open stream: No such file or directory in C:\Webroot\somedomain.com\wikimanual\index.php on line 30

check the index.php on line 30, it does a require_once as shown, however, the file:
C:\Webroot\somedomain.com\wikimanual\includes\Defines.php
does not exist.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 82

Expert Comment

by:hielo
ID: 21847321
Ok. That's the reason. Your script is unable to locate Defines.php. Basically the path to that is incorrect. Try providing the full path:
require_once('C:\Webroot\somedomain.com\wikimanual\includes\Defines.php');

(I am just guessing the path. Adjust if necessary)
0
 
LVL 32

Author Comment

by:DrDamnit
ID: 21848973
The problem was with PHP5. I restored C:\PHP5 from a backup, and now everything is gravy.
0
 
LVL 82

Assisted Solution

by:hielo
hielo earned 250 total points
ID: 21849566
>> and now everything is gravy
Yummy! Glad things worked out. Take care!
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will explain how to display the first page of your Microsoft Word documents (e.g. .doc, .docx, etc...) as images in a web page programatically. I have scoured the web on a way to do this unsuccessfully. The goal is to produce something …
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to count occurrences of each item in an array.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question