Knowledgebase: DotNetNuke
How do I clear and rebuild Search Index in DotNetNuke
Posted by on 23 February 2013 05:09 PM

To clear/delete the search index tables manually. Follow the steps below:

  • Login as 'HOST' (Super user account)
  • In Host Menu select "SQL"
  • Copy the following 4 lines and paste them into the 'Script' text box:
    truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
    DELETE {databaseOwner}{objectQualifier}SearchItemWord
    DELETE {databaseOwner}{objectQualifier}SearchWord
    DELETE {databaseOwner}{objectQualifier}SearchItem
  • Check 'run as script'
  • Click executive
  • The search index will be rebuilt by the scheduler.
(2 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).