Page 1 of 1

PHP5 and libmysql.dll in XAMPP 1.7.0

PostPosted: 14. March 2009 21:00
by rdwonline
There is a major problem with the libmysql.dll library that is included with the XAMPP 1.7.0 Win32 package. The packaged dll can be used with the native MySQL functions, but will cause Apache to crash if at any time you use the query() method in an instance of a PDO object that touches at least one MySQL database. Someone posted a "fix" for this here http://www.netfulvpc.fr/phptechnoframe/trucs-et-astuces/xampp-17#comment-176; however, while this may work for PDO this in turn uses a different version of libmysql than is used with MySQL (I didn't notice this until I tried to use phpMyAdmin).

In general I will never use both PDO and the MySQL functions in the same project, let alone the same script. However, I should be able to use either one anytime I damn well please.

Again, AS PACKAGED in the installer, apparently the libmysql.dll will work for the MySQL functions but will cause Apache to CRASH when you are using PDO with a MySQL driver.

I don't want to have to shut down my server, swap out the libmysql.dll files, and restart the server depending on however I choose to interface with MySQL.

Has anyone else had this very same issue with XAMPP 1.7.0 on Windows?

Re: PHP5 and libmysql.dll in XAMPP 1.7.0

PostPosted: 14. March 2009 23:37
by Izzy
What version of Windows which was omitted?

Only a forum search away was this post with a possible fix and a link to another possible fix included or wait perhaps for the next version 1.7.1 which is due to be released soon as it nears the end of it's beta run:
viewtopic.php?f=16&t=32617&start=0

BTW your link to the French site timed out and was unavailable when I tried it.

Re: PHP5 and libmysql.dll in XAMPP 1.7.0

PostPosted: 15. March 2009 20:43
by rdwonline
The operating system is Windows XP SP2

From what I can tell that forum has the exact same "fix". And now (as previously stated) only my PDO stuff works, and none of the native MySQL functions.

So your forum search basically pulled up the same thing I had done on my own.

Re: PHP5 and libmysql.dll in XAMPP 1.7.0

PostPosted: 17. March 2009 00:03
by Izzy
There was another fix (that's 2) within in my first link that may help with this known bug.
Linked from here:
viewtopic.php?p=136851#p136851
To here:
viewtopic.php?p=136684#p136684

Re: PHP5 and libmysql.dll in XAMPP 1.7.0

PostPosted: 07. April 2009 19:15
by admin
I have the same problem.

Libmysql from XAMPP 1.70 crashes PDO MySQL.

Libmysql from PHP 5.2.9 works with PDO, but crashes normal MySQL.

I have to swap out DLL's for every project.

I'm going back to a regular standalon PHP/Apache/MySQL/ Ill put it together myself dammit.

Re: PHP5 and libmysql.dll in XAMPP 1.7.0

PostPosted: 08. April 2009 05:36
by Sharley
No need to display your crudeness on these family orientated support forums.

Re: PHP5 and libmysql.dll in XAMPP 1.7.0

PostPosted: 10. April 2009 01:41
by rdwonline
This PDO/MySQL thing really needs to be fixed!