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

Warnings related to deprecated usage of parameters when accessing WikiManager page

    XMLWordPrintable

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

      1. Go to Drawer > Wiki Index
      2. 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

          Activity

            People

              tmortagne Thomas Mortagne
              iandriuta Ilie Andriuta
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: