Knowledgebase
(28)Applications (16)DNS (23)Domains (9)Downloads (61)eMail (5)File Transfer Protocol (144)Flash Tutorials (18)General (11)IIS (4)Migrations (30)MSSQL Server (10)MySQL Server (74)Plesk Panel (2)Security and Hack (9)SEO (3)Server Settings (10)Services (3)SSL Certificates (9)Your Account
SEARCH
Knowledgebase
How do I clear and rebuild Search Index in DotNetNuke
Posted by on 18 August 2012 02:31 AM

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).