The following SQL will remove all "ContentItems" associated with the SimpleArticle Module for articles that no longer exist in the SimpleArticle table. Starting with V00.01.00 the module deletes the content items properly, prior to that it didn't.

delete from {objectQualifier}ContentItems where ContentKey like '%aid%'

and ContentItemId not in (select contentItemid from {objectQualifier}DNNSimpleArticle_Article)

and ContentTypeID = (select top 1 ContentTypeId from {objectQualifier}ContentTypes where ContentType = 'SimpleArticle')

Last edited Jan 10, 2012 at 11:03 PM by christoc, version 1


No comments yet.