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
To download the files go to my blog entry:
http://www.enio.ch/Blog/tabid/63/EntryID/77/Default.aspx
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. !!!!