Table headersAsBlob missing

[ibruell]

I have installed open-xchange community 6.18.0-Rev7 and have the error message above in the gui on trying to show my imap mails.

Some hints ?

Installed on Ubuntu 10.04 LTS
sun jdk 1.6.0_20

Stacktrace:

10.11.2010 12:43:13 com.openexchange.ajax.Mail actionGetNew
SCHWERWIEGEND: MSG-0000 Category=7 Message=Unexpected error: Table 'ox6_7.headersAsBlob' doesn't exist exceptionID=-12766172-46
MSG-0000 Category=7 Message=Unexpected error: Table 'ox6_7.headersAsBlob' doesn't exist exceptionID=-12766172-46
at com.openexchange.mail.headercache.database.Databas eAccess.fillMailChunk(DatabaseAccess.java:474)
at com.openexchange.mail.headercache.database.Databas eAccess.fillMails(DatabaseAccess.java:379)
at com.openexchange.mail.headercache.HeaderCacheMessa geStorage.fillMails(HeaderCacheMessageStorage.java :363)
at com.openexchange.mail.headercache.HeaderCacheMessa geStorage.getUnreadMessages(HeaderCacheMessageStor age.java:280)
at com.openexchange.mail.MailServletInterfaceImpl.get NewMessages(MailServletInterfaceImpl.java:1321)
at com.openexchange.ajax.Mail.actionGetNew(Mail.java: 1645)
at com.openexchange.ajax.Mail.actionGetNew(Mail.java: 1565)
at com.openexchange.ajax.request.MailRequest.action(M ailRequest.java:156)
at com.openexchange.ajax.Multiple.doAction(Multiple.j ava:293)
at com.openexchange.ajax.Multiple.parseActionElement( Multiple.java:178)
at com.openexchange.ajax.Multiple.doPut(Multiple.java :126)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:619)
at com.openexchange.ajax.AJAXServlet.service(AJAXServ let.java:392)
at com.openexchange.ajax.SessionServlet.service(Sessi onServlet.java:174)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
at com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.doServletService(AJPv13RequestHandlerImpl.java: 504)
at com.openexchange.ajp13.AJPv13Request.response(AJPv 13Request.java:129)
at com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.createResponse(AJPv13RequestHandlerImpl.java:31 6)
at com.openexchange.ajp13.najp.AJPv13ConnectionImpl.c reateResponse(AJPv13ConnectionImpl.java:207)
at com.openexchange.ajp13.najp.AJPv13Task.call(AJPv13 Task.java:346)
at java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.jav a:138)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.runTask(CustomThreadPoolExecuto r.java:738)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.run(CustomThreadPoolExecutor.ja va:764)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Table 'ox6_7.headersAsBlob' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Construc tor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 36)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1885)

[Martin Heiland]

Hi,

i suspect that you have installed the open-xchange-mail-headercache plugin. This one is only a experimental implementation to cache mail metadata at the database and should not be used at all. Uninstalling this package should solve the problem.

Greetings

[ibruell]

solved

Yes that fixed the problem, thank you :-)