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

Error when sorting by "Creation date" or "Last modification date" in Document Tree macro that prevents displaying the documents

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • 17.3.0-rc-1
    • 17.0.0, 17.2.0-rc-1
    • Tree
    • None
    • Windows 11 Pro, Firefox 136, using an instance of XWiki 17.0.0 on MySQL 9, Tomcat 11.0.5
    • Unknown

    Description

      Steps to reproduce

      1. Edit a page and insert the Page Tree macro
      2. Under 'Sort pages by' section, in the drop-down, select "Creation date" or "Last modification date"
      3. Click "Submit" button
      4. Observe the logs

      Expected results

      The documents on the macro are sorted according to the option selected.

      Actual results

      The macro outputs "No pages found" and in the XWiki console there is the following error:

      On Tomcat 11.0.5:

      2025-03-25 17:02:32,265 [http-nio-1115-exec-5 - http://localhost:1115/xwiki/bin/get/aaa/WebHome?] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1054, SQLState: 42S22
      2025-03-25 17:02:32,265 [http-nio-1115-exec-5 - http://localhost:1115/xwiki/bin/get/aaa/WebHome?] ERROR o.h.e.j.s.SqlExceptionHelper   - Unknown column 'hidden' in 'where clause'
      2025-03-25 17:02:32,267 [http-nio-1115-exec-5 - http://localhost:1115/xwiki/bin/get/aaa/WebHome?] WARN  .n.ChildDocumentsTreeNodeGroup - Failed to retrieve the children of [wiki:xwiki]. Root cause [SQLSyntaxErrorException: Unknown column 'hidden' in 'where clause'].

      On Jetty/HSQL standalone demo:

      2025-03-25 16:58:32,237 [qtp1306854175-352 - http://localhost:1612/xwiki/bin/get/Pag1/WebHome?] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: -5501, SQLState: 42501
      2025-03-25 16:58:32,237 [qtp1306854175-352 - http://localhost:1612/xwiki/bin/get/Pag1/WebHome?] ERROR o.h.e.j.s.SqlExceptionHelper   - user lacks privilege or object not found: HIDDEN in statement [select xwikispace0_.XWS_REFERENCE as col_0_0_, 0 as col_1_0_ from xwikispace xwikispace0_ left outer join xwikidoc xwikidocum1_ on (xwikidocum1_.XWD_WEB=xwikispace0_.XWS_REFERENCE and xwikidocum1_.XWD_NAME='WebHome' and xwikidocum1_.XWD_TRANSLATION=0) where (xwikispace0_.XWS_PARENT is null) and hidden<>true order by xwikidocum1_.XWD_DATE asc nulls last limit ?]
      2025-03-25 16:58:32,256 [qtp1306854175-352 - http://localhost:1612/xwiki/bin/get/Pag1/WebHome?] WARN  .n.ChildDocumentsTreeNodeGroup - Failed to retrieve the children of [wiki:xwiki]. Root cause [HsqlException: user lacks privilege or object not found: HIDDEN].

       

      Attachments

        Issue Links

          Activity

            People

              mflorea Marius Dumitru Florea
              iandriuta Ilie Andriuta
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: