May
9
Written by:
Steve Patterson
5/9/2009 1:44 PM
Removing Groups of Posts from the DNN Blog Module
If you happen to run DotNetNuke with the Blog Module as one of your major modules for content, you may find the need to remove a group of posts from the module at some time. For instance, you were active in Paid-to-Post at one time, have received your money from the posts, have fulfilled your obligation with the organization that hired you, but are still being penalized by Google for having the posts on your site. Well, there are only two tables in DNN that you need to query and delete records from to remove these posts permanently.
The first table is the Blog_Entries table and the second is the Blog_Comments table.
Select Top 150 * From blog_Entries
Where BlogID = 25
Order By AddedDate
The SQL Server code above will display 150 entries from the blog module you determine to be the module on your site. If you only have one site and one blog module than all the entries will have the same BlogId. Look through the records from the script above and record the EntryIDs for all entries you want to remove from your site.
Delete From blog_comments
Where EntryID In (1,2,5,...)
Now delete the comments associated with the entries you wish to delete by running the SQL code above. SQL can be run within a DNN portal through a screen available under the Host menu.
DELETE From blog_Entries
Where BlogID = 25
And EntryID In (1,2,5,...)
The final step is to delete the entries themselves as you can see above. I pinged my site (one other than CapturedTech.com) after performing these operations in hopes that Google would recognize the changes and adjust my Page Rank accordingly.