DotNetNuke Daily Tip #3 6/26/06 Clear Search Tables

Check out all of the DotNetNuke Daily Tips from Chris Hammond.

DotNetNuke Daily Tip for 6/26/2006

During your development you may run across a time when you need to clear out the search tables for DotNetNuke's searching engine. Here's the SQL to do so.

delete SearchItemWordPosition where SearchItemWordId in (select SearchItemWordId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem)) 
delete SearchWord where SearchWordsId in (select SearchWordsId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem)) 
delete SearchItemWord where SearchItemId in (select SearchItemId from SearchItem) delete SearchItem 

Thanks to Mark Gorla from Engage Software for providing this tip.

Do you have a question about DotNetNuke? Perhaps I can answer it here as a Daily DotNetNuke Tip! Email chris.hammond at dotnetnuke.com  with your question! Be sure to put Daily Tips in the subject line.

 

UPDATE:

here's objectQualifier included code

delete {objectQualifier}SearchItemWordPosition where SearchItemWordId in (select SearchItemWordId from {objectQualifier}SearchItemWord where SearchItemID in (select SearchItemId from {objectQualifier}SearchItem)) 
delete {objectQualifier}SearchWord where SearchWordsId in (select SearchWordsId from {objectQualifier}SearchItemWord where SearchItemID in (select SearchItemId from {objectQualifier}SearchItem)) 
delete {objectQualifier}SearchItemWord where SearchItemId in (select SearchItemId from {objectQualifier}SearchItem) delete {objectQualifier}SearchItem 

3 Comments

  • You are just perfect !! I was exactly searching this kind of help. Thanks to Scott (Ventrian) for helping me, it solves my problem of indexing !!

    Déclic Vidéo FX

  • Thanks, excellent tip ;)

  • i have issue with DNN search,
    DNN do index the for entries in the searchitem tables, means my module does get entry there,
    but in searchword no word is entered

    how to add words in searchword?

    i am getting this problem now, my modules are marked searchable in settings,
    entry is made in searchitem tables , but not in searchword table

    please help

Comments have been disabled for this content.