When performing a search within Plato you may see the error message...

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view '{tablePrefix}_{tableName}' because it is not full-text indexed.

Cause

This error can occur if you've enabled new modules within Plato or enabled the Plato.Search module but you've not rebuilt the Plato.Search indexes.

Solution

You can follow the steps below to resolve this problem...

  1. Navigate to the Plato Dashboard
  2. Expand Settings on the left. Click Search
  3. From the Search page click the Rebuild button alongside your search catalog as shown below...

search-indexes.png

That's It!

Try your search again and it should work as expected. Please remember if you install new modules in the future you may need to occasionally rebuild the search indexes using the steps described above.