FORUMS


The Form Tools forums are no longer active, but the old posts have been archived here. Please see the Help page on how to get help / report issues.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MySQL ver. correct but install fails- OSX
#1
I am attempting to install Forms Tools /localhost/ running on OSX .
--
Install System Check Shows:
PHP - 5.3.0 PASS
MySql - mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $ FAIL
Write Permissions PASS
/themes/default/cache/ PASS
--
Anyone know how to rename the version to force a pass ? Shows the same version info running phpinfo.php

Thanks
Dennis
Reply
#2
Hi Dennis,

What happens to make it fail, exactly - blank page or something? I'm also running it on OSX localhost and haven't encountered this problem yet.

Thanks!

- Ben
Reply
#3
(Sep 18th, 2009, 11:17 AM)Ben Wrote: Hi Dennis,

What happens to make it fail, exactly - blank page or something? I'm also running it on OSX localhost and haven't encountered this problem yet.

Thanks!

- Ben

-Fails System check on MySQL: Requirements not met.
I have included a screenshot.jpg


Attached Files Thumbnail(s)
   
Reply
#4
Here is the PHPInfo.php File as well if it helps.
Installer just stops at this point and will not continue.
Vers. 1 of Form Tools installs ok.


Attached Files Thumbnail(s)
   
Reply
#5
Oh wow, neat! Thanks for the screenshot. Form Tools uses the mysql_get_client_info() function (see here: http://ca2.php.net/manual/en/function.my...t-info.php).

That function SHOULD return a integer-like string of the MySQL number. On your system it's that long string that it outputs in the page. It shouldn't do that! Smile

But if you'd like to just bypass it, you can just hack the code a bit. In your /install/step2.php find these lines:

PHP Code:
// 2. MySQL version (4 or later)
$valid_mysql_version false;
if (
substr(mysql_get_client_info(), 01) >= 4)
  
$valid_mysql_version true

and change them to:

PHP Code:
// 2. MySQL version (4 or later)
$valid_mysql_version true;
//if (substr(mysql_get_client_info(), 0, 1) >= 4)
//  $valid_mysql_version = true; 

I *think* that will let you bypass this problem altogether, but I can't be sure that other problems might not crop up.

- Ben
Reply
#6
I'm having the same problem, the mysql_get_client_info() command is retrieving the wrong information (mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $_) when I clearly have MySQL 5.1 installed.

This is obviously a problem with Snow Leopard or PHP 5.3 or both, but after 3 hours of Googling, I am no closer to an answer as to why or how to change it.

If I do find an answer I am going to post it here.
Reply
#7
OK, I found an answer to my problem. The PHP command:
mysql_get_client_info()

returns the version of mysqlnd which is like a PHP plugin (sort of) and not the version of MySQL running on the Macintosh. I'm currently running PHP 5.3, I don't know if this is changed in later versions.

So no matter what version of MySQL you are running, this value of "mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $" will always be returned.

In order to determine the version of MySQL you have to run this:
Code:
    <?php
$link = mysql_connect('localhost', 'user', 'pword');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
printf("MySQL server version: %s\n", mysql_get_server_info());
?>

Best just to comment out the piece of script that seeks to verify the version as mentioned above.
Reply
#8
Hi PinkFrankenstein,

Thanks for the heads up on this. I've logged this as a bug all the same; since you're not the first person to encounter this, there should probably be a way of overriding the default behaviour via the install script interface to continue the install.
http://bugs.formtools.org/index.php?cmd=view&id=203

All the best -

Ben
Reply
#9
Hi Ben ,

I have a doubt i am using WAMP server , should mysql be installed on windows
Reply
#10
Narain,

If you're using WAMP, MySQL will be installed when you installed WAMP.

Cheers,

Joe
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)