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…
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 <webmaster(a)environmentalchange.net> 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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users