Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-15267

The top level pages that are excluded by default give error, and child pages are not showing, when disabling the filter for Navigation Panel while using MySQL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.4-rc-1
    • Fix Version/s: 10.4
    • Component/s: Index
    • Environment:
      Windows 10, XWiki 10.4 RC 1 with MySQL 5.7 and IE 11
    • Development Priority:
      High
    • Difficulty:
      Trivial
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      Steps to reproduce:

      1. Access the instance as an Admin
      2. Go to Administer Wiki > Look & Feel > Navigation Panel
      3. Remove the tick from Exclude Top Level Extension Pages
      4. Remove Sandbox from Exclusions
      5. Click on Save
      6. Refresh the browser (Ctrl + F5)
      7. Click on the arrow next to Help, Sandbox, XWiki
      8. Observe the Navigation
      9. Click on Help, Sanbox, XWiki

      Expected results: The pages appear and can be accessed.

      Actual results: When clicking on the arrows loading keeps appearing. When clicking on Help, Sandbox or XWiki many errors appear in the Console and the child pages don't appear, loading just remains.

      2018-05-15 15:54:25,888 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:54:25,889 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:54:25,891 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:Help.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:54:35,068 [http://localhost:8080/xwiki/bin/get/Main/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:54:35,069 [http://localhost:8080/xwiki/bin/get/Main/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:54:35,070 [http://localhost:8080/xwiki/bin/get/Main/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:Help.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:54:41,385 [http://localhost:8080/xwiki/bin/get/Main/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3ASandbox.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:54:41,385 [http://localhost:8080/xwiki/bin/get/Main/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3ASandbox.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:54:41,386 [http://localhost:8080/xwiki/bin/get/Main/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3ASandbox.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:Sandbox.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:54:42,470 [http://localhost:8080/xwiki/bin/get/Main/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:54:42,470 [http://localhost:8080/xwiki/bin/get/Main/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:54:42,472 [http://localhost:8080/xwiki/bin/get/Main/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:Help.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:54:44,752 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:54:44,753 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:54:44,755 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:Help.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:54:58,039 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3ASandbox.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:54:58,039 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3ASandbox.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:54:58,041 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3ASandbox.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:Sandbox.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:54:58,746 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AXWiki.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:54:58,747 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AXWiki.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:54:58,748 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AXWiki.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:XWiki.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:55:02,434 [http://localhost:8080/xwiki/bin/get/Sandbox/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3ASandbox.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:55:02,434 [http://localhost:8080/xwiki/bin/get/Sandbox/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3ASandbox.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:55:02,435 [http://localhost:8080/xwiki/bin/get/Sandbox/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3ASandbox.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:Sandbox.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:55:04,113 [http://localhost:8080/xwiki/bin/get/XWiki/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AXWiki.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:55:04,114 [http://localhost:8080/xwiki/bin/get/XWiki/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AXWiki.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:55:04,114 [http://localhost:8080/xwiki/bin/get/XWiki/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AXWiki.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:XWiki.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:55:05,058 [http://localhost:8080/xwiki/bin/get/XWiki/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:55:05,058 [http://localhost:8080/xwiki/bin/get/XWiki/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:55:05,059 [http://localhost:8080/xwiki/bin/get/XWiki/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:Help.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:55:55,907 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:55:55,907 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:55:55,916 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:Help.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:56:01,592 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3ASandbox.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:56:01,592 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3ASandbox.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:56:01,595 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3ASandbox.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:Sandbox.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:56:02,591 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AXWiki.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:56:02,592 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AXWiki.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:56:02,595 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AXWiki.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:XWiki.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:58:07,634 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 15:58:07,635 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 15:58:07,645 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:Help.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].
      2018-05-15 15:58:13,533 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 1052, SQLState: 23000
      2018-05-15 16:05:34,037 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] ERROR o.h.u.JDBCExceptionReporter    - Column 'XWD_FULLNAME' in where clause is ambiguous
      2018-05-15 16:05:34,076 [http://localhost:8080/xwiki/bin/get/Help/WebHome?outputSyntax=plain&sheet=XWiki.DocumentTree&showAttachments=false&showTranslations=false&&data=children&id=document%3Axwiki%3AHelp.WebHome] WARN  o.x.i.t.i.n.DocumentTreeNode   - Failed to retrieve the children of [document:xwiki:Help.WebHome]. Root cause [MySQLIntegrityConstraintViolationException: Column 'XWD_FULLNAME' in where clause is ambiguous].

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mflorea Marius Dumitru Florea
                Reporter:
                ganechitoaei Gabriela Anechitoaei
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Date of First Response: