Hi,
When I start Openfire 3.5.0, I get the following in my error log:
2008.04.09 15:35:06 org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:251)
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘jid varchar(1024) not null’ at line 1
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.ja va:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.Statement$$EnhancerByProxool$$2ea7d742.execute(<generated>)
at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:348 )
at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:248)
at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java: 68)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:491)
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:81)
at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:330)
at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:72)
at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProp erties.java:39)
at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:51)
at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:524)
at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:332)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:446)
at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:160)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessor Impl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructor AccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:50)
Sounds like an incompatibility with my MySQL jdbc driver? Is this a problem on my side, or is this something in Openfire?