MySQL Version not correct

[brd1984]

Having trouble getting passed Step 2 of the installation.

I have MySQL 5 installed on the server but the installation fails and says:
MySQL Version 3.23.57 FAIL

This shows I have MySQL 3.23.57 - which is wrong surely?

But then I check my phpinfo and it says 'Client API version 3.23.57 '

But I definitely have version 5 installed!

Any ideas?

Much appreciated

[Ben]

Hi brd,

Yes, this is a known bug:
http://bugs.formtools.org/index.php?cmd=view&id=203

That field shows whatever MySQL version is returned by the mysql_get_client_info() functions. On some servers, it doesn't return the correct information.

I'll try to fix this this weekend. Pop back on Sunday/Monday - I plan on releasing 2.0.1 final and I'll include a fix for this.

All the best!

- Ben

[bvdveen]

Hi brd,

Yes, this is a known bug:
http://bugs.formtools.org/index.php?cmd=view&id=203

That field shows whatever MySQL version is returned by the mysql_get_client_info() functions. On some servers, it doesn't return the correct information.

I'll try to fix this this weekend. Pop back on Sunday/Monday - I plan on releasing 2.0.1 final and I'll include a fix for this.

All the best!

- Ben

Hi Ben!

I have the same problem...
When installing the latest FT 2.01 I get the error:
install fail MySQL Version 3.23.49..I have already contacted my provider and they state that they shall not be upgrading mySQL in the near future...I am stuck here....is there a way FT works wirh an older version of my SQL?


Thanks in advance

[Ben]

Hi bvdveen,

is there a way FT works wirh an older version of my SQL?

I'm afraid not, but I can at least improve it to allow you to bypass the problem when the function returns the invalid info as described in the problem ticket. I think I have a spare hour or two today - I'll see if I can provide a workaround. Pop back tonight!

- Ben

[Ben]

Heya,

I just released a patch release - 2.0.2. Just download the latest version and try again.

Step 2 of the installation script now provides an option to "Ignore" the MySQL version. So in case the PHP function is returning a non-standard formatted version of the MySQL version you can just click it to continue.

Hope this helps!

- Ben

[arester]

I'm having a slightly different problem. After hitting submit on Step 1 I get the following error:

Fatal error: Call to undefined function mysql_get_client_info() in /var/www/vhosts/wwwstage.law/formtools/install/step2.php on line 27

Any ideas as to what that means?

thanks!

[Ben]

Hi Arester,

That message means that your PHP installation hasn't been configured with MySQL. You'll need to speak to your hosting provider about that, I'm afraid.

But this situation should be detected by the installation script as well - I'll log it as a bug.

Thanks!

- Ben

[JRS]

My assumption was that MySQL was up to spec, so did a search and found Determining your current MySQL version and used the

Code:

SHOW VARIABLES LIKE "%version%

command successfully which displayed v4.01 so clicked on the bypass FAIL button to continue.

[Ben]

Excellent! Any other problems with the installation or script, or is it all looking okay so far?

- Ben