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
Show replies by date