Ok, i found the log file.. i found these errors in the log file 2010-01-07 18:05:42,972 [http://localhost:8080/xwiki/bin/view/Main/] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02
2010-01-07 18:05:42,972 [http://localhost:8080/xwiki/bin/view/Main/] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidbversion' doesn't exist 2010-01-07 18:05:42,988 [http://localhost:8080/xwiki/bin/view/Main/] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 2010-01-07 18:05:56,691 [http://localhost:8080/xwiki/bin/view/Main/] WARN rnal.DefaultObservationManager - The [com.xpn.xwiki.store.XWikiCacheStore] listener has overwritten a previously registered listener [com.xpn.xwiki.store.XWikiCacheStore] since they both are registered under the same id [XWikiCacheStore]. In the future consider removing a Listener first if you really want to register it again. 2010-01-07 18:05:56,707 [http://localhost:8080/xwiki/bin/view/Main/] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 2010-01-07 18:05:56,707 [http://localhost:8080/xwiki/bin/view/Main/] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidbversion' doesn't exist 2010-01-07 18:05:56,707 [http://localhost:8080/xwiki/bin/view/Main/] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 2010-01-07 18:06:24,144 [http://localhost:8080/xwiki/bin/view/Main/] WARN rnal.DefaultObservationManager - The [com.xpn.xwiki.store.XWikiCacheStore] listener has overwritten a previously registered listener [com.xpn.xwiki.store.XWikiCacheStore] since they both are registered under the same id [XWikiCacheStore]. In the future consider removing a Listener first if you really want to register it again. 2010-01-07 18:06:24,144 [http://localhost:8080/xwiki/bin/view/Main/] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 2010-01-07 18:06:24,144 [http://localhost:8080/xwiki/bin/view/Main/] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidbversion' doesn't exist 2010-01-07 18:06:24,160 [http://localhost:8080/xwiki/bin/view/Main/] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 2010-01-07 18:20:38,041 [http://localhost:8080/xwiki/bin/view/Main/] ERROR store.XWikiHibernateBaseStore - Failed updating schema while executing query [create table feeds_aggregatorgroup (agg_id integer not null, agg_name text, primary key (agg_id))] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'feeds_aggregatorgroup' already exists at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:494) at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:310) at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:256) at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:565) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1026) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1070) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:68) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.<init>(AbstractXWikiMigrationManager.java:68) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.<init>(XWikiHibernateMigrationManager.java:51) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.xpn.xwiki.XWiki.createClassFromConfig(XWiki.java:1037) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:739) at com.xpn.xwiki.XWiki.<init>(XWiki.java:684) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:321) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:402) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.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:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:295) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Unknown Source) 2010-01-07 18:20:38,119 [http://localhost:8080/xwiki/bin/view/Main/] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 2010-01-07 18:20:38,119 [http://localhost:8080/xwiki/bin/view/Main/] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidbversion' doesn't exist 2010-01-07 18:20:38,150 [http://localhost:8080/xwiki/bin/view/Main/] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 2010-01-07 18:33:16,264 [http://localhost:8080/xwiki/bin/view/Main/] WARN rnal.DefaultObservationManager - The [com.xpn.xwiki.store.XWikiCacheStore] listener has overwritten a previously registered listener [com.xpn.xwiki.store.XWikiCacheStore] since they both are registered under the same id [XWikiCacheStore]. In the future consider removing a Listener first if you really want to register it again. 2010-01-07 18:33:16,264 [http://localhost:8080/xwiki/bin/view/Main/] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 2010-01-07 18:33:16,264 [http://localhost:8080/xwiki/bin/view/Main/] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidbversion' doesn't exist 2010-01-07 18:33:16,264 [http://localhost:8080/xwiki/bin/view/Main/] WARN action.RequestProcessor - Unhandl On Thu, Jan 7, 2010 at 6:34 PM, Ziggy <[email protected]> wrote: > I forgot to mention that to install xwiki, i extracted the zip file and > copied it to webapps/ > > > On Thu, Jan 7, 2010 at 6:31 PM, Ziggy <[email protected]> wrote: > >> I just installed a fresh install of xwiki 2.1.1 >> >> I had previously used v2.0 without any problems. I did the following to >> install 2.1.1 >> >> - Got a backup of the mysql database folder and the tomcat webapps/xwiki >> folder to backup the v2.0 >> - delete the database >> - Created the database as shown below >> >> mysql> show databases; >> +--------------------+ >> | Database | >> +--------------------+ >> | information_schema | >> | mysql | >> +--------------------+ >> 2 rows in set (0.13 sec) >> >> mysql> create database xwiki >> -> ; >> Query OK, 1 row affected (0.08 sec) >> >> mysql> grant all privileges on xwiki.* to [email protected] identified by >> 'xwiki' >> -> ; >> Query OK, 0 rows affected (0.34 sec) >> >> mysql> >> >> - I then updated the hibernate.cfg.xml file. All i did in this file is >> comment out the hsqldb configuration and uncommented the mysql >> configuration. >> >> Here is my hibernate.cfg.xml file >> >> --- >> >> <?xml version='1.0' encoding='utf-8'?> >> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate >> Configuration DTD//EN" >> "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd";> >> <hibernate-configuration> >> <session-factory> >> >> <!-- Please refer to the installation guide on >> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installationfor >> configuring your >> database. You'll need to do 2 things: >> 1) Copy your database driver JAR in WEB-INF/lib or in some shared >> lib directory >> 2) Uncomment the properties below for your specific DB (and >> comment the default >> database configuration if it doesn't match your DB) >> --> >> >> <!-- Generic parameters common to all Databases --> >> >> <property name="show_sql">false</property> >> <property name="use_outer_join">true</property> >> >> <property name="dbcp.defaultAutoCommit">false</property> >> <property name="dbcp.maxActive">50</property> >> <property name="dbcp.maxIdle">5</property> >> <property name="dbcp.maxWait">30000</property> >> <property name="dbcp.whenExhaustedAction">1</property> >> <property name="dbcp.ps.whenExhaustedAction">1</property> >> <property name="dbcp.ps.maxActive">20</property> >> <property name="dbcp.ps.maxWait">120000</property> >> <property name="dbcp.ps.maxIdle">20</property> >> <!-- Without it, some queries fail in MS SQL. XWiki doesn't need >> scrollable result sets, anyway. --> >> <property name="jdbc.use_scrollable_resultset">false</property> >> >> <!-- Configuration for the default database. >> Comment out this section and uncomment other sections below if >> you want to use another database. >> Note that the database tables will be created automatically if >> they don't already exist. >> >> <property >> name="connection.url">jdbc:hsqldb:file:database/xwiki_db;shutdown=true</property> >> <property name="connection.username">sa</property> >> <property name="connection.password"></property> >> <property >> name="connection.driver_class">org.hsqldb.jdbcDriver</property> >> <property name="dialect">org.hibernate.dialect.HSQLDialect</property> >> <property >> name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> >> <property name="connection.pool_size">2</property> >> <property name="statement_cache.size">2</property> >> <mapping resource="xwiki.hbm.xml"/> >> <mapping resource="feeds.hbm.xml"/> >> <mapping resource="activitystream.hbm.xml"/>--> >> >> <!-- MySQL configuration. >> Uncomment if you want to use MySQL and comment out other database >> configurations. >> We need to set the sql_mode to a less strict value, see >> XWIKI-1945--> >> <property >> name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode=''</property> >> <property name="connection.username">xwiki</property> >> <property name="connection.password">xwiki</property> >> <property >> name="connection.driver_class">com.mysql.jdbc.Driver</property> >> <property name="dialect">org.hibernate.dialect.MySQLDialect</property> >> <property >> name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> >> <property name="connection.pool_size">2</property> >> <property name="statement_cache.size">2</property> >> <mapping resource="xwiki.hbm.xml"/> >> <mapping resource="feeds.hbm.xml"/> >> <mapping resource="activitystream.hbm.xml"/> >> >> >> <!-- HSQLDB configuration. >> Uncomment if you want to use HSQLDB and comment out other >> database configurations. >> <property >> name="connection.url">jdbc:hsqldb:file:/some/path/xwikidb;shutdown=true</property> >> <property name="connection.username">sa</property> >> <property name="connection.password"></property> >> <property >> name="connection.driver_class">org.hsqldb.jdbcDriver</property> >> <property name="dialect">org.hibernate.dialect.HSQLDialect</property> >> <property >> name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> >> <property name="connection.pool_size">2</property> >> <property name="statement_cache.size">2</property> >> <mapping resource="xwiki.hbm.xml"/> >> <mapping resource="feeds.hbm.xml"/> >> <mapping resource="activitystream.hbm.xml"/> >> --> >> >> <!-- PostgreSQL configuration. >> Uncomment if you want to use PostgreSQL and comment out other >> database configurations. >> <property name="connection.url">jdbc:postgresql:xwiki</property> >> <property name="connection.username">xwiki</property> >> <property name="connection.password">xwiki</property> >> <property >> name="connection.driver_class">org.postgresql.Driver</property> >> <property >> name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> >> <property >> name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> >> <property name="connection.pool_size">2</property> >> <property name="statement_cache.size">2</property> >> <mapping resource="xwiki.hbm.xml"/> >> <mapping resource="feeds.hbm.xml"/> >> <mapping resource="activitystream.hbm.xml"/> >> --> >> >> <!-- Oracle configuration. >> Uncomment if you want to use Oracle and comment out other >> database configurations. >> Note: the 2 properties named >> "hibernate.connection.SetBigStringTryClob" and >> "hibernate.jdbc.batch_size". They are required to tell Oracle to >> allow CLOBs larger than >> 32K. >> <property name="connection.url">jdbc:oracle:thin:@localhost >> :1521:XE</property> >> <property name="connection.username">xwiki</property> >> <property name="connection.password">xwiki</property> >> <property >> name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> >> <property >> name="dialect">org.hibernate.dialect.Oracle10gDialect</property> >> <property >> name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> >> <property name="connection.pool_size">2</property> >> <property name="statement_cache.size">2</property> >> <property >> name="hibernate.connection.SetBigStringTryClob">true</property> >> <property name="hibernate.jdbc.batch_size">0</property> >> <mapping resource="xwiki.oracle.hbm.xml"/> >> <mapping resource="feeds.oracle.hbm.xml"/> >> <mapping resource="activitystream.hbm.xml"/> >> --> >> >> <!-- Derby configuration. >> Uncomment if you want to use Derby and comment out other database >> configurations. >> <property >> name="connection.url">jdbc:derby:/some/path/xwikidb;create=true</property> >> <property >> name="connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property> >> <property name="dialect">org.hibernate.dialect.DerbyDialect</property> >> <property >> name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> >> <property name="connection.pool_size">2</property> >> <property name="statement_cache.size">2</property> >> <mapping resource="xwiki.derby.hbm.xml"/> >> <mapping resource="feeds.hbm.xml"/> >> <mapping resource="activitystream.hbm.xml"/> >> --> >> >> </session-factory> >> </hibernate-configuration> >> >> ---- >> >> >> I tried to launch xwiki via http://localhost:8080/xwiki and i got this >> error on the browser.. >> >> HTTP Status 500 - >> ------------------------------ >> >> *type* Exception report >> >> *message* >> >> *description* *The server encountered an internal error () that prevented >> it from fulfilling this request.* >> >> *exception* >> >> javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 >> in 0: Could not initialize main XWiki context >> >> >> Wrapped Exception: Error number 3001 in 3: Cannot load class >> com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from >> param xwiki.store.migration.manager.class >> Wrapped Exception: Error number 0 in 3: Exception while hibernate execute >> >> >> Wrapped Exception: could not execute query >> >> org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535) >> >> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433) >> >> >> >> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) >> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) >> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) >> >> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:617) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> >> com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) >> >> >> com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:117) >> >> com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) >> >> com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:295) >> >> >> >> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) >> >> *root cause* >> >> com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main >> XWiki context >> >> >> Wrapped Exception: Error number 3001 in 3: Cannot load class >> com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from >> param xwiki.store.migration.manager.class >> Wrapped Exception: Error number 0 in 3: Exception while hibernate execute >> >> >> Wrapped Exception: could not execute query >> com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:341) >> com.xpn.xwiki.XWiki.getXWiki(XWiki.java:402) >> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) >> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) >> >> >> >> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) >> >> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) >> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) >> >> >> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:617) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> >> com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) >> >> >> com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:117) >> >> com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) >> >> com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:295) >> >> >> >> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) >> >> *note* *The full stack trace of the root cause is available in the Apache >> Tomcat/6.0.20 logs.* >> >> >> >> *Any cluses as to what i need to do to get it to work? >> * >> ------------------------------ >> Apache Tomcat/6.0.20 >> >> >> >> >> >> >> >> >> > _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
