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

        1. Navigation.jpg
          143 kB
          Gabriela Anechitoaei
        2. Navigation2.jpg
          168 kB
          Gabriela Anechitoaei

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. XWIKI-12895 Document Tree Macro should allow excluding a list of spaces

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-15269 No pages are displayed when disabling the Exclude filter for Navigation Panel on Oracle

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          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: