As mentioned in the related issue CONF-15539, extranet.atlassian.com's database contained two rows that were almost entirely null, including creation/modification date. At least one of the pages has an attachment. I added the dates in manually, but how these records came to exist is a mystery. We should add not-null to the date columns to prevent this from happening again, but of course such constraints are difficult to add retrospectively. The date on the attachment attached to 1717142914 is Apr 02, 2009, so the bug may have been only in some early 3.0 milestone.

            [CONFSERVER-15547] Content rows in database missing required data

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2873920 ] New: CONFSERVER Bug Workflow v4 [ 3003631 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2802082 ] New: JAC Bug Workflow v3 [ 2873920 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2732511 ] New: JAC Bug Workflow v2 [ 2802082 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2397839 ] New: JAC Bug Workflow [ 2732511 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2295497 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2397839 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2231460 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2295497 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2190572 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2231460 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1924654 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2190572 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1727005 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1924654 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1683020 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1727005 ]

              shaffenden Steve Haffenden (Inactive)
              don.willis@atlassian.com Don Willis
              Affected customers:
              0 This affects my team
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: