[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.
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: [email protected] on behalf of Lou Parisi Sent: Sat 19/01/2008 2:34 PM To: [email protected] 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 [email protected] 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.
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: [email protected] on behalf of Lou Parisi Sent: Sat 19/01/2008 2:34 PM To: [email protected] 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 [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
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
Lou Parisi wrote:
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
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
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
participants (4)
-
Dean Sellers -
Gabe Wong -
Lou Parisi -
Vincent Massol