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

Page title with apostrophe replaced with single quote at export

      Summary

      When exporting a page that has an apostrophe in its title, the XML result will change it to a single quote ' instead.
      If you have a another page PageA linked to the page with apostrophe title for example Test ABC’s, the internal link escapes the apostrophe properly in the URL but the page name has already changed to Test ABC's after the import. So the link will fail.

      Environment

      Reproduced on 5.6.3, 5.9.6, 5.9.7

      Steps to Reproduce

      1. Create a new page with this name Test ABC’s
      2. Create another page PageA and insert a link to the page Test ABC’s
      3. Save and export those pages by XML backup
      4. Import the XML

      Expected Results

      Both pages should be imported successfully with the proper names and the internal link should be working.

      Actual Results

      PageA is imported properly, but the other page title becomes Test ABC's instead of Test ABC’s. Internal link is broken as well because the page name has changed.

      Workaround

      The workaround is to update the page title from the database manually

      UPDATE CONTENT
      SET TITLE = REPLACE(TITLE, 'ABC''s', 'ABC’s')
      WHERE SPACEID = <space_id> AND TITLE = 'Test ABC''s'
      

            [CONFSERVER-41354] Page title with apostrophe replaced with single quote at export

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2901769 ] New: CONFSERVER Bug Workflow v4 [ 2996351 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2798315 ] New: JAC Bug Workflow v3 [ 2901769 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2713289 ] New: JAC Bug Workflow v2 [ 2798315 ]
            Owen made changes -
            Symptom Severity Original: Minor [ 14432 ] New: Severity 3 - Minor [ 15832 ]
            Adam Barnes (Inactive) made changes -
            Resolution New: Timed out [ 10 ]
            Status Original: Gathering Impact [ 12072 ] New: Resolved [ 5 ]

            Thank you for taking the time to raise, comment or vote on this Bug. We regret to inform you that due to a limited number of reports and based on our current backlog of higher impact issues that we are closing this issue as Timed Out.

            If this issue is still impacting you on a recent version please feel free to comment with the affected version. Any further details you may be able to provide regarding reproduction or impact of this issue may help us better address this issue.

            Thanks again.
            Cheers,

            Confluence Product Management

            Adam Barnes (Inactive) added a comment - Thank you for taking the time to raise, comment or vote on this Bug. We regret to inform you that due to a limited number of reports and based on our current backlog of higher impact issues that we are closing this issue as Timed Out. If this issue is still impacting you on a recent version please feel free to comment with the affected version. Any further details you may be able to provide regarding reproduction or impact of this issue may help us better address this issue. Thanks again. Cheers, Confluence Product Management
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2380984 ] New: JAC Bug Workflow [ 2713289 ]
            Status Original: Open [ 1 ] New: Gathering Impact [ 12072 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2272676 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2380984 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2223070 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2272676 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2173299 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2223070 ]

              Unassigned Unassigned
              rslaiby Rudy Slaiby
              Affected customers:
              1 This affects my team
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: