Written by:
12/30/2007 

The DotNetNuke (DNN) CMS has a great Blog Module that allows you to have your very own blog on your web site.  That's no secret.  However, some people do not blog chronologically and/or update their blogs - in turn changing the publish date.  Well, the current version doesn't allow you to change that date manually.  Here is how you can....

This first method requires that you have access to a Host account.  (A fix without the Host account to

1. Get the EntryId of the blog entry by visiting the page that it's on and get the numerical value after the EntryId in the URL.  For instance, in the example URL below, the EntryId is 123.
   
   http://www.domain.com/Blog/tabid/99/EntryId/123/Default.aspx
2. Login as a host.
3. Go to the Host Menu and choose "SQL" from the list.
4. Input the following T-SQL script into the textbox (change the date to match the date that you really want):
   
   UPDATE {databaseOwner}{objectQualifier}Blog_Entries SET AddedDate = '12/30/2007 04:15:00 PM' WHERE EntryId = 123
5. Click the Update link below the textbox.  As long as the page reloads and there are no errors, all went well.

Please Note that the suggestion below is a change to the DNN Core and may be overwritten in an upgrade.
The other way would only need to be done once.  This is really a fix, rather than a workaround like above.  However, this method may require some additional background knowledge of T-SQL, and SQL Server in general.  (This can also be done as a Host on the SQL page.)

1. Go into your DNN database table and find the Stored Procedure called ''.
2. Remove the "GETUTCDATE()" and replace it with '@AddedDate'.
3. Optionally, you could just switch the commented out code (if your Stored Procedure still has it).
4. Re-run the ALTER command to save your changes.

For now on, your posts will now accept the publish date that you enter into the form, instead of overwriting it.

The second option above can be changed by running this query on the SQL page.  Just run this query as described in the first step.

ALTER PROCEDURE {databaseOwner}{objectQualifier}Blog_UpdateEntry
 @BlogID int,
 @EntryID int, 
 @Title nvarchar(255),
 @Description nvarchar(1024),
 @Entry ntext,
 @Published bit,
 @AllowComments bit,
 @AddedDate datetime,
 @DisplayCopyright bit,
 @Copyright nvarchar(256),
 @PermaLink nvarchar(1024)
AS

UPDATE dbo.Blog_Entries SET
 [BlogID] = @BlogID,
 [Title] = @Title,
 [Description] = @Description,
 [Entry] = @Entry,
 [AddedDate] = @AddedDate,
 [Published] = @Published,
 [AllowComments] = @AllowComments,
 [DisplayCopyright] = @DisplayCopyright,
 [Copyright] = @Copyright,
 [PermaLink] = @PermaLink

WHERE
 [EntryID] = @EntryID

If @Published = 1
 UPDATE  dbo.Blog_Blogs
 SET [LastEntry] = GetUTCDate()
WHERE [BlogID] = @BlogID

*** UPDATE ***
This post is specifically about v3.03.01.  Version 3.04.00 was released today.  According to the release notes, this problem has been fixed.

Trackback Print

Tags:

Categories: DotNetNuke

Location: Blogs The Mighty Blog

Your name:
Your email:
	(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Add Comment   Cancel