Oops! Where in the hell I'd read 1.7.3 :-) Thanks, Vincent! I keep looking for more time to keep track of this great software! Thanks for your work!
Ricardo Vincent Massol wrote: > 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 > > > -- Ricardo RodrÃguez Your EPEC Network ICT Team _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
