We couldn't load all Actvitity tabs. Refresh the page to try again.
If the problem persists, contact your Jira admin.
IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
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

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

      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.

            Loading...
            IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
            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

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

                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.

                        Unassigned Unassigned
                        hsuhailah Hanis Suhailah (Inactive)
                        Affected customers:
                        3 This affects my team
                        Watchers:
                        2 Start watching this issue

                          Created:
                          Updated:
                          Resolved:

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

                              Created:
                              Updated:
                              Resolved: