Portal Engine Questions on portal engine and web parts.
Version 6.x > Portal Engine > Error with search on v 6.0.41 View modes: 
User avatar
Member
Member
andy-procaresoftware - 8/2/2012 12:22:47 PM
   
Error with search on v 6.0.41
Greetings,

I am getting this error when I use the search box in the header of an intranet Portal"

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

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'CMS_Attachment' because it is not full-text indexed.


Is there something I need to enable?

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 8/3/2012 1:26:50 AM
   
RE:Error with search on v 6.0.41
Hi,

As you can see from the error: "because it is not full-text indexed."
Is your DB set for full text search (full text search configuration)?

Best regards,
Juraj Ondrus