This issue has been created
There is 1 update.
 
 
XWiki Platform / cid:jira-generated-image-avatar-4923728c-6b9f-4871-ad46-5f32051a0244 XWIKI-23026 Open

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

 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-ce763d14-5a85-448b-902b-63b86fd61438 Ilie Andriuta created this issue on 25/Mar/25 16:07
 
Summary: Error when sorting by "Creation date" or "Last modification date" in Document Tree macro
Issue Type: cid:jira-generated-image-avatar-4923728c-6b9f-4871-ad46-5f32051a0244 Bug
Affects Versions: 17.0.0, 17.2.0-rc-1
Assignee: Unassigned
Attachments: No_Pages_Found.png
Components: Tree
Created: 25/Mar/25 16:07
Environment: Windows 11 Pro, Firefox 136, using an instance of XWiki 17.0.0 on MySQL 9, Tomcat 11.0.5
Priority: cid:jira-generated-image-static-major-3a2c5d38-2571-449f-9f29-3bd96792a46a Major
Reporter: Ilie Andriuta
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].

 

 
 

1 update

 
cid:jira-generated-image-avatar-ce763d14-5a85-448b-902b-63b86fd61438 Changes by Ilie Andriuta on 25/Mar/25 16:09
 
Summary: Error when sorting by "Creation date" or "Last modification date" in Document Tree macro that prevents displaying the documents