Upgrading error? "Contact Vbulletin support"

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • GavoTrav
    New Member
    • Apr 2011
    • 9
    • 4.1.x

    prefix_vb4_foruminstallanswered_title_rich Upgrading error? "Contact Vbulletin support"

    I get this while upgrading from 3.8.7 to 4.1.8

    Click image for larger version

Name:	vberror.png
Views:	1
Size:	13.6 KB
ID:	3722247

    Code:
     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]
    Code:
    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!
    Last edited by GavoTrav; Fri 25 Nov '11, 2:19am.
    Visit our site: Pvhax
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    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.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    Related Topics

    Collapse

    Working...