(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
