迁移了Limesurvey到一台新机器上,Ubuntu 12.04,apt方式安装的Apache、MySQL等,在使用问卷的创建验证码&tokens时出现以下错误:

Error: 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 17

Google了一下,得到这个帖子http://bugs.limesurvey.org/print_bug_page.php?bug_id=4729,其中一个人回复到

I am running v.5.5.6 MySQL. I apologize for the mixup. But 'Type' has been obsolete for a while now, and this query works with using 'engine' instead of 'type'. Is there anywhere that I can change the script for this query?

原来是MySQL版本问题,5.5以后用engine代替了type。顺着出问题的页面,一路找到/admin/tokens.php文件,将:

 'type='.$databasetabletype.'

中的type改成engine,即:

'engine='.$databasetabletype.'

问题解决。