I am having trouble getting the Search Index to re-update after adding a few new pages with HTML modules.
I have tried the following ideas:
Host > Search Settings, Re-index. Currently it is set to update every 30 minutes and according to the event log everything is true and updating accordingly
Host > SQL tab and tried to delete the index with the following SQL statement
truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
DELETE {databaseOwner}{objectQualifier}SearchItemWord
DELETE {databaseOwner}{objectQualifier}SearchWord
DELETE {databaseOwner}{objectQualifier}SearchItem
Then I re-index and now I don't get any search results. Thankfully I did it on the developer server so it didn't break anything.
I'm at a loss on how to update the site to read the new pages and add them to the search results.