This is the community forum. For a developer response use the Client Area.
Follow us on Facebook, Twitter and YouTube!

Possible MySQL Version Conflict
#1

The requirements states that MySQL 5.0.7 or higher is needed. ref: requirements page


The installer reports back:

PHP version is 5.2 or higher Pass
MySQL version is 5.0.7 or higher Pass
Ctype extension is available Pass
Suhosin is not installed Pass
Mail() function is enabled Pass
GD Library is installed Pass
Magic Quotes is disabled Pass
System() function is enabled Pass
cURL is installed Pass
fopen(URL) is enabled Pass


My current status from phpinfo.php:

MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.51a

How did this pass while I have not met the mysql requirements? Is the client API the same as the mysql version?
Reply
#2

I believe that it has to do with the version_compare() function in php.
If you take a look at some of the comments in the manual ( http://php.net/manual/en/function.version-compare.php ), you'll see that there are some inconsistencies for checking mysql versions. It still doesn't explain why that works, but it could be the "a" at the end that's tripping up the function, or the value that mysql_get_server_info() is returning. That has to do with PHP and not the installer.

Code used to check versions:
PHP Code:
<?php 
if (version_compare(mysql_get_server_info(), '5.0.7', '>=')) {
echo
"MySQL version is 5.0.7 or higher <span class='system_green'>Pass</span>";
} else {
echo
"MySQL version is lower than 5.0.7 <span class='system_red'>Fail</span>";
$notes .= "- you must have MySQL 5.0.7 or higher.<br />";
$proceed = false;
}

If you want, you can test what mysql_get_server_info() is returning by adding
PHP Code:
<?php 
echo mysql_get_server_info();
somewhere inside of a php tag. Try the include script or the installer file, for example.

I'm giving you three guesses...
Reply
#3

Ok, here is the version that is running.

-------------------------------------------------------------------------------
Server Information
MySQL Version: MySQL 5.0.51a-community-nt via TCP/IP
--------------------------------------------------------------------------------
Client Information
Version: MySQL Client Version 5.1.11

-----
Reply


Possibly Related Threads…
Thread / Author Replies Views Last Post
Last Post by Steven
08-Feb-2019, 04:57 PM
Last Post by Thomass
05-Dec-2016, 05:29 PM
Last Post by Agnes
24-Nov-2016, 10:29 PM
Last Post by jackson
12-May-2016, 09:19 PM
Last Post by Steven
18-Apr-2015, 02:00 PM
Last Post by trev40
17-Dec-2010, 10:26 PM
Last Post by Static
01-Sep-2010, 05:44 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)