Back

DotNetNuke Search Results Not Updating

DotNetNuke should regularly update and re-index its search database. To check when it was last done, log on using the host account, then click on Host> Schedule - on this page should be an indication of when it was last run.

If you are having problems however, you can delete the index and restart it by following the instructions below.

1. Login as Superuser ("host" by default)
2. On the Host Menu click on the SQL option .
3. Copy the following 4 lines and paste them into the text box:
   
   delete {databaseOwner}{objectQualifier}SearchItemWordPosition
   delete {databaseOwner}{objectQualifier}SearchItemWord
   delete {databaseOwner}{objectQualifier}SearchWord
   delete {databaseOwner}{objectQualifier}SearchItem
   
   
4. Activate the check box and click on Execute. The search index will be deleted.
5. Now click on Host and then Search Admin and start the facility re-indexing again.

Back

Make a Comment on this Article