Maybe its the sign of old age. I’m not used to people ignoring me. Alright, so DNN Blog module has been bugging me coz of its incompatibility with Feedburner. If you try to import your DNN Blog module feed into feedburner, you would notice the images are all missing. Here’s a quick fix for a happy feed burning.
Before you go any further, please read the standard disclaimer1.
If you are noticing the missing images in the screenshot below when you try to import the RSS feed into feedburner, you may be able to use the solution below
Make sure you backup your DNN database before applying the changes below! You’ve been forewarned.
USE [DNN]
GO
/****** Object: StoredProcedure [dbo].[Blog_ListEntriesByBlog] Script Date: 01/03/2009 22:26:22 ******/
/* This procedure was modified by Subodh on 2/1/2008; Any subsequent upgrade/update of DNN Blog module will overwrite this procedure
It is advisable that you create a backup copy of this procedure before modifying this stored proc and do a database backup
*/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Blog_ListEntriesByBlog]
@BlogID int,
@BlogDate datetime = null,
@ShowNonPublic bit = 0,
@ShowNonPublished bit=0,
@MaxEntries int =10
AS
DECLARE @Prefix varchar(53)
select top 1 @Prefix='http://'+RTRIM( LTRIM(PA.HTTPAlias))
from
Blog_Blogs B,
Users U, UserPortals UP, PortalAlias PA
where B.BlogId=@BlogID and B.UserID= U.UserID and UP.UserID =U.UserID and PA.PortalID = UP.PortalID
order by PA.PortalAliasID asc
If @BlogDate IS NULL SET @BlogDate = GetUTCDate()
SET rowcount @MaxEntries
SELECT
U.[UserID],
U.[Username],
U.[FirstName] + ' ' + U.[LastName] AS UserFullName,
E.[EntryID],
E.[BlogID],
E.[Title],
cast(
Replace(
REPLACE(cast(E.[Description] as varchar(max)),'"/Portals/','"'+@Prefix+'/Portals/')
,'"/Portals/','"'+@Prefix+'/Portals/')
as ntext) as [Description],
E.[Entry],
E.[AddedDate],
E.[Published],
E.[Copyright],
E.[PermaLink],
IsNull(E.[AllowComments],B.[AllowComments]) As AllowComments,
(Select Count(*) FROM dbo.Blog_Comments WHERE EntryID = E.EntryID AND (Approved = 1 OR Approved <> @ShowNonPublic)) As CommentCount,
B.[PortalID] As BlogPortalID,
B.[ParentBlogID],
B.[Title] As BlogTitle,
B.[Description] As BlogDescription,
B.[Public] As BlogPublic,
B.[AllowComments] As BlogAllowComments,
B.[AllowAnonymous] As BlogAllowAnonymous,
B.[LastEntry] As BlogLastEntry,
B.[Created] As BlogCreated,
B.[Culture] As BlogCulture,
B.[ShowFullname] As BlogShowFullName,
B.[DateFormat] As BlogDateFormat,
B.[TimeZone] As BlogTimeZone,
B.[Syndicated] As BlogSyndicated,
B.[SyndicateIndependant] As BlogSyndicateIndependant,
B.[SyndicationEmail] As SyndicationEmail
FROM dbo.Blog_Blogs B INNER JOIN
dbo.Blog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN
dbo.Users U ON B.[UserID] = U.[UserID]
WHERE (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID)
AND E.AddedDate <=@BlogDate
AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished)
AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic)
ORDER BY E.AddedDate DESC
After applying these changes, my feed appears as expected. Phew!
Alright, back to work.
1
This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use.