wiki search broken (missing FULLTEXT indexes)

[dansan]

Reproduce by searching something through the search form at the bottom of the wiki.

Code: Select all

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "SearchMySQL::searchInternal". Database returned error "1214: The used table type doesn't support FULLTEXT indexes (localhost)".

[knorke]

right now it works. things randomly stop working atm due to the working on server..

[abma]

right now it works. things randomly stop working atm due to the working on server..

google search vs wiki search http://springrts.com/wiki/Special:Search

should work again, tables were converted to innodb to allow database dumps without blocking, but the table wiki_searchindex has to be myisam as innodb doesn't support FULLTEXT search...