I accomplished nothing (also help wanted)

David on 12/12/2005 at 21:39

So the marvellous 30 minute downtime turned into a 95-minute downtime during which time I managed to accomplish nothing.

I was upgrading PHP4 to PHP5 in the hope of eradicating the error we've been having lately. This error will manifest itself to you guys as "There appears to be a problem with the database"

Anyway, PHP5 hangs when attempting to load php_mysql.dll. There's no error message, no nothing, it just sits there loading when I run a php script - any php script, even <?php phpinfo();?>

This was with ISAPI PHP5.1.1. I've uploaded PHP5.0.5 which I've been running on my own machine, along with an old dump of the forums DB, so I know it works and still no joy

For the meantime I've reverted back to php4, so now I intend to run around php forums like a headless chicken trying to find a solution.

If you've got any ideas, let me know, cheers!

<div class="smallfont">ps any <em><Vigil> T DAVE WHY DON'T YOU CONVERT TO PYTHON</em> and you get banned ;)</div>

David on 13/12/2005 at 08:00

<div class="smallfont">Turns out I can't spell</div>

Lazarus411 on 13/12/2005 at 15:51

The only cure is fire...and lots of it.

[SPOILER]p.s. just kidding.[/SPOILER]

mol on 13/12/2005 at 19:45

The logs showed nothing? No indication as to why it hung? Does PHP find all the necessary dll's? I found some references to similar symptoms where the problem had been related to PHP5 not finding all the required DLLs.

I have no experience with these systems, but I just went looking for clues anyway, out of interest. Are these cases relevant at all?

(http://www.codecomments.com/archive227-2004-9-280544.html)
(http://forums.neverside.com/thread/48400/)
(http://fi2.php.net/manual/fi/faq.databases.php#faq.databases.mysql.php5)

Edit: or did the spelling reference mean that it was just a case of typing something wrong? In which case forget all the above.:o

David on 13/12/2005 at 19:53

I mistyped the path to PHP in the Windows 'PATH' Environmental Variable. Apparently it didn't guess that c:\pgp\ meant c:\php\.

Basically php_mysql.dll was loading, but was unable to find libmysql.dll despite it being in the same folder as the main PHP dll.

mol on 13/12/2005 at 19:58

Oh, ok!

That exact same problem was described in this document, (http://fi2.php.net/manual/fi/faq.databases.php#faq.databases.mysql.php5) (or rather it just says to make sure that libmysql.dll in available to the system's PATH.)

Glad you sorted it out, though! :)

Briareos H on 14/12/2005 at 02:30

What, DLL ? Do you mean that TTLG is running on a freakin' WINDOWS machine ???

mOdEtWo on 14/12/2005 at 07:21

Quote Posted by Briareos H

What, DLL ? Do you mean that TTLG is running on a freakin' WINDOWS machine ???

Yes, it is.

Omega on 14/12/2005 at 09:06

OMGZ DERS UR PROB!!!1 :eww:

Briareos H on 14/12/2005 at 09:23

YA M$ IS EBIL M1STR !!!1