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+doc.web%2C+doc.name%2C+max%28ni.date%29+from+XWikiDocument+as+doc+%2C+XWikiRCSNodeInfo+as+ni+where+doc.id%3Dni.id.docId+and+ni.id.version2%3D1+group+by+doc.space%2C+doc.name+order+by+max%28ni/date%29+desc?parent=Timeline.ChangesList>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+doc.web%2C+doc.name%2C+max%28ni.date%29+from+com.xpn.xwiki.doc.XWikiDocument+as+doc+%2C+com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo+as+ni+where+doc.id%3Dni.id.docId+and+ni.id.version2%3D1+group+by+doc.space%2C+doc.name+order+by+max%28ni/date%29+desc?parent=Timeline.ChangesList>@ >> Timeline.ChangesList >> 17,45?<http://xgmx.environmentalchange.net/xwiki/bin/edit/Timeline/17%2C45?parent=Timeline.ChangesList> >> > > 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+doc.web%2C+doc.name%2C+max%28ni.date%29+from+XWikiDocument+as+doc+%2C+XWikiRCSNodeInfo+as+ni+where+doc.id%3Dni.id.docId+and+ni.id.version2%3D1+group+by+doc.space%2C+doc.name+order+by+max%28ni/date%29+desc?parent=Timeline.ChangesList> >> >> > > 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 <[email protected]> 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! >> >> >> > _______________________________________________ > users mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/users > > > -- Ricardo RodrÃguez Your EPEC Network ICT Team _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
