instructions to fix MySQL/PHP PDO on 1.7

Problems with the Windows version of XAMPP, questions, comments, and anything related.

instructions to fix MySQL/PHP PDO on 1.7

Postby a-patchy » 31. December 2008 23:05

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.
a-patchy
 
Posts: 5
Joined: 31. December 2008 22:55

Re: instructions to fix MySQL/PHP PDO on 1.7

Postby rickh57 » 31. December 2008 23:58

Thanks for these instructions. They worked fine allowing me to use php/pdo once again.
rickh57
 
Posts: 25
Joined: 28. April 2005 17:12

Re: instructions to fix MySQL/PHP PDO on 1.7

Postby Perrorist » 02. January 2009 10:48

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.
User avatar
Perrorist
 
Posts: 3
Joined: 02. January 2009 10:42
Location: Australia
XAMPP Version: 1.8.3-1
Operating System: Windows 8.1 Update

Re: instructions to fix MySQL/PHP PDO on 1.7

Postby Muffo » 09. January 2009 16:26

Thank you very much (i couldnt get egroupware working without this)
Muffo
 
Posts: 1
Joined: 09. January 2009 16:23

Re: instructions to fix MySQL/PHP PDO on 1.7

Postby DANS » 17. January 2009 19:04

Thank you very match.
DANS
 
Posts: 1
Joined: 17. January 2009 18:50

Re: instructions to fix MySQL/PHP PDO on 1.7

Postby bluekelp » 22. January 2009 04:37

<3 a-patchy
bluekelp
 
Posts: 1
Joined: 22. January 2009 04:34

Re: instructions to fix MySQL/PHP PDO on 1.7

Postby nutkenz » 01. February 2009 23: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
nutkenz
 
Posts: 12
Joined: 14. December 2006 11:45

Cure worse than the disease

Postby nerdposeur » 25. February 2009 20:52

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
 
Posts: 2
Joined: 25. February 2009 20:46

Re: instructions to fix MySQL/PHP PDO on 1.7

Postby nerdposeur » 25. February 2009 21:10

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?
nerdposeur
 
Posts: 2
Joined: 25. February 2009 20:46

Re: instructions to fix MySQL/PHP PDO on 1.7

Postby Izzy » 26. February 2009 00:14

See if the fix in this topic, down near the bottom, helps with your issue:
viewtopic.php?f=16&t=29684
Last edited by Izzy on 12. March 2009 09:58, edited 1 time in total.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: instructions to fix MySQL/PHP PDO on 1.7

Postby jackwhyte » 01. March 2009 01:54

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.
jackwhyte
 
Posts: 1
Joined: 01. March 2009 01:53

Re: instructions to fix MySQL/PHP PDO on 1.7

Postby admin » 07. April 2009 19:15

Solution from post #1 only works for PDO. In return, normal MySQL will crash... Useless
admin
 
Posts: 3
Joined: 07. April 2009 19:12


Re: instructions to fix MySQL/PHP PDO on 1.7

Postby djnicofun » 16. April 2009 16:09

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 ?
djnicofun
 
Posts: 2
Joined: 16. April 2009 16:03

Re: instructions to fix MySQL/PHP PDO on 1.7

Postby ddksix » 16. October 2009 05:17

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.
ddksix
 
Posts: 1
Joined: 16. October 2009 05:07

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 41 guests