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