kentico 5.0 Full-text search error

Naveen Khanna asked on June 17, 2014 05:42

I am getting an error when a user is trying to search on a site which used full-text search.

It was done a while ago in 5.0 and heard from client recently that it is not working. I did check the DB for full-text search component and it is installed. I checked the setting in ADMINISTRATION section of cmsdesk and all is in place but still while searching on site it gives following error

[DataConnection.ExecuteQuery]: Query: SELECT SUM(RANK) AS [Score], DocumentID, SiteName, NodeID, NodeAliasPath, DocumentCulture, NodeClassID, ClassName, NodeACLID, NodeSiteID, NodeLinkedNodeID FROM CMS_Attachment INNER JOIN CONTAINSTABLE(CMS_Attachment, AttachmentBinary, '(test)' ) AS KEY_TBL ON CMS_Attachment.AttachmentID = KEY_TBL.[KEY] INNER JOIN View_CMS_Tree_Joined ON View_CMS_Tree_Joined.DocumentID = CMS_Attachment.AttachmentDocumentID WHERE (Published = 1) AND ((DocumentCulture = N'en-US') AND (NodeSiteID IN (1)) ) GROUP BY DocumentID, SiteName, NodeID, NodeAliasPath, DocumentCulture, NodeClassID, ClassName, NodeACLID, NodeSiteID, NodeLinkedNodeID ORDER BY Score DESC: caused exception: Full-Text Search is not installed, or a full-text component cannot be loaded.

Can someone please help?

Thanks in advance

Regards

full-text search

Recent Answers

Filip Ligač answered on June 18, 2014 07:08 (last edited on June 18, 2014 07:10)

Hello Naveen,

The easiest way to check if Full-Text Search is installed on your SQL Server is to run the following query: SELECT SERVERPROPERTY('IsFullTextInstalled')

Does it return 1 which would mean Full-Text Search is installed?

If not, you might need to go over the steps for enabling it again as it is described in MS documentation - Get Started with Full-Text Search.

0 votesVote for this answer Mark as a Correct answer