FogBugz Technical Support

A forum for technical support discussion related to Fogbugz.
The current FogBugz Knowledge Base can be found at

Posts by Fog Creek Employees are marked:

Release Notes
Network Status

Trouble upgrading from 5.0 to 6.0

We use SQL 2000 Enterprise Edition (Service Pack 4). The upgrade failed with the error below:

FogBugz is being upgraded.
FogBugz encountered an error upgrading your FogBugz database and rolled back all changes. The error is:

200: Execution of a full-text operation failed. The Gatherer project has not been initialized. The catalog needs to be remounted. If the project is still not initialized, remove it. SQL: exec sp_fulltext_table ?, 'drop' Params: S 1: BugEvent

Please correct the error and try the upgrade again.  OK

When we tried running the SQL command, it returned: [Microsoft][ODBC SQL Server Driver]Field COUNT incorrect or sintax error.


From the middle of the Rain Forest
Joel Cruz Send private email
Wednesday, September 19, 2007
Two things to try:

1. Look at this and see if you can manually get it working:

2. Someone passed this along in an earlier post that may be relevant

"My DBA solved the problem. I ran it after she did what she said and it upgraded without a hitch. Here's her message in case someone else might be helped by this:

I checked and yes full text search is enabled.

I just created a full text index via the wizard and it worked fine but when I tried to manually create a full text index on that table it raised the same error.

For some reason the primary key was not registering in sysindexes with appropriate properties. So I dropped the primary key that I put on the table and recreated it. I ran the stored procedure sp_fulltext_table and it created the full text capability on the table.

Try running the upgrade again and see what happens."
Michael H. Pryor Send private email
Wednesday, September 19, 2007

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
Powered by FogBugz Bug Tracking and Evidence-Based Scheduling.