Trouble with OF: (SchemaManager.java:251)

Openfire Openfire Support
1

Hello there,

every day I get the following Errors in my OF-Logfile and I don’t know how to handle/fix it. May can anybody help?

OF runs on a VPS at Hosteurope, OS is a WIN2003Server x64, MySQLx64 last stable.

Here are the Snippets

ERROR-LOG

2007.12.29 10:44:11 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:251)

]

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Doppelter Spaltenname: ‘imageType’

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 org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:348 )

at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:248)

at org.jivesoftware.database.SchemaManager.checkPluginSchema(SchemaManager.java:11 1)

at org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java :416)

at org.jivesoftware.openfire.container.PluginManager.access$300(PluginManager.java :46)

at org.jivesoftware.openfire.container.PluginManager$PluginMonitor.run(PluginManag er.java:1013)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)

at java.util.concurrent.FutureTask.runAndReset(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101 (Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodi c(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknow n Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2007.12.29 10:44:11 [org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.jav a:418)

] gateway - Database update failed. Please manually upgrade your database.

— Markerung eingefügt von admin am 29.12.2007 10:50:20 —

Thx a lot for your attention and excuse my ugly english, pls

Greetings

Micha

2

I’m sorry. But could you edit your thread’s title (make it shorter or put spaces somewhere)? Because now Community view is broken, because it cant wrap such a long text string. I cant see threads’ authors and avatars.

3

… I have’nt a problem to see the Avatars you describe but I have changed it; better now?

4

test

5

it depends on the resolution. yes, after i have replied to the first post it’s now ok. thanks