PHP5 and libmysql.dll in XAMPP 1.7.0

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

PHP5 and libmysql.dll in XAMPP 1.7.0

Postby rdwonline » 14. March 2009 21:00

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?
rdwonline
 
Posts: 10
Joined: 14. March 2009 20:48

Re: PHP5 and libmysql.dll in XAMPP 1.7.0

Postby Izzy » 14. March 2009 23:37

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.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: PHP5 and libmysql.dll in XAMPP 1.7.0

Postby rdwonline » 15. March 2009 20:43

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.
rdwonline
 
Posts: 10
Joined: 14. March 2009 20:48

Re: PHP5 and libmysql.dll in XAMPP 1.7.0

Postby Izzy » 17. March 2009 00:03

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
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: PHP5 and libmysql.dll in XAMPP 1.7.0

Postby admin » 07. April 2009 19:15

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.
admin
 
Posts: 3
Joined: 07. April 2009 19:12

Re: PHP5 and libmysql.dll in XAMPP 1.7.0

Postby Sharley » 08. April 2009 05:36

No need to display your crudeness on these family orientated support forums.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: PHP5 and libmysql.dll in XAMPP 1.7.0

Postby rdwonline » 10. April 2009 01:41

This PDO/MySQL thing really needs to be fixed!
rdwonline
 
Posts: 10
Joined: 14. March 2009 20:48


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 44 guests