Details
-
Bug
-
Resolution: Unresolved
-
Major
-
17.0.0, 17.2.0-rc-1
-
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
- Edit a page and insert the Page Tree macro
- Under 'Sort pages by' section, in the drop-down, select "Creation date" or "Last modification date"
- Click "Submit" button
- 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
- relates to
-
XWIKI-21155 Allow sorting by specified field for Document Tree macro
-
- Closed
-