> 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 _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
