[xwiki-users] MIT Simile Widgets (spiffy JS Timeline/Timeplot/Timegrid) for Xwiki?
Has anybody integrated any of MIT's open source "Project Simile" ( http://code.google.com/p/simile-widgets/ ) JS widgetry into Xwiki? For example their http://simile.mit.edu/timeline/ http://simile.mit.edu/timeplot/ or http://simile.mit.edu/timegrid/ ?? This has been discussed previously on these lists: http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page... http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page... http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page... http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page... http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page... Unfortunately, all the emails mention example links that no longer exist, so there's no obvious Xwiki examples providing Simile widgetry in Xwiki ... FYI, Other environments have integrated some of the MIT functionality: http://drupal.org/project/timeline http://drupal.org/project/exhibit http://simile.mit.edu/wiki/Wibbit Niels http://nielsmayer.com
Hi, I've played quite a lot with Simile Timeline in the past. I've made a little snippet showing last modifications within the wiki on code.xwiki.org : http://code.xwiki.org/xwiki/bin/view/Snippets/TimelineSnippet In action: http://incubator.myxwiki.org/xwiki/bin/view/Main/Timeline JV. On Thu, Jan 22, 2009 at 8:35 PM, Niels Mayer <[email protected]> wrote:
Has anybody integrated any of MIT's open source "Project Simile" ( http://code.google.com/p/simile-widgets/ ) JS widgetry into Xwiki? For example their http://simile.mit.edu/timeline/ http://simile.mit.edu/timeplot/ or http://simile.mit.edu/timegrid/ ??
This has been discussed previously on these lists: http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page... http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page... http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page... http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page... http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page...
Unfortunately, all the emails mention example links that no longer exist, so there's no obvious Xwiki examples providing Simile widgetry in Xwiki ...
FYI, Other environments have integrated some of the MIT functionality: http://drupal.org/project/timeline http://drupal.org/project/exhibit http://simile.mit.edu/wiki/Wibbit
Niels http://nielsmayer.com _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
FYI, I've updated and commented the Timeline example ( http://code.xwiki.org/xwiki/bin/view/Snippets/TimelineSnippet ) in preparation of my nefarious deconstruction of the widget into a novel interface for a totally different form of usage ... working example: http://nielsmayer.com/xwiki/bin/view/Timeline/TL2 sources: http://nielsmayer.com/xwiki/bin/view/Timeline/TL2?viewer=code & http://nielsmayer.com/xwiki/bin/view/Timeline/ChangesList?viewer=code Next steps is to remove this constraint (suggested in http://code.xwiki.org/xwiki/bin/view/Snippets/TimelineSnippet ). If you forget to do this, nothing works; yet, adding it is quite annoying and shouldn't be needed:
Prerequisites
You must add this line:
<script src="http://simile.mit.edu/timeline/api/timeline-api.js" type="text/javascript"></script>
At the bottom of the "HTTP Meta Information" field in *Administration* > * Presentation*.
Seems like the following links are good starting points for a solution to the above issue: Installing MIT Simile's Timeline locally (w/ Rails integration) | Ryan Kanno: The diary of an Enginerd in Hawaii<http://blog.localkinegrinds.com/2007/11/06/installing-mit-similes-timeline-locally-w-rails-integration/>& Message <http://simile.mit.edu/mail/ReadMsg?listId=10&msgId=19202> & Message<http://simile.mit.edu/mail/ReadMsg?listId=10&msgId=19199>... This entails installing a local copy of the timeline javascript and modifying a few lines of source. Othewise, with the existing solution, you're stuck with loading the simile javascript for any page on your site, slowing down the initial load time even more with yet more global javascript that never gets called in most situations. (Alternately, perhaps catenating all the timeline javascript and shoving it into a single xwiki doc or template that gets included only in a timeline-using app). -- Niels http://nielsmayer.com PS: I think it would be interesting to put extra attributes on certain sets of documents, and then sql-query for those documents with those attributes and present them in the timeline. That way, for example, one could render a sequence of steps over time, where each step is a xwiki doc. There's no reason why the horizontal axis needs to represent discrete time. It can represent any monotonically increasing sequence. For example, editing the sequence of steps and concurrent streaming media for purposes of making a movie or real-time presentation composed from wiki components. PPS: http://en.wikibooks.org/wiki/XQuery/DBpedia_with_SPARQL_and_Simile_Timeline_... another interesting application of the Timeline widget. It would be interesting if xwiki could support SPARQL ( http://www.w3.org/TR/rdf-sparql-XMLres/ ). The timeline widget doesn't necessarily need to be used as a timeline... you could also use it to present complex database result sets laid out in two-dimensions, for example (e.g. search hits presented over topic and confidence in matching.). On Thu, Jan 22, 2009 at 1:44 PM, Jean-Vincent Drean <[email protected]>wrote:
Hi,
I've played quite a lot with Simile Timeline in the past. I've made a little snippet showing last modifications within the wiki on code.xwiki.org : http://code.xwiki.org/xwiki/bin/view/Snippets/TimelineSnippet
In action: http://incubator.myxwiki.org/xwiki/bin/view/Main/Timeline
JV.
On Thu, Jan 22, 2009 at 8:35 PM, Niels Mayer <[email protected]> wrote:
Has anybody integrated any of MIT's open source "Project Simile" ( http://code.google.com/p/simile-widgets/ ) JS widgetry into Xwiki? For example their http://simile.mit.edu/timeline/ http://simile.mit.edu/timeplot/ or http://simile.mit.edu/timegrid/ ??
This has been discussed previously on these lists:
http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page...
http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page...
http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page...
http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page...
http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page...
Unfortunately, all the emails mention example links that no longer exist,
so
there's no obvious Xwiki examples providing Simile widgetry in Xwiki ...
FYI, Other environments have integrated some of the MIT functionality: http://drupal.org/project/timeline http://drupal.org/project/exhibit http://simile.mit.edu/wiki/Wibbit
Niels http://nielsmayer.com ______________________________
Hi, Please, must I expect that the timeline snippet or the modifications proposed by Niels work fine in a 1.3.8295 XWiki Enterprise. Sorry, I now that I must update this server... Thanks for your help, Ricardo Niels Mayer wrote:
FYI, I've updated and commented the Timeline example ( http://code.xwiki.org/xwiki/bin/view/Snippets/TimelineSnippet ) in preparation of my nefarious deconstruction of the widget into a novel interface for a totally different form of usage ...
working example: http://nielsmayer.com/xwiki/bin/view/Timeline/TL2
sources: http://nielsmayer.com/xwiki/bin/view/Timeline/TL2?viewer=code & http://nielsmayer.com/xwiki/bin/view/Timeline/ChangesList?viewer=code
Next steps is to remove this constraint (suggested in http://code.xwiki.org/xwiki/bin/view/Snippets/TimelineSnippet ). If you forget to do this, nothing works; yet, adding it is quite annoying and shouldn't be needed:
Prerequisites
You must add this line:
<script src="http://simile.mit.edu/timeline/api/timeline-api.js" type="text/javascript"></script>
At the bottom of the "HTTP Meta Information" field in *Administration* > * Presentation*.
Seems like the following links are good starting points for a solution to the above issue: Installing MIT Simile's Timeline locally (w/ Rails integration) | Ryan Kanno: The diary of an Enginerd in Hawaii<http://blog.localkinegrinds.com/2007/11/06/installing-mit-similes-timeline-locally-w-rails-integration/>& Message <http://simile.mit.edu/mail/ReadMsg?listId=10&msgId=19202> & Message<http://simile.mit.edu/mail/ReadMsg?listId=10&msgId=19199>...
This entails installing a local copy of the timeline javascript and modifying a few lines of source. Othewise, with the existing solution, you're stuck with loading the simile javascript for any page on your site, slowing down the initial load time even more with yet more global javascript that never gets called in most situations. (Alternately, perhaps catenating all the timeline javascript and shoving it into a single xwiki doc or template that gets included only in a timeline-using app).
-- Niels http://nielsmayer.com
PS: I think it would be interesting to put extra attributes on certain sets of documents, and then sql-query for those documents with those attributes and present them in the timeline. That way, for example, one could render a sequence of steps over time, where each step is a xwiki doc. There's no reason why the horizontal axis needs to represent discrete time. It can represent any monotonically increasing sequence. For example, editing the sequence of steps and concurrent streaming media for purposes of making a movie or real-time presentation composed from wiki components.
PPS: http://en.wikibooks.org/wiki/XQuery/DBpedia_with_SPARQL_and_Simile_Timeline_... another interesting application of the Timeline widget. It would be interesting if xwiki could support SPARQL ( http://www.w3.org/TR/rdf-sparql-XMLres/ ). The timeline widget doesn't necessarily need to be used as a timeline... you could also use it to present complex database result sets laid out in two-dimensions, for example (e.g. search hits presented over topic and confidence in matching.).
On Thu, Jan 22, 2009 at 1:44 PM, Jean-Vincent Drean <[email protected]>wrote:
Hi,
I've played quite a lot with Simile Timeline in the past. I've made a little snippet showing last modifications within the wiki on code.xwiki.org : http://code.xwiki.org/xwiki/bin/view/Snippets/TimelineSnippet
In action: http://incubator.myxwiki.org/xwiki/bin/view/Main/Timeline
JV.
On Thu, Jan 22, 2009 at 8:35 PM, Niels Mayer <[email protected]> wrote:
Has anybody integrated any of MIT's open source "Project Simile" ( http://code.google.com/p/simile-widgets/ ) JS widgetry into Xwiki? For example their http://simile.mit.edu/timeline/ http://simile.mit.edu/timeplot/ or http://simile.mit.edu/timegrid/ ??
This has been discussed previously on these lists:
http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page...
http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page...
http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page...
http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page...
http://markmail.org/message/bds6fein6w4ftqot#query:MIT%20Simile%20Xwiki+page...
Unfortunately, all the emails mention example links that no longer exist,
so
there's no obvious Xwiki examples providing Simile widgetry in Xwiki ...
FYI, Other environments have integrated some of the MIT functionality: http://drupal.org/project/timeline http://drupal.org/project/exhibit http://simile.mit.edu/wiki/Wibbit
Niels http://nielsmayer.com ______________________________
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Ricardo Rodríguez Your EPEC Network ICT Team
On Thu, Feb 5, 2009 at 3:08 PM, [Ricardo Rodriguez] Your EPEC Network ICT Team <[email protected]> wrote:
Please, must I expect that the timeline snippet or the modifications proposed by Niels work fine in a 1.3.8295 XWiki Enterprise. Sorry, I now that I must update this server...
Did you remember to do this: ................... <script src="http://simile.mit.edu/timeline/api/timeline-api.js" type="text/javascript"></script> At the bottom of the "HTTP Meta Information" field in *Administration* > * Presentation*. .................. -- Niels http://nielsmayer.com
Hi Niels, Niels Mayer wrote:
Did you remember to do this: ................... <script src="http://simile.mit.edu/timeline/api/timeline-api.js" type="text/javascript"></script>
At the bottom of the "HTTP Meta Information" field in *Administration* > * Presentation*. ..................
Thanks for your help! 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! Cheers, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team
(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!
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+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
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%2...
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%2... @ Timeline.ChangesList 17,45?<http://xgmx.environmentalchange.net/xwiki/bin/edit/Timeline/17%2C45?parent=T...
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%2...
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!
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%2...
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%2...
@ Timeline.ChangesList
17,45?<http://xgmx.environmentalchange.net/xwiki/bin/edit/Timeline/17%2C45?parent=T...
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%2...
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
participants (4)
-
[Ricardo Rodriguez] Your EPEC Network ICT Team -
Jean-Vincent Drean -
Niels Mayer -
Vincent Massol