Hi Kris,
I'm sorry I didn't include some more details, I thought you did it before. So here is how to clean up the search tables:
- Log in as host
- Navigate to Host > SQL
- Check Run as Script and Execute these scripts:
delete {databaseOwner}{objectQualifier}SearchItemWordPosition
delete {databaseOwner}{objectQualifier}SearchItemWord
delete {databaseOwner}{objectQualifier}SearchWord
delete {databaseOwner}{objectQualifier}SearchItem
And how to re-index your content:
- Log in as host
- Navigate to the Host > Search Admin
- On the very bottom of the page click on the Re-Index Content link.
I hope this was more clear, but if not, please let me know.
Best regards,
Dario Rossa