FogBugz Technical Support

A forum for technical support discussion related to Fogbugz.
The current FogBugz Knowledge Base can be found at http://help.fogcreek.com/fogbugz.

Posts by Fog Creek Employees are marked:

Documentation
Release Notes
Network Status

FB4 full-text search not working on SQL Server

We just upgraded our FB3 installation to FB4, and decided to turn on full-text search. We followed the directions in the KB, and there were no errors.

However, running a search in FB generates this message:

"Cannot use a CONTAINS or FREETEXT predicate on table 'Bug' because it is not full-text indexed."

Indeed, the FogBugzCatalog full-text catalog contains no tables. Could the upgrade have forgotten to add the full-text magic to the relevant tables?

Thanks!
David Thompson Send private email
Saturday, March 19, 2005
 
 
Well, I still don't know why the full-text indexes weren't created, but I went through all.sql and used Enterprise Manager to create 'em. Should be fine from here on out. Thanks!
David Thompson Send private email
Saturday, March 19, 2005
 
 
Ah. The 3->4 upgrade will not have done the fulltext magic if fulltext was turned off in the registry. There's a way to force it to check and update, and it sounds like we should add that to the KB -- meantime, I'm glad to hear you got it working!
Brett Kiefer Send private email
Saturday, March 19, 2005
 
 
We have the same problem.  What is the solution?
Jeremy Williams Send private email
Tuesday, March 29, 2005
 
 
More information:

The search worked for a couple of days, however today it has stopped (our 3rd day on version 4 of FogBugz).

The FTS was re-created (per the instructions on the website), which got us one step further.  The error now presented is below:

Cannot use a CONTAINS or FREETEXT predicate on table 'Bugs' because it is not full-text indexed.
No cases were found that matched.
Jeremy Williams Send private email
Tuesday, March 29, 2005
 
 
I am experiencing this same problem. I did a FB 3->4 upgrade. Went ahead and actually deleted the FogBugzCatalog Full-Text catalog. Then opened up Query Analyzer.

Following the instructions from: http://www.fogcreek.com/FogBugz/KB/dbsetup/FullTextSearch.html

SELECT DATABASEPROPERTY('fogbugz','IsFulltextEnabled')
returns 1. Good.

Then followed the 'ON FOGBUGZ VERSION 4.0 AND GREATER:' instructions:

use fogbugz
exec sp_fulltext_database 'enable'
exec sp_fulltext_catalog 'FogBugzCatalog','create'

This creates the Full-Text catalog just fine. But FogBugzCatalog contains no tables. It seems that the additional SQL statements in the Pre FB4 instructions:

exec sp_fulltext_table 'BugEvent', 'create', 'FogBugzCatalog', 'ixBugEvent'
exec sp_fulltext_column 'BugEvent','s','add'
exec sp_fulltext_table 'BugEvent', 'activate'
exec sp_fulltext_catalog 'FogBugzCatalog', 'start_full'

...create these links to the tables properly. Why are these statements left out of the FB4 Full-Text setup instructions? When I do try to run the above 4 statements, the following is returned:

Server: Msg 15607, Level 16, State 1, Procedure sp_fulltext_table, Line 114
'ixBugEvent' is not a valid index to enforce a full-text search key. You must specify a unique, non-nullable, single-column index.
Server: Msg 15606, Level 16, State 1, Procedure sp_fulltext_column, Line 78
You must first create a full-text index on table 'BugEvent'.
Server: Msg 15606, Level 16, State 1, Procedure sp_fulltext_table, Line 87
You must first create a full-text index on table 'BugEvent'.

How can I properly create a Full-Text catalog from scratch in an FB4 (or FB3 upgraded to FB4) MS SQL database?
Brian Kelly Send private email
Wednesday, March 30, 2005
 
 
We didn't do anything to our database, however the search is working again today.  What's the scoop on this?
Jeremy Williams Send private email
Wednesday, March 30, 2005
 
 

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.