DNN Blog Module does not provide proper URL for images

thomas.kohler@enio.ch — Wed, 11 Feb 2009 09:22:00 GMT

Recently I discovered that certain RSS readers could not display my images
that I added to my blog posts.

After diving into this topic I discovered that the image source in DNN is mapped
to something like:

/Portals/0/images/%5BProvider%5D/%5BUser%5D/%5BYear%5D.....

so basically the http://domain part is missing which some RSS readers have problem with.

After some email traffic with Don from ITCrossing (http://www.itcrossing.com) he pointed out that this is not an error of the blog provider of the metaPost module (http://dnn.itcrossing.com/products/modules/metapost/) of them which I use to post my articles with Windows Live Writer to DNN but rather of the DNN blog module itself. He told me to check this site to find a possible solution:

http://www.subodh.com/Blog/EntryId/110/Fixing-the-DNN-Blog-and-Feedburner-issues.aspx

The proposed solution is to adapt some changes in the stored procedures of the DNN installation.
After diving into this I tried to change the stored procedure as mentioned in the blog entry above but it did not solve my problem fully. So I did have a closer look at it.

Firstly, I changed not to replace the Description field but the Entry field.
Secondly, I changed more than only the mentioned SP Blog_GetEntry. I changed the following SPs:

Blog_GetEntry
Blog_ListEntriesByPortalByMonth
Blog_ListEntriesByPortalByDay
Blog_ListAllEntriesByBlog
Blog_ListEntriesByBlog
Blog_ListEntriesByPortal

Download All Files download

The change is to replace some text of the blog entry and add the missing fields:

if you have the PortalID as a parameter in the SP use:

   1:  DECLARE @Prefix varchar(53)

   2:  select top 1 @Prefix='http://'+RTRIM( LTRIM(PA.HTTPAlias))

   3:  from

   4:      Blog_Blogs B,

   5:      Users U, UserPortals UP, PortalAlias PA

   6:  where B.PortalID=@PortalID and B.UserID= U.UserID and UP.UserID =U.UserID and PA.PortalID = UP.PortalID

   7:  order by PA.PortalAliasID asc

if you have the BlogID as a parameter in the SP use:

   1:  DECLARE @Prefix varchar(53)

   2:  select top 1 @Prefix='http://'+RTRIM( LTRIM(PA.HTTPAlias))

   3:  from

   4:      Blog_Blogs B,

   5:      Users U, UserPortals UP, PortalAlias PA

   6:      where B.BlogId=@BlogID and B.UserID= U.UserID and UP.UserID =U.UserID and PA.PortalID = UP.PortalID

   7:  order by PA.PortalAliasID asc

and then:

   1:  cast(

   2:  Replace(

   3:  REPLACE(cast(E.[Entry] as varchar(max)),'"/Portals/','"'+@Prefix+'/Portals/')

   4:  ,'"/Portals/','"'+@Prefix+'/Portals/')

   5:  as ntext) as [Entry],

!!!!! By changing the SPs be aware that on every update of the blog module your changes will be overwritten. Also be aware that all changes of the SPs you do by your own risk so please back up the SPs before you start changing them. !!!!

More ...

DotNetNuke

DNN Blog Module does not provide proper URL for images