Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 ForumsBlogBlogDate is set to tomorrow when blog is editedDate is set to tomorrow when blog is edited
Previous
 
Next
New Post
2/23/2010 7:26 AM
 
Peter Smith

Joined: 10/26/2006
Posts: 27

DNN=5.2.3
Blog module=04.00.00 (Beta 3)

All working well except when a blog is EDITED. 

The blog entry gets saved with the current date plus one day i.e. tomorrow.  So the edited blog does not appear in the current blog list until 24 hours time.  I have this problem on several sites and customers are getting annoyed and want to go elsewhere for their blogs - which is a pity because the module actually works well.  But seen from the customer point of view, it is a real problem that they cannot edit their blog because it causes it to get "hidden" for 24 hours.

I have checked the database and the creted date for the blog does change upon editing.  SQL reports an error if I try to manually edit the table to get the blog to reappear.  Hope it can be fixed in the next release. 

Good work otherwise and thanks.

Peter Smith
 
New Post
2/23/2010 11:41 AM
 
Chris Hammond


Chris Hammond's Avatar

Chris Hammond's Avatar

Chris Hammond's Avatar

www.christoc.com
Joined: 1/14/2003
Posts: 7319

Do you perhaps have the datetime configuration on your server off? or the users have all selected a timezone that is way off the timezone of how the server is configured?

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions
 
New Post
2/23/2010 6:10 PM
 
Peter Smith

Joined: 10/26/2006
Posts: 27

Hi Chris,

I'm Australian based. 

  • Server hardware is set to Sydney time
  • Portal is set to Sydney time
  • Plesk managment console set to Sydney time
  • The users timezone was set to US Pacific Time - RESET THIS TO SYDNEY TIME

RE-TEST THE BLOG ADD/EDIT CYCLE

Error still occurs

  • Blog created 2/24/2010 @ 7:31  (confirmed by Blog summary date/time and by the full blog date time)
  • Database records creation date/time as 2/23/2010 @21:31 (i.e. the time in Honolulu ! ! ! )
  • When blog entry retreived for editing - entry date is shown as 2/24/2010 @ 7:31
  • When saved and published - database records the time as 2/24/2010 @ 7:31(not as 2/23/2010 @21:31- the time it recorded as the creation date/time)
  • The blog entry is now hidden
  • I now retreive - can do so because I assigned it to a category, and it will appear when I click that category filter
  • Reported creation date is now 2/24/2010 @ 5:31 PM
  • RE-EDIT the same blog - new time 2/25/2010 3:31 AM
  • RE-EDIT the same blog yet again - new time 2/25/2010 1:31 PM
  • RE-EDIT the same blog yet again - new time 2/25/2010 11:31 PM
  • And so on into infinity . . .

This process continues as long as you retreive, edit and republish the blog.  Each time the Blog Module adds a few hours to the Created Date, pushing back the date it will be actually displayed.

So it may be a bug.  Screngrabs @ www.m-cast.com/blog_error.html.   Any suggestions on what can be done next?

Cheers,

Peter
 
New Post
2/26/2010 4:46 PM
 
Peter Smith

Joined: 10/26/2006
Posts: 27

I looked at this issue in more detail.  The bug seems to come in the stored proceedure "Blog_UpdateEntry".  This proceedure updates the blog entry after editing.  It also updates the "AddedDate" field in the "Blog_Entries" table. 

The proceedure currently sets "[AddedDate] = @AddedDate,".   If this procedure is changed to set "[AddedDate] = GetUTCDate()," then the system seems to work correctly on my installations.  Blogs now have the right created dates and updated dates. The published blogs now appear in the modules as they should. 

I'm not sure if this is the total answer.  Changing this stored proceedure may have other side effects I am not aware of; and it probably needs a lot of testing - but it solved my current problem.
Cheers - Peter Smith
 
 Page 1 of 1
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogDate is set to tomorrow when blog is editedDate is set to tomorrow when blog is edited


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