Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Error - Indexing Scheme from NonIndexed to MSSQL

Quote Reply
Error - Indexing Scheme from NonIndexed to MSSQL
I'm on a MSSQL server and I get the following error when trying to change the Indexing Scheme from NonIndexed to MSSQL

GT::SQL::Search::MSSQL::Indexer (11816): Problem Creating Full Text Index: Failed to execute query: ' sp_fulltext_catalog 'links_Category_ctlg', 'create' ' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]A full-text catalog named 'links_Category_ctlg' already exists in this database. (SQL-37000)(DBD: st_execute/SQLExecute err=-1) at /GT/SQL/Editor.pm line 622.

Line 622 Editor.pm is as follows

# load the driver
my $indexer = GT::SQL::Search->load_indexer ( table => $self->{table}, _debug => $self->{_debug}, driver => $newdriver ) or return;$indexer->add_search_driver or return;

I don't have shell acess and cannot use the Internal search due to CGI time out errors.

Any suggestions.

Regards

minesite