Announcement

Collapse
No announcement yet.

Unknown column 'unified_inbox' in 'field list'

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

  • Unknown column 'unified_inbox' in 'field list'

    Dear List,

    after upgrading from 6.9 to 6.12 I have difficulties logging in. It stops at 90% with Initalization. There is a stack trace in the open-xchange.log:


    Code:
    Oct 13, 2009 12:03:09 PM com.openexchange.mail.usersetting.UserSettingMail isSpamEnabled
    SEVERE: ACC-0004 Category=8 Message=A SQL error occurred: Unknown column 'unified_inbox' in 'field list'. exceptionID=-669367539-21
    ACC-0004 Category=8 Message=A SQL error occurred: Unknown column 'unified_inbox' in 'field list'. exceptionID=-669367539-21
    	at com.openexchange.mailaccount.MailAccountExceptionFactory.createException(MailAccountExceptionFactory.java:82)
    	at com.openexchange.mailaccount.MailAccountExceptionFactory.createException(MailAccountExceptionFactory.java:60)
    	at com.openexchange.exceptions.Exceptions.create(Exceptions.java:139)
    	at com.openexchange.exceptions.Exceptions.create(Exceptions.java:159)
    	at com.openexchange.mailaccount.internal.RdbMailAccountStorage.fillMailAccount(RdbMailAccountStorage.java:181)
    	at com.openexchange.mailaccount.internal.RdbMailAccountStorage.fillMailAccount(RdbMailAccountStorage.java:132)
    	at com.openexchange.mailaccount.internal.RdbMailAccountStorage.getMailAccount(RdbMailAccountStorage.java:344)
    	at com.openexchange.mailaccount.internal.RdbMailAccountStorage.getDefaultMailAccount(RdbMailAccountStorage.java:332)
    	at com.openexchange.mailaccount.internal.CachingMailAccountStorage$1.load(CachingMailAccountStorage.java:148)
    	at com.openexchange.mailaccount.internal.CachingMailAccountStorage$1.load(CachingMailAccountStorage.java:151)
    	at com.openexchange.cache.dynamic.impl.Refresher.refresh(Refresher.java:165)
    	at com.openexchange.mailaccount.internal.MailAccountReloader.<init>(MailAccountReloader.java:79)
    	at com.openexchange.mailaccount.internal.CachingMailAccountStorage.getDefaultMailAccount(CachingMailAccountStorage.java:156)
    	at com.openexchange.mail.usersetting.UserSettingMail.isSpamEnabled(UserSettingMail.java:719)
    	at com.openexchange.groupware.settings.tree.modules.mail.SpamButton$1.getValue(SpamButton.java:97)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readSharedValue(RdbSettingStorage.java:333)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readValues(RdbSettingStorage.java:275)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readSubValues(RdbSettingStorage.java:384)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readValues(RdbSettingStorage.java:271)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readSubValues(RdbSettingStorage.java:384)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readValues(RdbSettingStorage.java:271)
    	at com.openexchange.ajax.ConfigMenu.doGet(ConfigMenu.java:122)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
    	at com.openexchange.ajax.AJAXServlet.service(AJAXServlet.java:365)
    	at com.openexchange.ajax.SessionServlet.service(SessionServlet.java:159)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
    	at com.openexchange.ajp13.najp.AJPv13RequestHandlerImpl.doServletService(AJPv13RequestHandlerImpl.java:433)
    	at com.openexchange.ajp13.AJPv13Request.response(AJPv13Request.java:128)
    	at com.openexchange.ajp13.najp.AJPv13RequestHandlerImpl.createResponse(AJPv13RequestHandlerImpl.java:286)
    	at com.openexchange.ajp13.najp.AJPv13ConnectionImpl.createResponse(AJPv13ConnectionImpl.java:189)
    	at com.openexchange.ajp13.najp.AJPv13Task.run(AJPv13Task.java:281)
    	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
    	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'unified_inbox' in 'field list'
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    	at com.mysql.jdbc.Util.getInstance(Util.java:381)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
    	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
    	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
    	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
    	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
    	at com.openexchange.mailaccount.internal.RdbMailAccountStorage.fillMailAccount(RdbMailAccountStorage.java:146)
    	... 32 more
    Oct 13, 2009 12:03:09 PM com.openexchange.ajax.AJAXServlet service
    SEVERE: null
    java.lang.NullPointerException
    	at com.openexchange.mail.usersetting.UserSettingMail.isSpamEnabled(UserSettingMail.java:726)
    	at com.openexchange.groupware.settings.tree.modules.mail.SpamButton$1.getValue(SpamButton.java:97)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readSharedValue(RdbSettingStorage.java:333)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readValues(RdbSettingStorage.java:275)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readSubValues(RdbSettingStorage.java:384)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readValues(RdbSettingStorage.java:271)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readSubValues(RdbSettingStorage.java:384)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readValues(RdbSettingStorage.java:271)
    	at com.openexchange.ajax.ConfigMenu.doGet(ConfigMenu.java:122)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
    	at com.openexchange.ajax.AJAXServlet.service(AJAXServlet.java:365)
    	at com.openexchange.ajax.SessionServlet.service(SessionServlet.java:159)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
    	at com.openexchange.ajp13.najp.AJPv13RequestHandlerImpl.doServletService(AJPv13RequestHandlerImpl.java:433)
    	at com.openexchange.ajp13.AJPv13Request.response(AJPv13Request.java:128)
    	at com.openexchange.ajp13.najp.AJPv13RequestHandlerImpl.createResponse(AJPv13RequestHandlerImpl.java:286)
    	at com.openexchange.ajp13.najp.AJPv13ConnectionImpl.createResponse(AJPv13ConnectionImpl.java:189)
    	at com.openexchange.ajp13.najp.AJPv13Task.run(AJPv13Task.java:281)
    	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
    	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    	at java.lang.Thread.run(Thread.java:619)
    Oct 13, 2009 12:03:09 PM com.openexchange.ajp13.najp.AJPv13Task run
    SEVERE: null
    javax.servlet.ServletException
    	at com.openexchange.ajax.AJAXServlet.service(AJAXServlet.java:370)
    	at com.openexchange.ajax.SessionServlet.service(SessionServlet.java:159)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
    	at com.openexchange.ajp13.najp.AJPv13RequestHandlerImpl.doServletService(AJPv13RequestHandlerImpl.java:433)
    	at com.openexchange.ajp13.AJPv13Request.response(AJPv13Request.java:128)
    	at com.openexchange.ajp13.najp.AJPv13RequestHandlerImpl.createResponse(AJPv13RequestHandlerImpl.java:286)
    	at com.openexchange.ajp13.najp.AJPv13ConnectionImpl.createResponse(AJPv13ConnectionImpl.java:189)
    	at com.openexchange.ajp13.najp.AJPv13Task.run(AJPv13Task.java:281)
    	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
    	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: java.lang.NullPointerException
    	at com.openexchange.mail.usersetting.UserSettingMail.isSpamEnabled(UserSettingMail.java:726)
    	at com.openexchange.groupware.settings.tree.modules.mail.SpamButton$1.getValue(SpamButton.java:97)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readSharedValue(RdbSettingStorage.java:333)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readValues(RdbSettingStorage.java:275)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readSubValues(RdbSettingStorage.java:384)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readValues(RdbSettingStorage.java:271)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readSubValues(RdbSettingStorage.java:384)
    	at com.openexchange.groupware.settings.impl.RdbSettingStorage.readValues(RdbSettingStorage.java:271)
    	at com.openexchange.ajax.ConfigMenu.doGet(ConfigMenu.java:122)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
    	at com.openexchange.ajax.AJAXServlet.service(AJAXServlet.java:365)
    	... 13 more
    I assume there is a field in the database which needs to be added, but I'm not sure in which table. Has anyone got a clue how to solve this?

    Thanks in advance
    Björn

  • #2
    Hi,

    this one sounds very familiar - we support database changes between stable version but don't maintain intermediate changes of development versions. The update of 6.9 to 6.12 failed because some tables have been used with 6.9 that have been changed with 6.10. The update tasks only cover 6.10->6.12.
    Last edited by Martin Heiland; 10-13-2009, 01:59 PM.

    Comment


    • #3
      You could try to remove those old tables and re-run the update tasks:

      DROP TABLE user_mail_account, user_mail_account_properties, user_transport_account, user_transport_account_properties, pop3_storage_ids, pop3_storage_deleted;

      /opt/open-xchange/sbin/resetversion -v 34 -c 1

      /etc/init.d/open-xchange-groupware restart

      Comment


      • #4
        Thank You Martin!
        I thought I have to reinitialize the whole db with initconfigdb...

        Comment

        Working...
        X