Details
-
Bug
-
Resolution: Duplicate
-
Minor
-
None
-
11.5-rc-1, 11.5
-
None
-
None
-
Windows 10 Pro 64 bit, IE11, using a local instance of XWiki 11.5, on MySQL 5.7
-
Unknown
-
Description
STEPS TO REPRODUCE
- Go to Drawer > Wiki Index
- Observe the XWiki console
EXPECTED RESULTS
No warnings/errors are displayed.
ACTUAL RESULTS
Some warnings are displayed related to deprecated usage of HQL parameters:
2019-06-26 15:59:37,421 [http://localhost:1151/xwiki/bin/get/WikiManager/WikisLiveTableResults?outputSyntax=plain&transprefix=platform.wiki.browse.&classname=XWiki.XWikiServerClass&collist=wikiprettyname%2Cdescription%2Cowner%2Cdoc.creationDate%2CmembershipType&queryFilters=currentlanguage%2Chidden&offset=1&limit=10&reqNo=1&sort=wikiprettyname&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 elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj , StringProperty prop_wikiprettyname where (doc.hidden <> true or doc.hidden is null) and (tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = ? and doc.fullName <> ? and obj.id=prop_wikiprettyname.id.id and prop_wikiprettyname.name = ? and doc.name IN ('XWikiServerSubwikiglobal','XWikiServerXwiki'))] has been converted to [select elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj , StringProperty prop_wikiprettyname where (doc.hidden <> true or doc.hidden is null) and (tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = ?1 and doc.fullName <> ?2 and obj.id=prop_wikiprettyname.id.id and prop_wikiprettyname.name = ?3 and doc.name IN ('XWikiServerSubwikiglobal','XWikiServerXwiki'))] 2019-06-26 15:59:37,440 [http://localhost:1151/xwiki/bin/get/WikiManager/WikisLiveTableResults?outputSyntax=plain&transprefix=platform.wiki.browse.&classname=XWiki.XWikiServerClass&collist=wikiprettyname%2Cdescription%2Cowner%2Cdoc.creationDate%2CmembershipType&queryFilters=currentlanguage%2Chidden&offset=1&limit=10&reqNo=1&sort=wikiprettyname&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 elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj where (doc.hidden <> true or doc.hidden is null) and (tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = ? and doc.fullName <> ? and doc.name IN ('XWikiServerSubwikiglobal','XWikiServerXwiki'))] has been converted to [select elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj where (doc.hidden <> true or doc.hidden is null) and (tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = ?1 and doc.fullName <> ?2 and doc.name IN ('XWikiServerSubwikiglobal','XWikiServerXwiki'))] 2019-06-26 15:59:37,451 [http://localhost:1151/xwiki/bin/get/WikiManager/WikisLiveTableResults?outputSyntax=plain&transprefix=platform.wiki.browse.&classname=XWiki.XWikiServerClass&collist=wikiprettyname%2Cdescription%2Cowner%2Cdoc.creationDate%2CmembershipType&queryFilters=currentlanguage%2Chidden&offset=1&limit=10&reqNo=1&sort=wikiprettyname&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 doc.fullName from XWikiDocument doc , BaseObject as obj , StringProperty prop_wikiprettyname where (doc.language is null or doc.language = '' or doc.language = 'en') and (obj.name=doc.fullName and obj.className = ? and doc.fullName <> ? and obj.id=prop_wikiprettyname.id.id and prop_wikiprettyname.name = ? and doc.name IN ('XWikiServerSubwikiglobal','XWikiServerXwiki')) GROUP BY doc.fullName order by MAX(prop_wikiprettyname.value) asc] has been converted to [select doc.fullName from XWikiDocument doc , BaseObject as obj , StringProperty prop_wikiprettyname where (doc.language is null or doc.language = '' or doc.language = 'en') and (obj.name=doc.fullName and obj.className = ?1 and doc.fullName <> ?2 and obj.id=prop_wikiprettyname.id.id and prop_wikiprettyname.name = ?3 and doc.name IN ('XWikiServerSubwikiglobal','XWikiServerXwiki')) GROUP BY doc.fullName order by MAX(prop_wikiprettyname.value) asc] 2019-06-26 15:59:37,466 [http://localhost:1151/xwiki/bin/get/WikiManager/WikisLiveTableResults?outputSyntax=plain&transprefix=platform.wiki.browse.&classname=XWiki.XWikiServerClass&collist=wikiprettyname%2Cdescription%2Cowner%2Cdoc.creationDate%2CmembershipType&queryFilters=currentlanguage%2Chidden&offset=1&limit=10&reqNo=1&sort=wikiprettyname&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(doc.fullName) from XWikiDocument doc , BaseObject as obj , StringProperty prop_wikiprettyname where obj.name=doc.fullName and obj.className = ? and doc.fullName <> ? and obj.id=prop_wikiprettyname.id.id and prop_wikiprettyname.name = ? and doc.name IN ('XWikiServerSubwikiglobal','XWikiServerXwiki') ] has been converted to [select count(doc.fullName) from XWikiDocument doc , BaseObject as obj , StringProperty prop_wikiprettyname where obj.name=doc.fullName and obj.className = ?1 and doc.fullName <> ?2 and obj.id=prop_wikiprettyname.id.id and prop_wikiprettyname.name = ?3 and doc.name IN ('XWikiServerSubwikiglobal','XWikiServerXwiki') ]
The warnings are displayed in console every time the user lands on WikiManager page and can fill up the logs, taking up space.
The issue could not be reproduced in XWiki 11.4.
Attachments
Issue Links
- duplicates
-
XWIKI-16536 Convert livetable queries to not use old ? based hql parameters
- Closed
- relates to
-
XWIKI-17018 Warnings for deprecated usage of parameters on Deleted Pages and Deleted Attachments livetables
- Closed
-
XWIKI-17065 Warnings for deprecated usage of HQL ordinal parameters when removing a deleted attachment
- Closed
-
XWIKI-17072 Warnings for deprecated usage of HQL ordinal parameters when applying a date filter on Deleted Attachments livetable
- Closed