Re: [xwiki-users] MIT Simile Widgets (spiffy JS Timeline/Timeplot/Timegrid) for Xwiki?

Hi Niels, Thank you for your insight. I am almost sure that doc names and spaces have not inappropriate characters, but I can not be so sure about titles. My first trial following your message has been to test your code in a XWIKI ENTERPRISE 1.7-MILESTONE-3.14362 It worked without a glitch. Of course this not solve the doubt if the reason for the failure is in the contents. I think that is time to face the update process with this server and eliminate some possible causes. I need to reach the end of February with this installation untouched. I will be move then to XE 1.7.3.

I will be back ASAP! Best, Ricardo Niels Mayer wrote: > (1) check to see whether the affected tables and queries in the > timeline > example are > actually *in* your database and that the schema hasn't changed (any > xwiki > experts feel free to > chime in on whether this is or isn't the problem -- tho I'm pretty > sure that > doc.space was in 1.3...). > > ... and if it's not a db schema issue ... > > (2) It also might be a variant of the problem i found with > inappropriate > characters in documents, spaces and "subject/titles" thereof. > Your error is: > > > >> RCSNode Info as ni where doc.id=ni.id.doc Id and ni.id.version2=1 >> group by >> doc.space, doc.name order by max(ni.date) desc?<http://xgmx.environmentalchange.net/xwiki/bin/edit/select+distinct… >> >>> Wrapped Exception: could not resolve property: space of: >>> >> com.xpn.xwiki.doc.XWikiDocument web, doc.name, max(ni.date) from >> com.xpn.xwiki.doc.XWiki Document as doc , >> com.xpn.xwiki.doc.rcs.XWiki >> RCSNode Info as ni where doc.id=ni.id.doc Id and ni.id.version2=1 >> group by >> doc.space, doc.name order by max(ni.date) desc?<http://xgmx.environmentalchange.net/xwiki/bin/edit/select+distinct… >> >>> @ Timeline.ChangesList >>> >> 17,45?<http://xgmx.environmentalchange.net/xwiki/bin/edit/Timeline/17%2C… >> > From: > > > >> Error number 4001 in 4: Error while parsing velocity page >> Timeline.ChangesList Wrapped Exception: Invocation of method >> 'searchDocuments' in class com.xpn.xwiki.api.XWiki threw exception >> com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception >> while >> searching documents with SQL >> <http://xgmx.environmentalchange.net/xwiki/bin/view/Timeline/ChangesList >> >>> web, >>> >> doc.name, max(ni.date) from XWiki Document as doc , XWiki RCSNode >> Info as ni >> where doc.id=ni.id.doc Id and ni.id.version2=1 group by doc.space, >> doc.name >> order by max(ni.date) desc?<http://xgmx.environmentalchange.net/xwiki/bin/edit/select+distinct… >> >> > Do any of your spaces (or document names) have inappropriate > characters, > like `` ' '' or `` " ' > > For some reason these don't necessarily get noticed (to the point of > creating problems that pop up backtraces), until you run the > timeline: > http://jira.xwiki.org/jira/browse/XE-376 ( characters entered as > document > title must be escaped or a cascade of bugs occur ). Edit/save the > offending > document even "fixes" em -- with lossage of all characters after > first ' " ' > > And all it takes is one document with one such character to make the > Timeline blow up. The extra quotes could be in some innocent > document made > years ago... but if you accidentally "quoted a phrase" in a subject > somewhere it triggers the error. Solution: use two single quotes, > e.g. > ``quoted a phrase'' ... > > I'm Stating #2 on remote chance my intuituion on this is correct. I > didn't > spend much time looking at your site to find such docs, etc...just > got the > error backtrace and noticed the oddness of it. > > Niels > http://nielsmayer.com > > On Fri, Feb 6, 2009 at 1:41 AM, [Ricardo Rodriguez] Your EPEC > Network ICT > Team &lt;webmaster(a)environmentalchange.net&gt; wrote: > > > >> Yeap, I did that, restarted Tomcat (just in case!) and saved the >> page as >> admin. >> >> Here the error: >> >> http://xgmx.environmentalchange.net/xwiki/bin/view/Timeline/ChangesList >> >> Any input will be welcome! >>