#42264 [NEW]: php-5.2.3 and mysql 5.0.16 on windows xp

From: ericrose at hotmail dot com Operating system: win xp PHP version: 5CVS-2007-08-10 (snap) PHP Bug Type: *Compile Issues Bug description: php-5.2.3 and mysql 5.0.16 on windows xp Description: ------------ I originally wrote this for beginner's who were having issues so bare with me. I've figured out what the problem is with installing php-5.2.3 and mysql 5.0.16 on windows xp. with apache 2.0 I really don't know what's happening, I'll leave that up to you. Anyways there seems to be a conflict going on, a "you can have one thing but not the other scenario" When php5 windows binary installer runs it creates your php.ini file, with all sorts of configuration data. One very important line is extension_dir it looks something like this extension_dir "C:\php\ext\" This directive tells php where it's extension files are stored, in order to use mysql, you need to have selected the extension mysql at the time of install, it copies the file php_mysql.dll into the "C:\php\ext\" folder. You are also asked at the time of install, the path to your apache config folder, it then writes some directives in the file httpd.conf, it looks like this PHPIniDir "C:\\PHP5\\" LoadModule php5_module "C:\\PHP5\\php5apache2.dll" Now you may think that this looks all great, and you should have php running along side mysql. Wrong! I can tell you how to get your mysql working fine. Simply change the two forward slashes to one backwards slash. PHPIniDir "C:/PHP5/" LoadModule php5_module "C:/PHP5/php5apache2.dll" Restart your server and you'll be able to connect to your database. Herein lies the double edged sword. Now you've lost much php functionality, including error reporting. -- Edit bug report at http://bugs.php.net/?id=42264&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=42264&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=42264&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=42264&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=42264&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=42264&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=42264&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=42264&r=needscript Try newer version: http://bugs.php.net/fix.php?id=42264&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=42264&r=support Expected behavior: http://bugs.php.net/fix.php?id=42264&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=42264&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=42264&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=42264&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=42264&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=42264&r=dst IIS Stability: http://bugs.php.net/fix.php?id=42264&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=42264&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=42264&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=42264&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=42264&r=mysqlcfg