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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 10.4
    • 10.4-rc-1
    • Index
    • Windows 10, XWiki 10.4 RC 1 with MySQL 5.7 and IE 11
    • High
    • Trivial
    • N/A
    • N/A

    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

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

              Dates

                Created:
                Updated:
                Resolved: