Page 1 of 2

instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 31. December 2008 23:05
by a-patchy
After downloading 1.7 for windows, I found that any php programs using PDO crashed apache. Here's the fix, which I found on the german language xampp board here: http://community.apachefriends.org/f/viewtopic.php?f=4&t=32587

download this: http://windows.php.net/downloads/snaps/php-5.2-win32-VC6-x86-latest.zip

unzip, then copy libmysql.dll into xampp\apache\bin and xampp\php. Restart apache and you should be good.

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 31. December 2008 23:58
by rickh57
Thanks for these instructions. They worked fine allowing me to use php/pdo once again.

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 02. January 2009 10:48
by Perrorist
Thanks from me, too. I've spent hours trying to get the damned thing to work and resorted to workarounds. This patch did the trick immediately.

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 09. January 2009 16:26
by Muffo
Thank you very much (i couldnt get egroupware working without this)

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 17. January 2009 19:04
by DANS
Thank you very match.

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 22. January 2009 04:37
by bluekelp
<3 a-patchy

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 01. February 2009 23:12
by nutkenz
Didn't work for me... I'm using XAMPP lite and Apache is still crashing although now another module is being indicated as the culprit:

Problem signature
Problem Event Name: APPCRASH
Application Name: apache.exe
Application Version: 2.2.11.0
Application Timestamp: 493f5d44
Fault Module Name: ntdll.dll
Fault Module Version: 6.0.6001.18000
Fault Module Timestamp: 4791a7a6
Exception Code: c0000005
Exception Offset: 0006814c
OS Version: 6.0.6001.2.1.0.256.6
Locale ID: 1033
Additional Information 1: b940
Additional Information 2: e41a9fc4d02d7632b375a2c9d249a774
Additional Information 3: 4103
Additional Information 4: 343c0f93a939bdbedbd00295f403436d

Before I replaced the dll files:

Problem signature
Problem Event Name: APPCRASH
Application Name: apache.exe
Application Version: 2.2.11.0
Application Timestamp: 493f5d44
Fault Module Name: php_pdo_mysql.dll
Fault Module Version: 5.2.8.8
Fault Module Timestamp: 493d7650
Exception Code: c0000005
Exception Offset: 0000250a
OS Version: 6.0.6001.2.1.0.256.6
Locale ID: 1033
Additional Information 1: d357
Additional Information 2: 010a9d1323512c47d128df6b1f6a5171
Additional Information 3: d268
Additional Information 4: bbaf4b1bc676e48a24dbf3c68657516a

Cure worse than the disease

PostPosted: 25. February 2009 20:52
by nerdposeur
I had a test page using PDO which was crashing Apache, and I copied the .dll files as suggested in this thread.

Good news: my test page using PDO works now.

Bad news: now all my OTHER pages crash Apache.

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 25. February 2009 21:10
by nerdposeur
As a follow-up - I downloaded the ZIP package for XAMPP 1.7 and copied the libmysql.dll files from it over the broken versions, and I'm back where I started: PDO doesn't work, but the rest of my pages do.

What is actually going on here? Any chance that XAMPP will be patched to fix this?

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 26. February 2009 00:14
by Izzy
See if the fix in this topic, down near the bottom, helps with your issue:
viewtopic.php?f=16&t=29684

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 01. March 2009 01:54
by jackwhyte
Thanks very much--trying to teach myself zend framework and xampp was crapping out, while nusphere phpED was working fine. Updating the dll worked great.

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 07. April 2009 19:15
by admin
Solution from post #1 only works for PDO. In return, normal MySQL will crash... Useless

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 11. April 2009 23:08
by th1alb
yeah.. works to me.
ths

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 16. April 2009 16:09
by djnicofun
Hi,

I have the same problem i have all tested, i have apache 2.2.11 php 5.2.9 on Win XP pro Sp2 and every 5-20 minutes i have the message:
Parent: child process exited with status 3221225477

I have test to change libmysql .

Do you have a solution ? Or the ultime solution is run under Linux ?

Re: instructions to fix MySQL/PHP PDO on 1.7

PostPosted: 16. October 2009 05:17
by ddksix
This is work for me on Windows Server 2008 after copy libmysql.dll to Apache2\bin

Details:
After I install the apache and enable php with mysql sql extension.
The database test connection can be pass when I run the script with 'php' comman. ex: php test_db.php
But when I aceess this page with brower. I cannot get the result. And page with error: the connect is reset.
And the apache error.log shows:
[Thu Oct 15 08:49:42 2009] [notice] Parent: child process exited with status 255 -- Restarting.
[Thu Oct 15 08:49:42 2009] [notice] Apache/2.0.63 (Win32) PHP/5.2.10 configured -- resuming normal operations
[Thu Oct 15 08:49:42 2009] [notice] Server built: Jan 17 2008 22:58:29
[Thu Oct 15 08:49:42 2009] [notice] Parent: Created child process 10556
[Thu Oct 15 08:49:43 2009] [notice] Child 10556: Child process is running
[Thu Oct 15 08:49:43 2009] [notice] Child 10556: Acquired the start mutex.
[Thu Oct 15 08:49:43 2009] [notice] Child 10556: Starting 250 worker threads.

Yes. Apache restart evertime when I request the db test page.