19 Jan
2008
19 Jan
'08
5:34 a.m.
I have a new install of xwiki enterprise 1.2 on Linux Tomcat 5.5 with MySQL
4.1. I installed the war file and imported the xar file. Things seem to be
generally working but I get an error when I click on the Quick Links ->
What's New.
The page accessed when I click on the link is: xwiki/bin/view/Main/Dashboard
The error displayed is:
Error number 4001 in 4: Error while parsing velocity page Main.Dashboard
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 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.web, doc.name
order by max(ni.date) desc? Wrapped Exception: could not execute query @
Main.Dashboard24,28?
Any ideas what the problem is.
19 Jan
19 Jan
1:12 p.m.
Lou,
From the exception it appears queries are failing at
your database server. Maybe MySql 4.x isn't high enough. I run MySql 5 no problem.
This article http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL may
help. The part aboug the version of MySql is a bit contradictory though;
"Note that XWiki will not work with MySQL version 4.0 or lower as one library
we're using (C3P0) is not compatible with MySQL 4.x."
So either 4.1 is OK, or it isn't according to this....maybe someone who is a bit more
familiar under the hood could clarify.
Regards,
Dean.
________________________________
From: users-bounces(a)xwiki.org on behalf of Lou Parisi
Sent: Sat 19/01/2008 2:34 PM
To: users(a)xwiki.org
Subject: [xwiki-users] Error for What's New
I have a new install of xwiki enterprise 1.2 on Linux Tomcat 5.5 with MySQL
4.1. I installed the war file and imported the xar file. Things seem to be
generally working but I get an error when I click on the Quick Links ->
What's New.
The page accessed when I click on the link is: xwiki/bin/view/Main/Dashboard
The error displayed is:
Error number 4001 in 4: Error while parsing velocity page Main.Dashboard
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 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.web, doc.name
order by max(ni.date) desc? Wrapped Exception: could not execute query @
Main.Dashboard24,28?
Any ideas what the problem is.
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
6:20 p.m.
On Jan 19, 2008, at 1:12 PM, Dean Sellers wrote:
Lou,
From the exception it appears queries are failing at your database
server. Maybe MySql 4.x isn't high enough. I run MySql 5 no problem.
This article http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL
may help. The part aboug the version of MySql is a bit
contradictory though;
"Note that XWiki will not work with MySQL version 4.0 or lower as
one library we're using (C3P0) is not compatible with MySQL 4.x."
So either 4.1 is OK, or it isn't according to this....maybe someone
who is a bit more familiar under the hood could clarify.
I'm not sure either. I wrote this part of the documentation based on
http://jira.xwiki.org/jira/browse/XWIKI-287
.
-Vincent
________________________________
From: users-bounces(a)xwiki.org on behalf of Lou Parisi
Sent: Sat 19/01/2008 2:34 PM
To: users(a)xwiki.org
Subject: [xwiki-users] Error for What's New
I have a new install of xwiki enterprise 1.2 on Linux Tomcat 5.5
with MySQL
4.1. I installed the war file and imported the xar file. Things
seem to be
generally working but I get an error when I click on the Quick Links
->
What's New.
The page accessed when I click on the link is: xwiki/bin/view/Main/
Dashboard
The error displayed is:
Error number 4001 in 4: Error while parsing velocity page
Main.Dashboard
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 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.web,
doc.name
order by max(ni.date) desc? Wrapped Exception: could not execute
query @
Main.Dashboard24,28?
Any ideas what the problem is.
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
<winmail.dat>_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
8:51 p.m.
From the exception it appears queries are failing at
your database
server. Maybe MySql 4.x isn't high enough. I run MySql 5 no problem.
Thanks for the reply. I am running on Centos 4 with the standard RHEL MySQL
4.1 install. I may try to update.
I don't know if this will help. The message in the tomcat log provides more
information but nothing that I could tell that really helps. This is the
first I have worked with xwiki so I am still trying to get grounded. I
don't experience any other issues except this. The standard search box
seems to work OK. Is there something else I can do to validate if MySQL is
working?
13:36:45,567 [http://192.168.1.130:8090/xwiki/bin/view/Main/Dashboard]
[http-8090-Processor12] ERROR log.SimpleLog4JLogSystem - Method
searchDocuments threw exception for reference $xwiki in template
Main.Dashboard at [24,21]
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.web, doc.name,
max(ni.date) from XWikiDocument as doc , XWikiRCSNodeInfo as ni where
doc.id=ni.id.docId and ni.id.version2=1 group by doc.web, doc.name order by
max(ni.date) desc]
Wrapped Exception: could not execute query @ Main.Dashboard[24,28]
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:286
)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.ja
va:203)
at
org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java
:419)
at
org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.ja
va:73)
at
org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirecti
ve.java:125)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:31
8)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.ja
va:238)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.ja
va:152)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java
:95)
at
com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRend
eringEngine.java:251)
at
com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRend
eringEngine.java:176)
at
com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRend
eringEngine.java:145)
at
com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderDocument(DefaultXWiki
RenderingEngine.java:134)
at
com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:407)
at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:371)
at sun.reflect.GeneratedMethodAccessor148.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.invoke(Ub
erspectImpl.java:295)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245
)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.ja
va:203)
at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.jav
a:294)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:31
8)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.ja
va:238)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.ja
va:152)
at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1366)
at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1335)
at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:607)
at sun.reflect.GeneratedMethodAccessor60.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.invoke(Ub
erspectImpl.java:295)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245
)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.ja
va:203)
at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.jav
a:294)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:31
8)
at
org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroPro
xy.java:194)
at
org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroPro
xy.java:194)
at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.jav
a:170)
at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74)
at
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement
.java:88)
at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:31
8)
at
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement
.java:107)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:31
8)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.ja
va:238)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.ja
va:152)
at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1366)
at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1335)
at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:105)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:158)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFi
lter.java:117)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127
)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117
)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processC
onnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:689)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception
while searching documents with SQL [select distinct doc.web, doc.name,
max(ni.date) from XWikiDocument as doc , XWikiRCSNodeInfo as ni where
doc.id=ni.id.docId and ni.id.version2=1 group by doc.web, doc.name order by
max(ni.date) desc]
Wrapped Exception: could not execute query
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNamesInternal(XWikiHi
bernateStore.java:1883)
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateS
tore.java:1849)
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateS
tore.java:2260)
at
com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.jav
a:204)
at com.xpn.xwiki.api.XWiki.searchDocuments(XWiki.java:418)
at sun.reflect.GeneratedMethodAccessor129.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.invoke(Ub
erspectImpl.java:295)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245
)
... 72 more
9:45 p.m.
Lou Parisi wrote:
I get the exact same error with MySQL 4.1. It appears the Table
XWikiDocument doesn't exist.
Successful install with MySQL 5, HSQLDB, and PostgreSQL.
However unable to start the Application with Derby and Oracle10g.
--
Regards
Gabe Wong
NGASI AppServer Manager
JAVA AUTOMATION and SaaS Enablement
<a href=http://www.ngasi.com>http://www.ngasi.com</a>
NEW! 8.0 - Centrally manage multiple physical servers
From the
exception it appears queries are failing at your database
server. Maybe MySql 4.x isn't high enough. I run MySql 5 no problem.
Thanks for the reply. I am running on Centos 4 with the standard RHEL MySQL
4.1 install. I may try to update.
I don't know if this will help. The message in the tomcat log provides more
information but nothing that I could tell that really helps. This is the
first I have worked with xwiki so I am still trying to get grounded. I
don't experience any other issues except this. The standard search box
seems to work OK. Is there something else I can do to validate if MySQL is
working?
13:36:45,567 [http://192.168.1.130:8090/xwiki/bin/view/Main/Dashboard]
[http-8090-Processor12] ERROR log.SimpleLog4JLogSystem - Method
searchDocuments threw exception for reference $xwiki in template
Main.Dashboard at [24,21]
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.web, doc.name,
max(ni.date) from XWikiDocument as doc , XWikiRCSNodeInfo as ni where
doc.id=ni.id.docId and ni.id.version2=1 group by doc.web, doc.name order by
max(ni.date) desc]
Wrapped Exception: could not execute query @ Main.Dashboard[24,28]
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:286
20 Jan
20 Jan
5:55 a.m.
Lou,
From the exception it appears queries are failing at your database
server. Maybe MySql 4.x isn't high enough. I run MySql 5 no problem.
I am running CentOS 4 and upgraded to MySQL 5.0.54 using the centosplus
repository. After this the problem was resolved with no other changes so
the issue appears to have been MySQL 4.1.
Thanks, Lou Parisi
6138
days inactive
6139
days old
5 comments
4 participants
participants (4)
-
Dean Sellers -
Gabe Wong -
Lou Parisi -
Vincent Massol