Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 11.7-rc-1, 11.10.2
-
Component/s: None
-
Labels:None
-
Environment:Windows 10 Pro 64 bit, Firefox 72, using a local instance of XWiki 11.10.2 on Oracle 19c
-
Difficulty:Unknown
-
Documentation:N/A
-
Documentation in Release Notes:N/A
-
Similar issues:
Description
STEPS TO REPRODUCE
- Delete some pages
- Delete some attachments
- Go to Drawer > Page Index > Deleted Pages tab
- Click on 'Deleted on' filter and select 'Yesterday' for ex.
- Go to Deleted Attachments tabĀ and select 'Yesterday' for ex. as well
- Observe the XWiki console
EXPECTED RESULTS
No warnings/errors are displayed.
ACTUAL RESULTS
Some warnings are displayed related to deprecated usage of HQL parameters every time a date filter is applied:
For Deleted Pages:
2020-02-03 12:24:24,868 [http://localhost:1110/xwiki/bin/view/XWiki/DeletedDocumentsJSON?list=1&xpage=plain&outputSyntax=plain&offset=1&limit=15&reqNo=4&ddoc.date=1580594400000-1580680799999&&sort=ddoc.fullName&dir=asc] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (`?`); use JPA-style ordinal parameters (e.g., `?1`) instead. Query [select ddoc.id from XWikiDeletedDocument as ddoc where 1=1 and ddoc.date between ? and ? order by ddoc.fullName asc] has been converted to [select ddoc.id from XWikiDeletedDocument as ddoc where 1=1 and ddoc.date between ?1 and ?2 order by ddoc.fullName asc] 2020-02-03 12:24:24,871 [http://localhost:1110/xwiki/bin/view/XWiki/DeletedDocumentsJSON?list=1&xpage=plain&outputSyntax=plain&offset=1&limit=15&reqNo=4&ddoc.date=1580594400000-1580680799999&&sort=ddoc.fullName&dir=asc] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (`?`); use JPA-style ordinal parameters (e.g., `?1`) instead. Query [select count(*) from XWikiDeletedDocument as ddoc where 1=1 and ddoc.date between ? and ? ] has been converted to [select count(*) from XWikiDeletedDocument as ddoc where 1=1 and ddoc.date between ?1 and ?2 ]
For Deleted Attachments:
2020-02-03 12:24:24,868 [http://localhost:1110/xwiki/bin/view/XWiki/DeletedDocumentsJSON?list=1&xpage=plain&outputSyntax=plain&offset=1&limit=15&reqNo=4&ddoc.date=1580594400000-1580680799999&&sort=ddoc.fullName&dir=asc] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (`?`); use JPA-style ordinal parameters (e.g., `?1`) instead. Query [select ddoc.id from XWikiDeletedDocument as ddoc where 1=1 and ddoc.date between ? and ? order by ddoc.fullName asc] has been converted to [select ddoc.id from XWikiDeletedDocument as ddoc where 1=1 and ddoc.date between ?1 and ?2 order by ddoc.fullName asc] 2020-02-03 12:24:24,871 [http://localhost:1110/xwiki/bin/view/XWiki/DeletedDocumentsJSON?list=1&xpage=plain&outputSyntax=plain&offset=1&limit=15&reqNo=4&ddoc.date=1580594400000-1580680799999&&sort=ddoc.fullName&dir=asc] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (`?`); use JPA-style ordinal parameters (e.g., `?1`) instead. Query [select count(*) from XWikiDeletedDocument as ddoc where 1=1 and ddoc.date between ? and ? ] has been converted to [select count(*) from XWikiDeletedDocument as ddoc where 1=1 and ddoc.date between ?1 and ?2 ]
Attachments
Issue Links
- is related to
-
XWIKI-16534 Warnings related to deprecated usage of parameters when accessing WikiManager page
-
- Closed
-
-
XWIKI-16536 Convert livetable queries to not use old ? based hql parameters
-
- Closed
-
- relates to
-
XWIKI-17065 Warnings for deprecated usage of HQL ordinal parameters when removing a deleted attachment
-
- Closed
-