Hi When I try to convert BlogCode (at least that is what I think) I get this strange error:
Caused by: org.apache.velocity.exception.MethodInvocationException: 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 [select distinct doc.space, doc.name, doc.name and isPublished.value = 1 and hidden.value <> 1 and isPublished.value = 0 order by publishDate.value from XWikiDocument as doc , BaseObject obj where (doc.hidden <> true or doc.hidden is null) and obj.name = doc.fullName and obj.className = 'Blog.CategoryClass' order by doc.name and isPublished.value = 1 and hidden.value <> 1 and isPublished.value = 0 order by publishDate.value desc] Wrapped Exception: unexpected token: from near line 1, column 148 [select distinct doc.space, doc.name, doc.name and isPublished.value = 1 and hidden.value <> 1 and isPublished.value = 0 order by publishDate.value from com.xpn.xwiki.doc.XWikiDocument as doc , com.xpn.xwiki.objects.BaseObject obj where (doc.hidden <> true or doc.hidden is null) and obj.name = doc.fullName and obj.className = 'Blog.CategoryClass' order by doc.name and isPublished.value = 1 and hidden.value <> 1 and isPublished.value = 0 order by publishDate.value desc] at Blog.Test 2b[line 4, column 35] It seems for whatever reason XWiki is mixing up some SQL statements. Any ideas how I can figure out where this happens (the stacktrace is not helpful) and then what is going wrong. I personally think that somehow the velocity template is messed up but I could be completely wrong. Thank you - Andy Schaefer _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
