Homepage | Products | OX Knowledge Base | Support | Try Now | Contact | Company
OX Logo
Results 1 to 4 of 4
  1. #1
    flowback Guest

    Default 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. #2
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    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 at 01:59 PM.

  3. #3
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    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

  4. #4
    flowback Guest

    Default

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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •