Announcement

Collapse
No announcement yet.

Table headersAsBlob missing

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Table headersAsBlob missing

    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)
    Last edited by Guest; 11-10-2010, 02:03 PM. Reason: added stacktrace

  • #2
    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

    Comment


    • #3
      solved

      Yes that fixed the problem, thank you :-)

      Comment

      Working...
      X