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)...