Unknown column 'unified_inbox' in 'field list'

[flowback]

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:

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

[Martin Heiland]

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.

[Martin Heiland]

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

[flowback]

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