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

Unhelpful error for duplicate page name when moving hierarchy between spaces

      When moving a page hierarchy between spaces, if there is any page in the hierarchy being moved with the same name as a page in the target space, the move will abort with the message: "A descendent page shares the same title of another page in the selected space."

      It should say which page(s) have duplicate names, and provide a way to resolve the problem (e.g. prompt to rename src pages with some suffix).

            [CONFSERVER-27598] Unhelpful error for duplicate page name when moving hierarchy between spaces

            I think we should automatically rename colliding pages from the space we're moving things out of, so that we suffix them with " (1)" or 2 etc if that suffix is already in use, truncating the original page title if necessary to keep it under 255 chars. We can then provide a list of pages that collided after we're done moving everything, and help the user to rename these pages to something else should they want to (maybe force any links on this report to open in a new tab, so they can easily come back to it). Any renames will have to update any references as well.

            Richard Atkins added a comment - I think we should automatically rename colliding pages from the space we're moving things out of, so that we suffix them with " (1)" or 2 etc if that suffix is already in use, truncating the original page title if necessary to keep it under 255 chars. We can then provide a list of pages that collided after we're done moving everything, and help the user to rename these pages to something else should they want to (maybe force any links on this report to open in a new tab, so they can easily come back to it). Any renames will have to update any references as well.

            I use the query from this answer: https://answers.atlassian.com/questions/92971/identifying-duplicate-page-titles-while-merging-several-spaces
            It gives no results.
            I wrote another query in attempt to find duplicates:

            select c1.title, c1.contentid, c2.contentid
            from CONTENT c1 inner join CONTENT c2 on c1.TITLE=c2.TITLE
            left join [SPACES] s1 on s1.SPACEID=c1.SPACEID
            left join [SPACES] s2 on s2.SPACEID=c2.SPACEID
            where s1.SPACEKEY='space1' and s2.SPACEKEY='space2'
            go
            

            No results as well.

            However when I attempt to move a page with children from space1 to space2 Confluence 4.1.9 still fails with the message: "A descendent page shares the same title of another page in the selected space."

            Anton Kozyr added a comment - I use the query from this answer: https://answers.atlassian.com/questions/92971/identifying-duplicate-page-titles-while-merging-several-spaces It gives no results. I wrote another query in attempt to find duplicates: select c1.title, c1.contentid, c2.contentid from CONTENT c1 inner join CONTENT c2 on c1.TITLE=c2.TITLE left join [SPACES] s1 on s1.SPACEID=c1.SPACEID left join [SPACES] s2 on s2.SPACEID=c2.SPACEID where s1.SPACEKEY= 'space1' and s2.SPACEKEY= 'space2' go No results as well. However when I attempt to move a page with children from space1 to space2 Confluence 4.1.9 still fails with the message: "A descendent page shares the same title of another page in the selected space."

              honguyen Hoang Nguyen (Inactive)
              richatkins Richard Atkins
              Affected customers:
              7 This affects my team
              Watchers:
              12 Start watching this issue

                Created:
                Updated:
                Resolved: