Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogArchive Calendar - Day issueArchive Calendar - Day issue
Previous
 
Next
New Post
5/10/2009 11:47 PM
 

Hi,

 

Hi know there's a lot of peoples on the forum that experiencing the same issue than me.  When i'm clickin on a date on the calendar of the archive container the blog module do not display blog entrys for that date but for the day before so if I want to see blog entrys for may 9 I have to click on may 10.

I know this is a known bug but i wonder if anyone have found a way to resolve temporarly the problem. Anyone have an idea of when this issue will be solved? When can we expect to have a module update?

 

Regards,

 

Danyel

 
New Post
5/11/2009 2:36 AM
 

Hi Danyel,

what version of the module are you using? Are you using DST (daylight ave time) time in your country? Are your entry added at a time around midnight? The feature works fine on the dotnetnuke.com blogs.

Best regards,
Dario Rossa

 
New Post
5/11/2009 8:18 AM
 

Hi Dario,

 

I'm using 3.05.01. Yes we are using DST in our country (Canada). Yesterday this was not working, i was trying around 10pm and I was able to see my posts only when clicking on the following day on the calendar.

This morning I just added a post and the post is showing on the 11, so this is correct.  I guess there's something to do with the timezones.

 

Regards,

Danyel

 

 
New Post
5/11/2009 11:59 AM
 

Hi Danyel,

yes, this is a timezone issue. To fix it you can alter the blog's timezone one hour later or one hour earlier to make the entry time match your server time. However this is a known issue, and we will try to fix in in the next versions.

Best regards,
Dario Rossa

 
New Post
5/26/2009 4:00 PM
 

I fixed it by modifying Blog_ListEntriesByBlog like so:

 

ALTER PROCEDURE [dbo].[Blog_ListEntriesByBlog]
@BlogID int,
@BlogDate datetime = null,
@ShowNonPublic bit = 0,
@ShowNonPublished bit=0,
@MaxEntries int =10

AS

DECLARE @BlogMonth int
DECLARE @BlogYear int
DECLARE @BlogDay int
SELECT @BlogMonth = DATEPART(mm, @BlogDate)
SELECT @BlogYear = DATEPART(yy, @BlogDate)
SELECT @BlogDay = DATEPART(dd, @BlogDate)

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],
E.[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 ((DATEPART(yy, DateAdd(minute, B.TimeZone, E.AddedDate)) = @BlogYear AND
DATEPART(mm, DateAdd(minute, B.TimeZone, E.AddedDate)) = @BlogMonth AND
DATEPART(dd, DateAdd(minute, B.TimeZone, E.AddedDate)) = @BlogDay) OR
DateAdd(minute, B.TimeZone, E.AddedDate) <=@BlogDate)

AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished)
AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic)
ORDER BY E.AddedDate DESC

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogArchive Calendar - Day issueArchive Calendar - Day issue


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out