2008.08.29 21:53:11 [org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:383)] SchemaManager: Failed to execute SQL:
 CREATE TABLE jiveUserFlag (   username              VARCHAR(64)     NOT NULL,   name                  VARCHAR(100)    NOT NULL,   startTime             CHAR(15),   endTime               CHAR(15),   PRIMARY KEY (username, name),   INDEX jiveUser_sTime_idx (startTime),   INDEX jiveUser_eTime_idx (endTime) );
2008.08.29 21:53:11 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:273)] 
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'jiveUserFlag' already exists
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
	at com.mysql.jdbc.Statement.execute(Statement.java:727)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
	at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
	at $java.sql.Statement$$EnhancerByProxool$$9050be00.execute(<generated>)
	at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:378)
	at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:270)
	at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java:71)
	at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectionManager.java:498)
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:79)
	at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:335)
	at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
	at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProperties.java:40)
	at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
	at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
	at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
	at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at java.lang.Class.newInstance0(Class.java:355)
	at java.lang.Class.newInstance(Class.java:308)
	at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
	at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
2008.08.29 21:53:11 [org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:346)] 
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openfire.ofProperty' doesn't exist
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
	at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
	at $java.sql.PreparedStatement$$EnhancerByProxool$$170aed4c.executeQuery(<generated>)
	at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:337)
	at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
	at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProperties.java:40)
	at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
	at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
	at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
	at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at java.lang.Class.newInstance0(Class.java:355)
	at java.lang.Class.newInstance(Class.java:308)
	at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
	at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
2008.08.29 21:53:11 [org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:709)] Database could not be accessed
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openfire.ofID' doesn't exist
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
	at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
	at $java.sql.PreparedStatement$$EnhancerByProxool$$170aed4c.executeQuery(<generated>)
	at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
	at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
	at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at java.lang.Class.newInstance0(Class.java:355)
	at java.lang.Class.newInstance(Class.java:308)
	at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
	at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
2008.08.29 21:53:11 [org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:457)] 
java.lang.IllegalArgumentException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openfire.ofID' doesn't exist
	at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:710)
	at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
	at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at java.lang.Class.newInstance0(Class.java:355)
	at java.lang.Class.newInstance(Class.java:308)
	at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
	at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openfire.ofID' doesn't exist
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
	at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
	at $java.sql.PreparedStatement$$EnhancerByProxool$$170aed4c.executeQuery(<generated>)
	at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
	... 10 more