instructions to fix MySQL/PHP PDO on 1.7

a-patchy · **Joined:** 31. December 2008 22:55 **Posts:** 5

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://www.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.

rickh57 · **Joined:** 28. April 2005 17:12 **Posts:** 25

Thanks for these instructions. They worked fine allowing me to use php/pdo once again.

Perrorist · **Joined:** 02. January 2009 10:42 **Posts:** 1

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.

Muffo · **Joined:** 09. January 2009 16:23 **Posts:** 1

Thank you very much (i couldnt get egroupware working without this)

DANS · **Joined:** 17. January 2009 18:50 **Posts:** 1

Thank you very match.

bluekelp · **Joined:** 22. January 2009 04:34 **Posts:** 1

<3 a-patchy

nutkenz · **Joined:** 14. December 2006 11:45 **Posts:** 12

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

nerdposeur · **Joined:** 25. February 2009 20:46 **Posts:** 2

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.

nerdposeur · **Joined:** 25. February 2009 20:46 **Posts:** 2

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?

Izzy · **Joined:** 25. April 2006 17:06 **Posts:** 3356

See if the fix in this topic, down near the bottom, helps with your issue:
viewtopic.php?f=16&t=29684

jackwhyte · **Joined:** 01. March 2009 01:53 **Posts:** 1

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.

admin · **Joined:** 07. April 2009 19:12 **Posts:** 3

Solution from post #1 only works for PDO. In return, normal MySQL will crash... Useless

th1alb · **Joined:** 31. August 2005 21:14 **Posts:** 99

yeah.. works to me.
ths

djnicofun · **Joined:** 16. April 2009 16:03 **Posts:** 2

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 ?

ddksix · **Joined:** 16. October 2009 05:07 **Posts:** 1

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.

Apache Friends Support Forum

instructions to fix MySQL/PHP PDO on 1.7

Who is online