Error message upgrading from 3.0 to 4.0: 'BugEventPrimaryKey' is not a valid index to enforce a full-text search key.
FogBugz Version: 4.0.11
Problem: Attempting to upgrade a FogBugz database from 3.x to 4.x results in the following error message:
'BugEventPrimaryKey' is not a valid index to enforce a full-text search key.
You must specify a unique, non-nullable, single-column index. SQL: exec sp_fulltext_table ?,
'create', 'FogBUGZCatalog', ? Params: SS 1: BugEvent 2: BugEventPrimaryKey
To Correct This Problem:
- Start SQL Enterprise Manager and navigate to your FogBugz database
- Click on Tables
- Find the "BugEvent" table and right-click on it. Choose Design Table
- Find the row with ixBugEvent in it and right-click on it. Choose Indexes/Keys
- Click New
- Replace the Index Name with the text BugEventPrimaryKey
- Change the column name from sFileName to ixBugEvent
- Check Create UNIQUE
- Check Index
It will look like this:
- Hit Close
- Click on the SAVE icon (floppy disk) in the top-left corner of SQL Enterprise Manager to save your changes
- Close the BugEvent table
- Go to your FogBugz URL and log on as an administrator. You will be prompted to upgrade the database, and this time it should work fine.
