powered by Jive Software

Table 'openfire.ofConparticipant' doesn't exist

Need help

anyone who has the table structure for this? and another question is since server is working should I create this on the server.

Thanks

2013.07.02 09:37:21 org.jivesoftware.openfire.archive.ConversationManager - Table ‘openfire.ofConparticipant’ doesn’t exist

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table ‘openfire.ofConparticipant’ 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.execute(PreparedStatement.java:882)

at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va: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$$b5dd6f76.execute()

the sql is located in …openfire\src\plugins\monitoring\src\database, maybe you need to apply the corresponding sql to your database manually.

and i think u dont need that table if u unload monitor plugin.