logo
Apache Lounge
Webmasters

 

About Forum Index Downloads Search Register Log in RSS X


Keep Server Online

If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.

or

Bitcoin

A donation makes a contribution towards the costs, the time and effort that's going in this site and building.

Thank You! Steffen

Your donations will help to keep this site alive and well, and continuing building binaries. Apache Lounge is not sponsored.
Post new topic   Forum Index -> Other Software View previous topic :: View next topic
Reply to topic   Topic: phpMyAdmin: MySQL version differs from your server version
Author
ramasaig



Joined: 04 Jul 2012
Posts: 6
Location: Isle of Mull, Scotland

PostPosted: Wed 04 Jul '12 10:44    Post subject: Reply with quote

Do you know if this will work in WinXP (SP3), please ?

I've installed PHP 5.2.17 but phpMyAdmin says "Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.5.24. This may cause unpredictable behavior."

So I'm hoping a later version of PHP will solve that.

BTW I'm running Apache 2.2
Back to top
Steffen
Moderator


Joined: 15 Oct 2005
Posts: 3091
Location: Hilversum, NL, EU

PostPosted: Wed 04 Jul '12 11:22    Post subject: Reply with quote

In does not harm.

You can try a new version, see http://www.apachelounge.com/viewtopic.php?t=3890

Steffen
Back to top
ramasaig



Joined: 04 Jul 2012
Posts: 6
Location: Isle of Mull, Scotland

PostPosted: Wed 04 Jul '12 12:39    Post subject: Reply with quote

Thanks Steffen,

I've tried the new versions of the DLLs (from the link you quoted), but I'm still getting the warning message from phpMyAdmin:
"Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.5.24. This may cause unpredictable behavior."

I've cleared cache and restarted Apache.

I'll continue investigating, and maybe just upgrade the PHP with a VC9 version.

Tim
Back to top
Steffen
Moderator


Joined: 15 Oct 2005
Posts: 3091
Location: Hilversum, NL, EU

PostPosted: Wed 04 Jul '12 12:54    Post subject: Reply with quote

Did you read the Reame.txt in that .zip ?

Also replace the libmysql.dll in the PHP dir with the file included in
your MySQL 5.1.55+ \lib\opt directory.


In your case try the libmysql.dll from 5.5.24
Back to top
ramasaig



Joined: 04 Jul 2012
Posts: 6
Location: Isle of Mull, Scotland

PostPosted: Wed 04 Jul '12 13:09    Post subject: Reply with quote

Hello Steffen,

The readme.txt was the same as the contents of the post. I followed all the instructions, including replacing the libmysql.dll file from MySQL 5.5.24.

However, I don't have a \lib\opt directory, so I just used the libmysql.dll that I found in \lib. Could that have been a mistake ?

MySQL is installed in c:\Program Files, but the data is held on my 'd' partition, along with Apache & PHP. That's working perfectly well for normal usage (including phpMyAdmin), but could it make a difference to how phpMyAdmin sees the libraries ? I had thought not, but now I'm wondering.

Tim
Back to top
Steffen
Moderator


Joined: 15 Oct 2005
Posts: 3091
Location: Hilversum, NL, EU

PostPosted: Wed 04 Jul '12 13:30    Post subject: Reply with quote

Be sure that you copied to php which is used by apache.
Back to top
ramasaig



Joined: 04 Jul 2012
Posts: 6
Location: Isle of Mull, Scotland

PostPosted: Wed 04 Jul '12 13:40    Post subject: Reply with quote

Steffen wrote:
Be sure that you copied to php which is used by apache.


I've only got one PHP ! But I will check very carefully that I've not done anything stupid.

I've now moved on to testing web sites and apps that have always worked perfectly well before. There are problems which don't seem to be MySQL related, but it could be the PHP. In one app I get a PHP error:
Quote:
Warning: mysqli_connect() [function.mysqli-connect]: Headers and client library minor version mismatch. Headers:50155 Library:50051 in D:\websites\connect\mysqliconnect.php on line 4
.
So that looks as if it's now reading one of the 'new' DLLs for MySQL 5.1.55 but still not seeing a matching library. However, it's only a warning, so perhaps not actually a problem.

Tim
Back to top
ramasaig



Joined: 04 Jul 2012
Posts: 6
Location: Isle of Mull, Scotland

PostPosted: Wed 04 Jul '12 15:28    Post subject: Reply with quote

I think this PHP/MySQL library mismatch is getting me into REAL trouble.

First I got this message in the apache error log:
Quote:
Parent: child process exited with status 3221225477
which I put into Google and was able to resolve (I thought) at:
https://www.apachelounge.com/viewtopic.php?t=2856
Basically that says to move the 'libmysql.dll' file to Apache\bin.
(my d:\SERVER\PHP\ isn't on the path, I assume. I'm not vey good at adding stuff to the windows path, and avoid where I can). I've called that 'step2'.

Then I run into an error on my web page:
Quote:
Call to undefined function mysqli_connect() in <b>D:\websites\connect\mysqliconnect.php</b>

which I was NOT getting before 'step2'.

The function in 'mysqliconnect.php' is just:
Quote:
$link = mysqli_connect('localhost', 'root', 'tiree');

and it ought (of course) to access the database, and indeed did so before 'step2'. But then there were other errors...

So I am going to try a V9 version of PHP. It can't be any worse than this !

My web page runs perfectly well on the remote server (and previously locally with XAMPP), so it's NOT a problem with the page itself.
http://www.holidaymull.co.uk

Later: I have set up PHP 5.4.4 and the first tests have been OK. I'll not assume anything until I've done more !

Tim
Back to top


Reply to topic   Topic: phpMyAdmin: MySQL version differs from your server version View previous topic :: View next topic
Post new topic   Forum Index -> Other Software