DotNetNuke Developer Chris Hammond

DotNetNuke Core Team Member

News

Thanks for visiting my blog, you can find more about me at ChrisHammond.com or on my company's website at Engage Software.

Cool Sites

My domains

Projects

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.

Posted: Jun 26 2006, 10:47 AM by Chris Hammond | with 3 comment(s)
Filed under: , , , , ,

Comments

Déclic Vidéo FX said:

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

# May 25, 2007 3:00 AM

Id said:

Thanks, excellent tip ;)

# February 24, 2008 2:49 PM

Chris Hammond said:

With the 3.0 release of DotNetNuke, way back in March of 2005 searching was implemented in the project, after a hiatus in the 2.* releases. Since then, not much has changed with the search, t ...

# March 25, 2008 4:20 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)