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

    • 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: