Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-22560

Blog post creation date is used as a publish date: it is different to the actual creation time and sometimes stored as midnight

XMLWordPrintable

      When testing Activity Streams, new blog posts were showing up with timestamps that were way off. I found that when Streams is querying content from Confluence, every com.atlassian.confluence.pages.BlogPost object has a creationDate property with no time (i.e. the date is correct but the time is 00:00:00). The lastModificationDate property has the correct time, so we can probably work around this in Streams by just using lastModificationDate instead of creationDate for new blog posts.

      This might be related to CONF-17872 - that issue was resolved as "not a bug" on the theory that it had to do with different server time vs. user time, but that can't be true in this case because I'm running locally. Also might be related to CONF-21910.

            [CONFSERVER-22560] Blog post creation date is used as a publish date: it is different to the actual creation time and sometimes stored as midnight

            Michael Schumacher added a comment -

            Hi everyone,

            I'm still experiencing the issue where the creation date of a blog post (12:10) does not match the displayed date in the macro (13:10), even though I'm using version 8.5.6. According to Atlassian, this should have been fixed since 8.5.0.

            Has anyone encountered similar issues or have any solutions?

            Thanks!

            Michael Schumacher added a comment - Hi everyone, I'm still experiencing the issue where the creation date of a blog post (12:10) does not match the displayed date in the macro (13:10), even though I'm using version 8.5.6. According to Atlassian, this should have been fixed since 8.5.0. Has anyone encountered similar issues or have any solutions? Thanks!

            James Whitehead added a comment -

            A fix for this issue is available in Confluence Server and Data Center 8.5.0.
            Upgrade now or check out the Release Notes to see what other issues are resolved.

            James Whitehead added a comment - A fix for this issue is available in Confluence Server and Data Center 8.5.0. Upgrade now or check out the Release Notes to see what other issues are resolved.

            James Ponting added a comment -

            Hi All,

            Just a note on the fix for this one.

            Firstly, apologies the ticket was updated late, the work was tracked on an internal ticket and not correctly moved to the public ticket.

            Secondly, the fix has a limitation of minute level accuracy due to using minutes as the smallest measure of time in our interface time picker. I don't expect this to cause issues, but just in case

            Thanks,
            James Ponting
            Engineering Manager - Confluence Data Center

            James Ponting added a comment - Hi All, Just a note on the fix for this one. Firstly, apologies the ticket was updated late, the work was tracked on an internal ticket and not correctly moved to the public ticket. Secondly, the fix has a limitation of minute level accuracy due to using minutes as the smallest measure of time in our interface time picker. I don't expect this to cause issues, but just in case Thanks, James Ponting Engineering Manager - Confluence Data Center

            James Ponting added a comment -

            A fix for this issue is available in Confluence Server and Data Center 7.19.11 and Confluence Server and Data Center 8.4.1.
            Upgrade now or check out the Release Notes to see what other issues are resolved.

            James Ponting added a comment - A fix for this issue is available in Confluence Server and Data Center 7.19.11 and Confluence Server and Data Center 8.4.1. Upgrade now or check out the Release Notes to see what other issues are resolved.

            James Ponting added a comment - - edited

            Hi All,

            Just updating on this one.

            We introduced a handful of changes to facilitate this fix in Confluence 8.1.0, but unfortunately saw a performance regression that could be attributed to this work (CONFSERVER-83349: Increase in load time when accessing Blogpost)

            We've been working on fixing this area of code so that we can easily pull users timezones without hammering the database with calls. This improvement work is blocking this ticket, so we don't have an update here at the moment.

            Basically, still working on it. I'll update once we have more to share.

            Thanks,
            James Ponting
            Engineering Manager - Confluence Data Center

            James Ponting added a comment - - edited Hi All, Just updating on this one. We introduced a handful of changes to facilitate this fix in Confluence 8.1.0, but unfortunately saw a performance regression that could be attributed to this work ( CONFSERVER-83349: Increase in load time when accessing Blogpost ) We've been working on fixing this area of code so that we can easily pull users timezones without hammering the database with calls. This improvement work is blocking this ticket, so we don't have an update here at the moment. Basically, still working on it. I'll update once we have more to share. Thanks, James Ponting Engineering Manager - Confluence Data Center

            James Ponting added a comment -

            Hi 0ce3de02489d,

            Thanks for the the constructive criticism.

            The Blog system in Confluence is something of a tacked on design, with tendrils deep into the core of the product. Whilst templates, drafts, pages and all the related content basically use the same system, Blogs are carved out in their own special systems. With this were some dubious design choices made when Confluence has 5 people working on it that have made it incredibly difficult to fix what is, on the surface, a seemingly trivial problem.

            We have made progress on the issue and a lot of it has occurred in the background, but as we've progressed the issue, we've discovered additional edge cases and problems that have required more reworking to correct. There's really no good solution to the problem short of a rewrite, and that's not feasible for the issue we're correcting here.

            We will hopefully have a finalised solution soon.

            Thanks,
            James Ponting
            Engineering Manager - Confluence Data Center

            James Ponting added a comment - Hi 0ce3de02489d , Thanks for the the constructive criticism. The Blog system in Confluence is something of a tacked on design, with tendrils deep into the core of the product. Whilst templates, drafts, pages and all the related content basically use the same system, Blogs are carved out in their own special systems. With this were some dubious design choices made when Confluence has 5 people working on it that have made it incredibly difficult to fix what is, on the surface, a seemingly trivial problem. We have made progress on the issue and a lot of it has occurred in the background, but as we've progressed the issue, we've discovered additional edge cases and problems that have required more reworking to correct. There's really no good solution to the problem short of a rewrite, and that's not feasible for the issue we're correcting here. We will hopefully have a finalised solution soon. Thanks, James Ponting Engineering Manager - Confluence Data Center

            DVSE_Syncuser added a comment -

            How long does it take to fix this? Is there any capable developer available? unbelievable.

            DVSE_Syncuser added a comment - How long does it take to fix this? Is there any capable developer available? unbelievable.

            Patrick Brauner added a comment -

            When will the bug be fixed? The incorrect time information causes a lot of confusion among users.

            Patrick Brauner added a comment - When will the bug be fixed? The incorrect time information causes a lot of confusion among users.

            James Ponting added a comment -

            Hi 337dfcc64420,

            There is not yet an update.

            Thanks,
            James Ponting
            Engineering Manager - Confluence Data Center

            James Ponting added a comment - Hi 337dfcc64420 , There is not yet an update. Thanks, James Ponting Engineering Manager - Confluence Data Center

            Bence Vagner added a comment -

            Hi there, 

            is there any update?

            Bence Vagner added a comment - Hi there,  is there any update?

              ablekhman@atlassian.com Alex Blekhman (Inactive)
              ebishop Eli Bishop (Inactive)
              Affected customers:
              189 This affects my team
              Watchers:
              149 Start watching this issue

                Created:
                Updated:
                Resolved: