Hi Ricardo, On Feb 6, 2009, at 11:45 PM, [Ricardo Rodriguez] Your EPEC Network ICT Team wrote:
> 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. There's no such thing as XE 1.7.3 yet :) There's a 1.7.1 and maybe there'll be a 1.7.2 (not planned yet). Since XE 1.8 final is planned for early March I'd suggest you move to XE 1.8RC1 or RC2 at that time. Thanks -Vincent > 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
