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

Blogpost Creation Timestamp is set to 00:00:00 in CREATIONDATE column

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Low
    • None
    • 4.0
    • None

    Description

      Steps to reproduce:
      1. Create a new blog post in Confluence 4.0
      2. Run the following query against the database to list all created blogs sorted by CREATIONDATE:
        SELECT TITLE, CREATIONDATE, LASTMODDATE
        FROM CONTENT
        WHERE CONTENTTYPE='BLOGPOST'
        AND PREVVER IS NULL
        ORDER BY CREATIONDATE;
        
      3. The timestamp of newly created blog post is set to 00:00:00 e.g. SQL1.png

      The issue does not occurred in Confluence 3.5.x. This seems to be broken in 4.0.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              hsuhailah Hanis Suhailah (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: