Forums
Subject: Error during installation of Search Module
Prev Next
You are not authorized to post a reply.

Author Messages
Mark McIntyreUser is Offline

Posts:8

Send A Message
05/06/2008 7:51 PM  

I wasn't able to capture the error during installation, but viewing the logs, I get this.

ModuleId: 804
ModuleDefId: 108
FriendlyName: VenexusSearch
ModuleControlSource: DesktopModules/VenexusSearch/ViewVenexusSearch.ascx
AssemblyVersion: 04.08.00
PortalID: 0
PortalName: NDGraphics
UserID: 3
UserName: host
ActiveTabID: 37
ActiveTabName: Search Results
RawURL: /SearchResults/tabid/37/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://dnn2.ndgraphics.com/SearchResults/tabid/37/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2; .NET CLR 1.1.4322; MS-RTC LM 8)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: dc8d8596-1424-4ceb-a9c9-54ba754fc0b4
InnerException: Cannot use a CONTAINS or FREETEXT predicate on table 'Venexus_BrainDump' because it is not full-text indexed.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: EntitySpaces.Core.esEntityCollection.ExecuteNonQuery
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot use a CONTAINS or FREETEXT predicate on table 'Venexus_BrainDump' because it is not full-text indexed. ---> System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table 'Venexus_BrainDump' because it is not full-text indexed. at EntitySpaces.Core.esEntityCollection.ExecuteNonQuery(esQueryType queryType, String query, esParameters parms) at EntitySpaces.Core.esUtility.ExecuteNonQuery(esQueryType queryType, String query) at Venexus.Modules.VenexusSearch.ViewVenexusSearch.RecreateFullTextStoredProcedures() --- End of inner exception stack trace ---
Source:
Server Name: IIS01

Jeff SmithUser is Offline

Posts:210

Send A Message
05/06/2008 11:27 PM  

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

This means you do not have full text indexing enabled. Did you get the stored procedures created correctly using the instructions provided here?:http://www.venexus.com/Support/ProductForums/tabid/132/forumid/3/tpage/1/view/topic/postid/160/Default.aspx#160

 What version of SQL Server are you using?

Alos, if you have an error message, please post it in http://support.venexus.com instead of the forums.

Mark McIntyreUser is Offline

Posts:8

Send A Message
05/08/2008 10:57 AM  

Ok,
So I completely uninstalled Seamus and Search modules ... deleted the DesktopModule folders and deleted any database references (tables, etc)[except, I could NOT remove the VenexusSearchCatalog].  I then re-installed the Search module with no issues, the re-installed teh Seamus module and got the following error ...

StartJob Begin Sql execution
Info Executing 01.00.00.SqlDataProvider
StartJob Start Sql execution: 01.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 4: Incorrect syntax near 'fulltext'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) If (left(@@VERSION, 26)) = 'Microsoft SQL Server 2005 ' BEGIN Create fulltext index On dbo.[Venexus_BrainDump] (IndexURL, IndexTitle, IndexWashedContent) Key Index PKVenexusSearchEngine On VenexusSearchCatalog With Change_Tracking Auto END System.Data.SqlClient.SqlException: You must first create a full-text index on table 'dbo.[Venexus_BrainDump]'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) If (left(@@VERSION, 26)) = 'Microsoft SQL Server 2000' BEGIN EXEC sp_fulltext_column 'dbo.[Venexus_BrainDump]', 'IndexWashedContent', 'add' END System.Data.SqlClient.SqlException: You must first create a full-text index on table 'dbo.[Venexus_BrainDump]'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) If (left(@@VERSION, 26)) = 'Microsoft SQL Server 2000' BEGIN EXEC sp_fulltext_table 'dbo.[Venexus_BrainDump]', 'activate' END System.Data.SqlClient.SqlException: You must first create a full-text index on table 'dbo.[Venexus_BrainDump]'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) If (left(@@VERSION, 26)) = 'Microsoft SQL Server 2000' BEGIN EXEC sp_fulltext_table 'dbo.[Venexus_BrainDump]', 'start_full' END
EndJob End Sql execution: 01.00.00.SqlDataProvider file

I'm assuming this error screws up the whoel thing ... so I will NOT continue until I head back from you on this.  I need to resolve this today.  Look forward to your response.

Mark McIntyreUser is Offline

Posts:8

Send A Message
05/08/2008 11:52 AM  

I was able to to delete the Catalog and repeated the steps above and got the same error.

Jeff SmithUser is Offline

Posts:210

Send A Message
05/08/2008 11:59 AM  
Please answer my question about what version of SQL Server you are using.
Jeff SmithUser is Offline

Posts:210

Send A Message
05/08/2008 12:09 PM  

There should never be a reason to uninstall and reinstall. It would help us greatly if you provided the information we asked for and actually tried to execute what we suggest. The issue is concerning the full text indexing and whether it is setup on your server or not. Were you about to do what I asked and run the stored procs as described here (http://www.venexus.com/Support/ProductForums/tabid/132/forumid/3/tpage/1/view/topic/postid/160/Default.aspx#160)? Did you get error message?

If this is not successful, please do the following from SQL Server Management Studio (SQL2005) or Query Analyzer (SQL2000):

Run each statement individually and post each message here in this thread:
1. sp_fulltext_database 'enable'
2. EXEC sp_fulltext_catalog 'VenexusSearchCatalog', 'drop'
3. EXEC sp_fulltext_catalog 'VenexusSearchCatalog', 'create'
4. Create Unique Index PKVenexusSearchEngine On [Venexus_BrainDump](IndexID)

If you are running SQL Server 2005:
5. Create fulltext index On [Venexus_BrainDump] (IndexURL, IndexTitle, IndexWashedContent) Key Index PKVenexusSearchEngine On VenexusSearchCatalog With Change_Tracking Auto

If you are running SQL Server 2000:
5. EXEC sp_fulltext_column '[Venexus_BrainDump]', 'IndexWashedContent', 'add'
6. EXEC sp_fulltext_table '[Venexus_BrainDump]', 'activate'
7. EXEC sp_fulltext_table '[Venexus_BrainDump]', 'start_full'

Mark McIntyreUser is Offline

Posts:8

Send A Message
05/08/2008 12:16 PM  

Ok,

I ran the FullTextStoredProcedures.sql the Host/SQL as you requested (I did this already by the way) and got this error.

System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.Venexus_BrainDump' because it is not full-text indexed. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /******************************/ /** Create Stored Procedures **/ /******************************/ CREATE PROCEDURE dbo.[Venexus_FullTextQuery_Simple] @RawQuery nvarchar(4000), @Query nvarchar(4000), @TotalRecords int output AS SET @TotalRecords = 0 DECLARE @Results TABLE ([Key] int, Rank int) INSERT INTO @Results([Key], Rank) SELECT [Key], [Rank] FROM CONTAINSTABLE(dbo.[Venexus_BrainDump], *, @Query) DECLARE @SearchID int DECLARE @SearchHits int Set @SearchID = (Select SearchID From dbo.[Venexus_Searches] Where SearchQuery = @RawQuery); Set @SearchHits = (Select SearchHit From dbo.[Venexus_Searches] Where SearchID = @SearchID); If @SearchID IS NOT NULL BEGIN Update dbo.[Venexus_Searches] Set SearchLastDate = GETDATE(), SearchHit = @SearchHits + 1 Where SearchID = @SearchID; END Else Begin Insert Into dbo.[Venexus_Searches] (SearchQuery, SearchHit, SearchDate) VALUES (@RawQuery, 1, GETDATE()); End SELECT TOP 500 dbo.[Venexus_BrainDump].IndexID, dbo.[Venexus_BrainDump].IndexURL, dbo.[Venexus_BrainDump].IndexDate, dbo.[Venexus_BrainDump].Indextitle, convert(nvarchar(255),dbo.[Venexus_BrainDump].IndexWashedContent) As IndexWashedContent, dbo.[Venexus_BrainDump].ModuleID As ModuleID, dbo.[Venexus_BrainDump].TabID As TabID, dbo.[Venexus_BrainDump].FileID As FileID, dbo.[Venexus_BrainDump].IndexSummary, dbo.[Venexus_BrainDump].CategoryID FROM dbo.[Venexus_BrainDump] INNER JOIN @Results R ON dbo.[Venexus_BrainDump].IndexID = R.[Key] Where dbo.[Venexus_BrainDump].IsApproved = 1 AND dbo.[Venexus_BrainDump].IsDeleted = 0 ORDER BY R.Rank DESC System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.Venexus_BrainDump' because it is not full-text indexed. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[Venexus_FullTextQuery_Mixed] @RawQuery nvarchar(2000), @Query1 nvarchar(4000), @Query2 nvarchar(4000), @TotalRecords int output AS SET @TotalRecords = 0 DECLARE @Results TABLE ([Key] int, Rank int) INSERT INTO @Results([Key], Rank) SELECT [Key], [Rank] FROM CONTAINSTABLE(dbo.[Venexus_BrainDump], *, @Query1) UPDATE R SET R.Rank = R.Rank + 1 FROM @Results R INNER JOIN ( SELECT [Key], [Rank] FROM CONTAINSTABLE(dbo.[Venexus_BrainDump], *, @Query2)) R2 ON R.[Key] = R2.[Key] DECLARE @SearchID int DECLARE @SearchHits int Set @SearchID = (Select SearchID From dbo.[Venexus_Searches] Where SearchQuery = @RawQuery); Set @SearchHits = (Select SearchHit From dbo.[Venexus_Searches] Where SearchID = @SearchID); If @SearchID IS NOT NULL BEGIN Update dbo.[Venexus_Searches] Set SearchLastDate = GETDATE(), SearchHit = @SearchHits + 1 Where SearchID = @SearchID; END Else Begin Insert Into dbo.[Venexus_Searches] (SearchQuery, SearchHit, SearchDate) VALUES (@RawQuery, 1, GETDATE()); End SELECT TOP 500 dbo.[Venexus_BrainDump].IndexID, dbo.[Venexus_BrainDump].IndexURL, dbo.[Venexus_BrainDump].IndexDate, dbo.[Venexus_BrainDump].Indextitle, convert(nvarchar(255),dbo.[Venexus_BrainDump].IndexWashedContent) As IndexWashedContent, dbo.[Venexus_BrainDump].ModuleID As ModuleID, dbo.[Venexus_BrainDump].TabID As TabID, dbo.[Venexus_BrainDump].FileID As FileID, dbo.[Venexus_BrainDump].IndexSummary, dbo.[Venexus_BrainDump].CategoryID FROM dbo.[Venexus_BrainDump] INNER JOIN @Results R ON dbo.[Venexus_BrainDump].IndexID = R.[Key] Where dbo.[Venexus_BrainDump].IsApproved = 1 AND dbo.[Venexus_BrainDump].IsDeleted = 0 ORDER BY R.Rank DESC System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.Venexus_BrainDump' because it is not full-text indexed. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[Venexus_FullTextQuery_MixedByPortalID] @RawQuery nvarchar(4000), @Query nvarchar(4000), @Query2 nvarchar(4000), @PortalID int, @TotalRecords int output AS SET @TotalRecords = 0 DECLARE @Results TABLE ([Key] int, Rank int) INSERT INTO @Results([Key], Rank) SELECT [Key], [Rank] FROM CONTAINSTABLE(dbo.[Venexus_BrainDump], *, @Query) UPDATE R SET R.Rank = R.Rank + 1 FROM @Results R INNER JOIN ( SELECT [Key], [Rank] FROM CONTAINSTABLE(dbo.[Venexus_BrainDump], *, @Query2)) R2 ON R.[Key] = R2.[Key] DECLARE @SearchID int DECLARE @SearchHits int Set @SearchID = (Select SearchID From dbo.[Venexus_Searches] Where SearchQuery = @RawQuery); Set @SearchHits = (Select SearchHit From dbo.[Venexus_Searches] Where SearchID = @SearchID); If @SearchID IS NOT NULL BEGIN Update dbo.[Venexus_Searches] Set SearchLastDate = GETDATE(), SearchHit = @SearchHits + 1 Where SearchID = @SearchID; END Else Begin Insert Into dbo.[Venexus_Searches] (SearchQuery, SearchHit, SearchDate) VALUES (@RawQuery, 1, GETDATE()); End SELECT TOP 500 dbo.[Venexus_BrainDump].IndexID, dbo.[Venexus_BrainDump].IndexURL, dbo.[Venexus_BrainDump].IndexDate, dbo.[Venexus_BrainDump].Indextitle, convert(nvarchar(255),dbo.[Venexus_BrainDump].IndexWashedContent) As IndexWashedContent, dbo.[Venexus_BrainDump].ModuleID As ModuleID, dbo.[Venexus_BrainDump].TabID As TabID, dbo.[Venexus_BrainDump].FileID As FileID, dbo.[Venexus_BrainDump].IndexSummary, dbo.[Venexus_BrainDump].CategoryID FROM dbo.[Venexus_BrainDump] INNER JOIN @Results R ON dbo.[Venexus_BrainDump].IndexID = R.[Key] WHERE dbo.[Venexus_BrainDump].PortalID = @PortalID AND dbo.[Venexus_BrainDump].IsApproved = 1 AND dbo.[Venexus_BrainDump].IsDeleted = 0 ORDER BY R.Rank DESC System.Data.SqlClient.SqlException: Line 44: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[Venexus_FullTextQuery_SimpleByPortalID] @RawQuery nvarchar(4000), @Query nvarchar(4000), @PortalID int, @TotalRecords int output AS SET @TotalRecords = 0 DECLARE @Results TABLE ([Key] int, Rank int) INSERT INTO @Results([Key], Rank) SELECT [Key], [Rank] FROM CONTAINSTABLE(dbo.[Venexus_BrainDump], *, @Query) DECLARE @SearchID int DECLARE @SearchHits int Set @SearchID = (Select SearchID From dbo.[Venexus_Searches] Where SearchQuery = @RawQuery); Set @SearchHits = (Select SearchHit From dbo.[Venexus_Searches] Where SearchID = @SearchID); If @SearchID IS NOT NULL BEGIN Update dbo.[Venexus_Searches] Set SearchLastDate = GETDATE(), SearchHit = @SearchHits + 1 Where SearchID = @SearchID; END Else Begin Insert Into dbo.[Venexus_Searches] (SearchQuery, SearchHit, SearchDate) VALUES (@RawQuery, 1, GETDATE()); End SELECT TOP 500 dbo.[Venexus_BrainDump].IndexID, dbo.[Venexus_BrainDump].IndexURL, dbo.[Venexus_BrainDump].IndexDate, dbo.[Venexus_BrainDump].Indextitle, convert(nvarchar(255),dbo.[Venexus_BrainDump].IndexWashedContent) As IndexWashedContent, dbo.[Venexus_BrainDump].ModuleID As ModuleID, dbo.[Venexus_BrainDump].TabID As TabID, dbo.[Venexus_BrainDump].FileID As FileID, dbo.[Venexus_BrainDump].IndexSummary, dbo.[Venexus_BrainDump].CategoryID FROM dbo.[Venexus_BrainDump] INNER JOIN @Results R ON dbo.[Venexus_BrainDump].IndexID = R.[Key] WHERE dbo.[Venexus_BrainDump].PortalID = @PortalID AND dbo.[Venexus_BrainDump].IsApproved = 1 AND dbo.[Venexus_BrainDump].IsDeleted = 0 ORDER BY R.Rank DESC GO

The ISP says the FULL TEXT has been enabled.  I cannot confirm or deny that fact.  I did, however, click on the 'Ensure Full Text is enabled' button that you provided in the modules settings and it said yes (or something to that affect).

I will not proceed with the procedure you gave me.

Mark McIntyreUser is Offline

Posts:8

Send A Message
05/08/2008 12:33 PM  

Step 1: sp_fulltext_database 'enable'

(1 row(s) affected)
(0 row(s) affected)
(1 row(s) affected)

Step 2: EXEC sp_fulltext_catalog 'VenexusSearchCatalog', 'drop'

Command(s) completed successfully.

Step 3: EXEC sp_fulltext_catalog 'VenexusSearchCatalog', 'create'

Command(s) completed successfully.

Step 4: Create Unique Index PKVenexusSearchEngine On [Venexus_BrainDump](IndexID)

There is already an index on table 'Venexus_BrainDump' named 'PKVenexusSearchEngine'

It is running on SQL Server 2000:
Step 5. EXEC sp_fulltext_column '[Venexus_BrainDump]', 'IndexWashedContent', 'add'

You must first create a full-text index on table '[Venexus_BrainDump]'.

Step 6. EXEC sp_fulltext_table '[Venexus_BrainDump]', 'activate'

You must first create a full-text index on table '[Venexus_BrainDump]'.

Step 7. EXEC sp_fulltext_table '[Venexus_BrainDump]', 'start_full'

You must first create a full-text index on table '[Venexus_BrainDump]'.

Mark McIntyreUser is Offline

Posts:8

Send A Message
05/08/2008 12:35 PM  

BTW, I meant "I will now proceed with the procedure you gave me."  NOT  "I will not proceed with the procedure you gave me." as it read before.

Jeff SmithUser is Offline

Posts:210

Send A Message
05/08/2008 2:41 PM  

Please manually create the fulltext index using the video found here:

http://www.venexus.com/portals/0/tutorials/fulltext-index-sql2000.wmv

When complete, run the sql file found in VeneuxsSearch through Host > SQL again.

You are not authorized to post a reply.
Forums > Modules > Venexus Search > Error during installation of Search Module



 Print   

Top Posts
VenexusBookmarks 4.1.2 Released by tmunn
A new version of  Venexus Bookmarks module is now available for downlo...
VenexusBookmarks 4.1.2 Released by tmunn
A new version of  Venexus Bookmarks module is now available for downlo...
VenexusSeamus 4.1.5 Released by tmunn
A new version of VenexusSeamus, the search engine aggregation module utiliz...
VenexusSeamus 4.1.5 Released by tmunn
A new version of VenexusSeamus, the search engine aggregation module utiliz...
Venexus WebControls 4.1.7 Released by tmunn
A new version of  Venexus WebControls was released today.  This r...
  

 © 2007 - Venexus, Inc. - All rights reserved Terms Of Use | Privacy Statement