Knowledgebase
20DNS 40Domains 59DotNetNuke 17Downloads 84eMail 14File Transfer Protocol 123Flash Tutorials 23General 11IIS 4Migrations 30MSSQL Server 9MySQL Server 111Parallels Plesk Panel 6Security and Hack 10SEO 23Server Settings 8SSL Certificates 1Video Tutorials 11Your Account
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))
Helpful
Not helpful
Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).