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

Pages can't be "included" if they contain symbols on their titles

XMLWordPrintable

      Summary:

      As you can see in my example, the include macro won't work with page names that includes special characters like the slash / symbol

      https://wiki.childno.de/x/IABe

      Steps to Reproduce:

      1. Create page with slash in title
      2. Create a second page. Add include macro to this page

      Workaround:

      Removing the slash from the title of the page will solve the problem for any new pages, but you'll still have old pages which had the broken include macro in your instance. You can delete these pages via the following:

      You'll need to find out what the contentid of the page is, via this query:

      select contentid from content where title = 'TITLE_OF_PAGE_YOU_WANT_TO_DELETE' and prevver is null;

      You can then paste the following link into your browser:

      <confluence_base_url>/pages/removepage.action?pageId=THE_CONTENTID_FROM_DB_QUERY

      If you need to recover the contents of the page, you'll need to remove the include macro from the page. Prior to doing any update or delete on your database please make sure to backup both the filesystem and database. Having done so, run:

      update bodycontent set body = regexp_replace(body, '<ac:macro ac:name="include"><ac:default-parameter>.*/.*</ac:default-parameter></ac:macro>', '')  where contentid = (select contentid from content where title = 'YOUR_PAGE_TITLE' and prevver is null);

      This will find any include macro with a slash in the the included page's title and remove it from your page.

      Note: This was written for a Postgres database. If you are using something else, you may need to tweak the query.

            [CONFSERVER-24785] Pages can't be "included" if they contain symbols on their titles

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2890201 ] New: CONFSERVER Bug Workflow v4 [ 2982585 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2803978 ] New: JAC Bug Workflow v3 [ 2890201 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2738304 ] New: JAC Bug Workflow v2 [ 2803978 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2389175 ] New: JAC Bug Workflow [ 2738304 ]
            Alex Yakovlev (Inactive) made changes -
            Labels Original: affects-server bugfix editor editor-macros loyalty macros-include-macro New: affects-server editor editor-macros loyalty macros-include-macro
            Alex Yakovlev (Inactive) made changes -
            Labels Original: affects-server bugfix editor editor-macros macros-include-macro New: affects-server bugfix editor editor-macros loyalty macros-include-macro
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2266539 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2389175 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2210254 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2266539 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2196132 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2210254 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1925922 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2196132 ]

              vvo Vu Truong Vo (Inactive)
              c34ad611bdfc childnode
              Affected customers:
              27 This affects my team
              Watchers:
              41 Start watching this issue

                Created:
                Updated:
                Resolved: