How to Clear Search Index Of DotNetNuke

Ismet

Sometimes you may need to clear Search Index of DotNetNuke, when Search functionality of your website is broken and Search Results module throws errors.

Following SQL code is useful for the scenario above.

truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition

DELETE {databaseOwner}{objectQualifier}SearchItemWord

DELETE {databaseOwner}{objectQualifier}SearchWord

DELETE {databaseOwner}{objectQualifier}SearchItem

rebuild search index of your dotnetnuke portal

Just type the code under Host > SQL with Super user privileges and check Run as Script checkbox, then hit the Execute button.

I also published this tip under my personal Turkish blog for those Turkish Community users. Following is the link to article.
DotNetNuke Arama Indeksini Yeniden Oluşturmak İçin Yapmanız Gerekenler

Posted in: Tips
Tags: DotNetNuke Tips

Actions: E-mail | Permalink | Comments (1)

| Kick it! | DZone it! | del.icio.us

You can also use MNNDISCOUNT25 coupon code to have %25 discount on all hosting packages from HostGator!

How to Clear Search Index Of DotNetNuke

Post Rating

Comments

Post Comment