Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.33. This may cause unpredictable behavior.

helavissa - June 3, 2009 - 16:34

Hi,

I'm using localhost and phpmyadmin gives me the following error:

"Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.33. This may cause unpredictable behavior."

Does anybody know how to fix it? or should i do smth about it?

Thank you.

» Login or register to post comments

The php interface to MySQL is

marquardt - June 3, 2009 - 16:54

The php interface to MySQL is written in C, and compiled/linked against the system libraries of MySQL. The error message tells you that the MySQL version which was used to build the php extension of your web server was older than the MySQL you've actually installed on your system. This might have happened because you have updated your data base to a newer version, but didn't update your php installation accordingly.

If you want to avoid trouble, I would downgrade the MySQL to the same version as your php; if your Linux (are you on a Linux box?) is a standard distribution, you'll probably just want the system default. Also, AFAIK, v5.1 of MySQL still might have a few bugs; v5.0 might actually a be a better choice unless your main interest is in database development. And Drupal will happily run with 5.0.

thanks for reply, i'm using

helavissa - June 3, 2009 - 17:13

thanks for reply, i'm using wampserver and actually it says that php version is 5.2.9-2. also i've installed everything together and since then didn't update it.

I've no experience with the

marquardt - June 3, 2009 - 17:48

I've no experience with the wampserver (and don't use WIndows much) - but I'd still say that the Apache/PHP you've installed on your computer has been built against another version of the mysql database that you are actually running. Are you sure you only have a single Apache/PHP installation on your computer? The wampserver home page also says that you cannot just install a newer version of their distribution ("WampServer2") over an older, existing ("WAMP5") existing one; you must remove any previous installation before you install the most recent one...

Hope this helps. If not, I suggest that you try to get some help from the WampServer forums; people there will be much more knowledgeable about that particular distribution of Apache, MySQL and PHP than people here on the Drupal forum. After all, it's a problem of your system stack, and not related to Drupal...

This page suggests that it is

jdleonard - June 7, 2009 - 15:03

This page suggests that it is a PHP bug. Regardless, as long as you're not using the installation on a production site and you don't notice any problems beyond that message, you should be fine.

JD Leonard
http://www.jdleonard.net

I agree that it may be a bug

YunaMonos - July 10, 2009 - 08:10

I agree that it may be a bug as this error appears during first WampServer 2.0 install on a 'clean' machine, i.e. no previous versions of PHP, MySQL, Apache or WAMP on the box.

It's a shame, that link is

mikenotmike - July 30, 2009 - 05:03

It's a shame, that link is the closest thing I can find to confirming it's just a bug. Your statement suggests one should be weary of building a production site under these circumstances, if that's the case then WAMP isn't a viable option for anything more than testing... That's a pretty heavy suggestion considering the majority of all localhost tutorials are made for WAMP

I did find a few other blogs suggesting that the difference in versions is irrelevant regardless of bugs, but I found others that claim developing on unmatched versions can result in untold errors down the road.

We need a definitive answer on this otherwise WAMP is useless until Drupal 7 becomes the norm, or D6 starts supporting php 5.3

Or should we just manually downgrade mysql to match the PHP library? But I hear 5.0.51a is buggy and should be avoided... what to do

xampp?

I only use WAMP for testing

jdleonard - August 19, 2009 - 18:33

I only use WAMP for testing so fortunately I don't really need to worry about it. My best suggestion is to not use WAMP in a production environment. You can assemble the pieces that WAMP puts together yourself, but it will be a bit more work. From a security perspective, this is better anyways because you know exactly what is running on your server and in what configuration.

JD Leonard
http://www.jdleonard.net

this'll fix it (for windows XP)...

lancsDavid - November 17, 2009 - 19:07

1. go to wampserver tray icon (little white hemisphere in bottom right of screen. sometimes yellow or red)
2. go to MySQL > Version > Get More... this takes you to the Add-ons page for Wampserver
3. grab the MySQL 5.0.51a executable. then run it & it'll install it on your computer
4. exit Wampserver (don't know if this step is needed but I did it)
5. restart Wampserver, go back to MySQL > Version & "da da" (you'll now have 2 versions to choose from)
6. choose 5.0.51a & have no more problems

P.S: i've just downloaded Wampserver 2.0i & the Views interface wouldn't work (just kept giving me error popups every time I either clicked on an icon or a link). so i recommend this approach (Wampserver 2.0h with the MySQL downgrade)

P.S2: i found out how to do this from http://noteslog.com/post/your-php-mysql-library-version/ (deals with Wampserver 2.0f but i think everything else is similar)