An attachment and its container could be related to different spaces

XMLWordPrintable

    • 20
    • Severity 2 - Major
    • 5

      Background

      An attachment and its container could be related to different spaces.
      It could happen if the page is moved to another space.
      As a result, the import process of such spaces could fail with "could not execute statement".

      Expected behaviour

      Attachments and their containers must be related to the same space.

      Workaround

      https://confluence.atlassian.com/confkb/importing-a-space-fails-with-could-not-execute-statement-error-in-confluence-server-949242294.html

      Additional information

      To test if database is affected by bug, this script could be run:

      SELECT COUNT(*)
      FROM CONTENT
      JOIN CONTENT xpage ON CONTENT.PAGEID = xpage.CONTENTID
      WHERE CONTENT.SPACEID != xpage.SPACEID
      AND CONTENT.CONTENTTYPE = 'ATTACHMENT';
      

      If it returns non-zero value, database is affected by this bug.

            Assignee:
            Unassigned
            Reporter:
            George Lipatov
            Votes:
            6 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: