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…
>>
>>> 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…
>>
>>> @ 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