php scripts stopped working

t_bag

Hello everyone!

I really can't explain it, but my scripts stopped working all of a sudden. All was working fine, but suddenly the pages won't load. The strange thing is that some of the scripts still work, some (which worked fine before) don't anymore. Also I'm using phpmyadmin and I can still connect to and alter the database with it. So I really don't know what the problem is 😕 I don't get any error messages.

Also, I have noticed that several instances of php.exe appear in the taskmanager. Dunno if this is connected with the problem.

I read on a different board that it might be because of an antivirus program, and it's true I'm running one, but it was running when the scripts were working fine too, so it can't be the reason I think?

Reboot doesn't help, so I consider reinstalling PHP (or is it maybe a MySQL problem?) if i don't find out what is going on. Hopefully a reinstall will solve the problem.

Did anyone have a similar problem?

Thanks in advance for any ideas.

t.bag

PS: I am using PHP 4.3.0/MySQL 3.23.55/Apache 1.3.27/WinXP.

[edit]

Ok, this might be helpful: I used the following script (scroll down to the "Testing MySQL" part) and what it did was the following:

The page loaded the first time so the entry Amir Khan appeared in the browser window. So a database and a table were successfully created and data entered. Phpmyadmin confirms it. But for some reason the page fails to load when I hit reload ... It looks like it would load, but it takes forever and it never actually loads. No further entries are added to the table (like they should when the page is refreshed). I know this script works, as I have tested it before, but it doesn't anymore 🙁
What do you think?

Yeah and I've installed PHP 4.0.1 and MySQL 4.0.12 now, but the scripts behave in exactly the same way as before 🙁

[/edit]

planetsim

Timeout error

Most likely an ever ending loop

can be caused by including a file that has an include in it..

Or while,for,do.. while loops.

Other than that i cant think of much more.

Just check over the code you have. Make sure there arent any errors..
And make sure that all { are closed off with }

One of the most common errors.

t_bag

Thanks, I'll check this 🙂

Oh and I've installed PHP 4.3.1 (not 4.0.1 as I wrote above).

LuckyGT

Originally posted by planetsim
Timeout error

Most likely an ever ending loop

can be caused by including a file that has an include in it..

Or while,for,do.. while loops.

Other than that i cant think of much more.

Just check over the code you have. Make sure there arent any errors..
And make sure that all { are closed off with }

One of the most common errors.

As t.bag has already stated, the scripts worked fine before and they have -NOT- been modified prior to the problems, so what would make you think that it was an error in coding? The only way that may have happened is if the scripts suddenly became aware of their existence and decided to anamorphically recode themselves and, as far as I know, other than in the fantasy of Hollywood, AI has not come that far yet.

I have actually been having the same exact problem as of very recently and I, too, know that I have not in any way modified the scripts that worked just a day or two ago and have suddenly stopped working.

The only things I have modified are as follows:

I use CJB.net for redirection and right before this all went down, I changed the IP address on CJB to 127.0.0.1 (just picked a feasible IP) so that my site would be inaccessible from the outside world for a little bit while I made plans to implement some new ideas (though, I haven't made the changes yet).

Also, I changed a couple of lines in the httpd.conf file for Apache (2.0.46) to be able to use .htaccess and .htpasswd files for authentication in one or two of my subdirectories. Basically changing the 'All' option in 'Options' and 'AllowOverride' to 'AuthConfig', though I have since chenged everything back to their original settings in the hopes that whatever I did might have been the problem and reversing it all would fix it, but to no avail. All I get when I load my page is a blank page and when I check the source all I get is a generic, empty, HTML skeleton, so-to-speak:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1"></HEAD>
<BODY></BODY></HTML>

Just can't seem to figure this one out. Any help would be appreciated, and if I get some headway on this problem, I'll be sure to post whatever I figure out.

LuckyGT

Well, I figured my problem out. Not sure if this will help anyone else, but figured I'd post just in case...

As I said in the last post, I had only changed a few things, but had changed them back in the hopes that they would fix the problem. There was actually one very important change I had forgotten about. I few days ago I realized that I had never password protected the user 'noone' in MySQL and promptly took the time to password protect it just to block off a little bit of insecurity at the head. The only thing I forgot about, though, was that I was using 'noone' as the user to connect with the MySQL database and forgot to insert the new password into the 'config.php' file so that PHP scripts can have authorization to utilize data from the MySQL databases.

I just inserted this password into the $dbpass field in the 'config.php' file and, viola, everything works great again.

What surprises me, though, is the reason why I hadn't thought of this as why my PHP scripts hadn't worked, which was because my website didn't go down until a day or two -AT LEAST- after I had made this change. Not exactly sure why the delay, but it's a good thing I thought of this or else I probably would have wracked my brain for days trying to figure this out.

Again, not sure if this is the case for anyone else, or if it helps, but I guess it helps knock out one more variable in the chain of 'guess and check'.

planetsim

hmm this happens quite a lot.. I know a couple of people that have done that lately..