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

Wiki index shows double entries or performs erratic when descriptors use aliases

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • None
    • 9.7, 10.4
    • Query
    • None
    • Unknown

    Description

      Because of XWIKI-15595, the wiki index can show duplicated and incomplete entries when at least one descriptor has set up an alias.

      Until XWIKI-15595, a possible solution (tried with good results) is to update the Wiki index query to use an explicit "SELECT DISTINCT" clause instead of relying on the currently problematic "unique" query filter.

      This implies updating WikiManager/WikisLiveTableResultsMacros from:

      #set($sql = "$countSql $!{orderSql}")

      to

      #set($sql = "select distinct doc.fullName from XWikiDocument doc $countSql $!{orderSql}")

      Attachments

        Issue Links

          depends on

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-15595 Unique Query Filter not working on query.execute() while working on query.count()

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-16011 Possible missing and duplicated wikis in the wiki index

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

              tmortagne Thomas Mortagne
              enygma Eduard Moraru
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: