Hi all !

I just discovered this tool and i wanted to try it out on my webhost.

The web space is hosted at OVH.
PHP Version 4.4.8
Mysql Client API version 5.0.32

I tried to install the stable release (1.53+ stable) and the unstable (1.70 RC2) but in both cases I had the following error:

Error: You need at least MySQL version 4.1 to run LimeSurvey

So I commented out the corresponding lines in common.php

When I tried to install it i got a lot of error messages like:

Executing.....CREATE TABLE `lime_answers` ( `qid` int(11) NOT NULL default '0', `code` varchar(5) NOT NULL default '', `answer` text NOT NULL, `default_value` char(1) NOT NULL default 'N', `sortorder` int(11) NOT NULL, `language` varchar(20) default 'en', PRIMARY KEY (`qid`,`code`,`language`)) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci...Failed! Reason: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 1

I looked up on the forum but I couldn't find any explanation.

Can anyone help me out?

It seems that your MySQL version doesn't fit the requirements.

I think the older MySQL versions don't support UTF8 properly. So please check your database.

Hello Everyone,

Solved ??

I have the same problem and for sure mysql v6 databases does set the requirements. At least for many other php scripts and apps. Proof of that I run many other php/mysql instances (moodle, Myphp forum, etc) and it work !

Yes there is something wrong but not necessarly with our database or client UTFs requirements. (All my other databases uses UTF_unicode_ci)

However, my error message is a little bit different, as it :

Failed! Reason: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 1

I changed my limesurvey database TYPE for InnoDB but same problème as it :

Failed! Reason: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 1

For sure I'm not considering myself as a DB expert, but I have some knowledge in it.

Anybody help !!!!

Thks.

shinzonqc wrote:
I have the same problem and for sure mysql v6 databases does set the requirements.Limesurvey does not support MySQL 6.0 yet.

I have MySQL 5.0.26 installed.

Had the same problem with "need at Mysql version 4.1..."

I also commented out the version check lines and finally ended up receiving this message:

Failed! Reason: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 1

Edit: sorry. problem was caused by host problems