Limesurvey创建验证码tokens出错
迁移了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.'
问题解决。
抱歉,暂停评论。