prefix_vb4_foruminstallanswered_title_rich Upgrading error? "Contact Vbulletin support"

[GavoTrav]

I get this while upgrading from 3.8.7 to 4.1.8

 Upgrade progress:

[LIST][*][B]Upgrading to 4.0.0 Beta 5[/B] [*]Step 1 - Altering search_text Table (1 of 1) [*]An error has occurred with your database. Please contact vBulletin Support for assistance.
Module: 400b5, Step 1 Database Error:1283
Column 'keywordtext' cannot be part of FULLTEXT index
Query:

ALTER TABLE searchcore_text MODIFY title VARCHAR(254) [/LIST]

An error has occurred with your database. Please contact vBulletin Support for assistance.

Module: 400b5, Step 1 Database Error:1283
Column 'keywordtext' cannot be part of FULLTEXT index
Query:

ALTER TABLE searchcore_text MODIFY title VARCHAR(254) NOT NULL DEFAULT ''

Fix:

Had to drop tables and use SQL Query to create them with a diffrent collation to make it work!

[Wayne Luke]

Actually, recreating the table most likely created it in the required MyISAM format. Collation wouldn't affect this error, just the order of any queries returned.