[xwiki-users] bug in tag recent changes, and solution

Hi, I discovered a hard to find HQL/SQL error related to the new ActivityStream (V2.6.1). Sometimes the activitystream did not display at all, with loads of threads dumped in the log. The problem appeared to be related to specific documents, having a ' (single quote) in the document's name. Besides this, the problem only appears when displaying the pages belonging to a specific tag. More specifically, when the automagically crafted HQL to select the document contains these specific names, so the problem did not show up when displaying the Activity for the entire wiki, for example. Took me hours to find and solve it, but it's a matter of minutes to repair it. The solution: escape page names. In the Activity page, edit object mode, go to the Activity Macro (something like <mywiki>/bin/edit/Main/Activity?editor=object) look for the macro code, and change line 168: #set($filterClause = $filterClause + "'" + $colValue.replaceAll("\'", "\'\'") + "'" ) This effectively replaces a single quote with two single quotes, which is the proper way of escaping for HQL. But, altogether, I'd love it when all these obviously problematic characters were simply banned out from the technical/URL document name, this always generates hard to find problems. Good luck, Wouter Wouter Boasson (MSc) Geo-IT Research and Coordination RIVM - National Institute for Public Health and the Environment Expertise Centre for Methodology and Information Services Contact information ----------------------- RIVM VenZ/EMI, Pb 86 t.a.v. dhr. Drs. Wouter Boasson Postbus 1 3720 BA Bilthoven T +31(0)302748518 F +31(0)302744456 E wouter.boasson(a)rivm.nl mo - th Disclaimer RIVM