search for certain terms throws exception
e.g., "order by" in mini search creates Error number 4001 in 4: Error while parsing velocity page Main.WebSearch 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 where doc.web<? Wrapped Exception: unexpected char: '%' select distinct doc.web, doc.name, ' order by doc.date from com.xpn.xwiki.doc.XWikiDocument as doc where doc.web<? @ Main.WebSearch92,27? I know everybody is trying to make the version stable, but could somebody explain, how the search algorithm works? Uwe -- View this message in context: http://www.nabble.com/search-for-certain-terms-throws-exception-tf3678295.ht... Sent from the XWiki- Users mailing list archive at Nabble.com.
Yes as it seems, but my question was more general, I used the search engine quite a bit and encountered strange behavior sometimes, which I can't always reproduce. In order to have a more structured approach in using/testing, I like to know how it is supposed to work, because what I perceive strange might be on purpose or I used it other than intended. Here are some observations(using http://www.xwiki.org) - search seems to exclude http://www.xwiki.org/xwiki/bin/view/Main/ in its results - search for 'table' does point to 'MindMapMacro in Code', but there is no such term on the page visible (since it is inline code, but without having edit rights you won't discover this), I would recommend to indicate that in the search results somehow or even better, allow a descriptor, which excludes/includes the code in the search. Is there something available already? - any 'wild card' feature available? or other filter mechanisms? Jan Eldenmalm wrote:
Hi,
It looks like the search string is not escaped for SQL statements.
// Jan
Oova wrote:
e.g., "order by" in mini search creates
Error number 4001 in 4: Error while parsing velocity page Main.WebSearch 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 where doc.web<? Wrapped Exception: unexpected char: '%' select distinct doc.web, doc.name, ' order by doc.date from com.xpn.xwiki.doc.XWikiDocument as doc where doc.web<? @ Main.WebSearch92,27?
I know everybody is trying to make the version stable, but could somebody explain, how the search algorithm works? Uwe
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- View this message in context: http://www.nabble.com/search-for-certain-terms-throws-exception-tf3678295.ht... Sent from the XWiki- Users mailing list archive at Nabble.com.
participants (2)
-
Jan Eldenmalm -
Oova