Keep Server Online
If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.
or
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.
| |
|
Topic: phpMyAdmin: MySQL version differs from your server version |
|
Author |
|
ramasaig
Joined: 04 Jul 2012 Posts: 6 Location: Isle of Mull, Scotland
|
Posted: Wed 04 Jul '12 10:44 Post subject: |
|
|
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: 3092 Location: Hilversum, NL, EU
|
|
Back to top |
|
ramasaig
Joined: 04 Jul 2012 Posts: 6 Location: Isle of Mull, Scotland
|
Posted: Wed 04 Jul '12 12:39 Post subject: |
|
|
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: 3092 Location: Hilversum, NL, EU
|
Posted: Wed 04 Jul '12 12:54 Post subject: |
|
|
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
|
Posted: Wed 04 Jul '12 13:09 Post subject: |
|
|
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: 3092 Location: Hilversum, NL, EU
|
Posted: Wed 04 Jul '12 13:30 Post subject: |
|
|
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
|
Posted: Wed 04 Jul '12 13:40 Post subject: |
|
|
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
|
Posted: Wed 04 Jul '12 15:28 Post subject: |
|
|
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 |
|
|
|
|
|
|