29 May
2009
29 May
'09
12:15 p.m.
Hello,
I have recompiled a XWiki 1.9-RC1 for jetty+derby and I have some little
problems and I prefer asking before thinking:
- I don't see the icons in the administration page and the last item
"OpenOffice Importer" seems badly HTML formed and displays
"
http://www.mandubian.org/xwiki/bin/download/XWiki/OfficeImporterAdmin/icon.…)
no-repeat;">OpenOffice Server"
Please see the attached screenshot
- I can't view Blog.WebHome because there is some bad SQL for Derby
apparently
Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception
while searching documents with SQL [select distinct doc.space, doc.name,
publishDate.value from XWikiDocument as doc , DBStringListProperty as
categories join categories.list as category, BaseObject obj, IntegerProperty
isPublished, IntegerProperty hidden, DateProperty publishDate
where (doc.hidden <> true or doc.hidden is null) and doc.fullName <>
'Blog.BlogPostTemplate' and
obj.name = doc.fullName and obj.className = 'Blog.BlogPostClass' and
publishDate.id.id = obj.id and publishDate.id.name = 'publishDate' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name = 'hidden' and
(doc.creator = 'XWiki.Admin' or (isPublished.value = 1 and
hidden.value = 0)) and obj.id = categories.id.id and
categories.id.name='category'
and category in ('Blog.News') order by publishDate.value desc]
Wrapped Exception: could not execute query
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNamesInternal(XWikiHibernateStore.java:2302)
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:2266)
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:2747)
at
com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:267)
at com.xpn.xwiki.api.XWiki.searchDocuments(XWiki.java:406)
at sun.reflect.GeneratedMethodAccessor325.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389)
at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270)
... 154 more
2009-05-29 12:01:25,585 [http://localhost:8080/xwiki/bin/view/Blog/]
[1857040122@qtp0-6] WARN util.JDBCExceptionReporter - SQL Error:
20000, SQLState: XJ061
2009-05-29 12:01:25,585 [http://localhost:8080/xwiki/bin/view/Blog/]
[1857040122@qtp0-6] ERROR util.JDBCExceptionReporter - The 'absolute()'
method is only allowed on scroll cursors. [ERROR] Exception in macro
#getPagedBlogEntries at Blog.WebHome[line 141, column 5]
[ERROR] Exception in macro #getBlogEntries at Blog.WebHome[line 17, column
3]
[ERROR] Exception in macro #printBlog at Blog.WebHome[line 7, column 3]
org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with
id [Blog.WebHome]
any idea?
Pascal
