Reorder Pages screen is blank

XMLWordPrintable

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      In the OD edition of Confluence connected to MSSQL 2012, the reorder pages screen doesn't display any of the child pages of the space.

      Steps to Reproduce

      1. Install 5.4-OD-5 with MSSQL 2012
      2. Create a space with child pages
      3. Navigate to Space Admin > Content Tools > Reorder Pages
      4. Screen is blank (see screenshot)
      5. The following error is thrown in the logs:

      2014-03-17 18:43:18,294 ERROR [http-bio-8090-exec-15] [opensymphony.xwork.util.CompoundRootAccessor] getProperty Caught an Ognl exception while getting property JSONString
 -- referer: http://localhost:8090/pages/reorderpages.action?key=ds | url: /pages/children.action | userName: admin | action: children | space: 65537
ognl.OgnlException: JSONString [org.springframework.dao.TransientDataAccessResourceException: Hibernate operation: Could not execute query; SQL []; Incorrect syntax near the keyword 'is'.; nested exception is java.sql.SQLException: Incorrect syntax near the keyword 'is'.]
...
org.springframework.dao.TransientDataAccessResourceException: Hibernate operation: Could not execute query; SQL []; Incorrect syntax near the keyword 'is'.; nested exception is java.sql.SQLException: Incorrect syntax near the keyword 'is'.

      Confluence is trying to execute the following query, which fails due to a syntax error in the ORDER BY clause:

      select page0_.CONTENTID as CONTENTID, page0_.CHILD_POSITION as CHILD_P13_, page0_.PARENTID as PARENTID, page0_.SPACEID as SPACEID, page0_.TITLE as TITLE, page0_.VERSION as VERSION, page0_.CREATOR as CREATOR, page0_.CREATIONDATE as CREATION6_, page0_.LASTMODIFIER as LASTMODI7_, page0_.LASTMODDATE as LASTMODD8_, page0_.VERSIONCOMMENT as VERSIONC9_, page0_.PREVVER as PREVVER, page0_.CONTENT_STATUS as CONTENT11_ from CONTENT page0_ 
where page0_.CONTENTTYPE='PAGE' and ((page0_.PARENTID is null )and(page0_.PREVVER is null )and(page0_.SPACEID=65537 )and(page0_.CONTENT_STATUS='current' )) 
order by  page0_.CHILD_POSITION is null , page0_.CHILD_POSITION , page0_.TITLE

        1. screenshot-1.png
          screenshot-1.png
          32 kB

            Assignee:
            David Taylor (Inactive)
            Reporter:
            Brian
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: