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 [email protected]
-> mo - th
->
->
-> Disclaimer RIVM
-> _______________________________________________
-> users mailing list
-> [email protected]
-> http://lists.xwiki.org/mailman/listinfo/users
->
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users
