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

WOW... Worked a treat. This is great! I'm brand new to xwiki.. I spent most of yesterday trying to figure out why the activity macro was non present / broken on a fresh stock 2.7 war install. Thank you much Wouter. Perhaps the same is amiss with tagcloud? Its performing the same way as activity did .. ------ thanks kevin.foote On Tue, 22 Feb 2011, Wouter Boasson wrote: -> 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 -> _______________________________________________ -> users mailing list -> users(a)xwiki.org -> http://lists.xwiki.org/mailman/listinfo/users ->