Topics in forums with dot in the name are not listed properly - on mysql

[lucaa]

This is issue https://jira.xwiki.org/browse/XWIKI-14126 applied to queries in the forum application.
The fix is to use the .literal().anyChars() API for the queries in the forum, as documented here https://extensions.xwiki.org/xwiki/bin/view/Extension/Query%20Module#HPerformingQueries (section 'Binding a LIKE value').
However, this will not be compatible with versions of XWiki under 8.4.5 and in those cases, this solution needs to be applied: https://extensions.xwiki.org/xwiki/bin/view/Extension/Query%20Module#HFindingpagesundernestedpages .

The modifications need to be done in 4 places, at least:
https://github.com/xwikisas/application-forum/blob/master/application-forum-ui/src/main/resources/ForumCode/ForumSheet.xml#L61
https://github.com/xwikisas/application-forum/blob/master/application-forum-ui/src/main/resources/ForumCode/Macros.xml#L410
https://github.com/xwikisas/application-forum/blob/master/application-forum-ui/src/main/resources/ForumCode/Macros.xml#L436
https://github.com/xwikisas/application-forum/blob/master/application-forum-ui/src/main/resources/ForumCode/Macros.xml#L444

[lucaa]

I think this issue also impacts the display of the answers in topics that have special character in the name - the answers don't get displayed.

[lucaa]

The fix for the display of the answers (mentioned above) would be here https://github.com/xwikisas/application-forum/blob/master/application-forum-ui/src/main/resources/ForumCode/Macros.xml#L843 and it's the same fix as for the other places.

[lucaa]

Here is a zip with the fixes for this issue (the 5 places I indicated in the comments above), based on the 2.5.4 version of the forum application.
The fixes are for the version 9.11.3 of XWiki (so using the 8.4.5+ technique).

ForumFixSpecialCharacters_13_12_2018_Issue22.zip

[acotiuga]

Thanks @lucaa for you help!