This project is read-only.
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 11, 2012 at 12:03 AM by christoc, version 1


No comments yet.