Topic on Project:Support desk

I just instill whole new kloxo on lindoe VPS, Then I got this：

正在启用扩展...完成
正在配置数据库...完成
正在创建数据表...发生了数据库查询语法错误，可能是由于软件自身的错误所引起。最后一次数据库查询指令是：
CREATE FULLTEXT INDEX si_title ON `searchindex` (si_title)
来自函数“DatabaseBase::sourceFile( /home/admin/wiki/maintenance/tables.sql )”内。数据库返回错误“1283: Column 'si_title' cannot be part of FULLTEXT index (localhost)”。
Backtrace:
#0 /home/admin/wiki/includes/db/Database.php(827): DatabaseBase->reportQueryError('Column 'si_titl...', 1283, 'CREATE FULLTEXT...', 'DatabaseBase::s...', false)
#1 /home/admin/wiki/includes/db/Database.php(3026): DatabaseBase->query('CREATE FULLTEXT...', 'DatabaseBase::s...')
#2 /home/admin/wiki/includes/db/Database.php(2924): DatabaseBase->sourceStream(Resource id #80, false, false, 'DatabaseBase::s...')
#3 /home/admin/wiki/includes/installer/DatabaseInstaller.php(160): DatabaseBase->sourceFile('/home/admin/wik...')
#4 [internal function]: DatabaseInstaller->createTables(Object(MysqlInstaller))
#5 /home/admin/wiki/includes/installer/Installer.php(1331): call_user_func(Array, Object(MysqlInstaller))
#6 /home/admin/wiki/includes/installer/WebInstallerPage.php(1127): Installer->performInstallation(Array, Array)
#7 /home/admin/wiki/includes/installer/WebInstaller.php(254): WebInstaller_Install->execute()
#8 /home/admin/wiki/mw-config/index.php(50): WebInstaller->execute(Array)
#9 /home/admin/wiki/mw-config/index.php(18): wfInstallerMain()
#10 {main}

How to solve this problem?

mysql-5.0.95-1.el5_7.1
perl-DBD-MySQL-3.0007-2.el5
mysql-server-5.0.95-1.el5_7.1
php-mysql-5.2.17-13

This error can have multiple reasons. The most common one is I would say, that the database table searchindex uses the table engine InnoDB. Fullsearch indexes however are not supported by InnoDB. Make sure that this DB table uses the table engine MyISAM instead.

Thank you!

I had the same problem installing MediaWiki 1.19.2. with the binary option. A simple SQL change appears to have fixed it. Collate should be specified for table 'searchindex' or columns like 'si_title' will use VARBINARY even when it should be VARCHAR. Posting the change here for reference. I am using MySQL 5.1.63.

File: maintenance/tables.sql

Change line #1120 from:

    ) ENGINE=MyISAM; 

to:

   ) ENGINE=MyISAM COLLATE='utf8_general_ci';