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

        1. SQL1.png
          30 kB
          Hanis Suhailah

        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: