If I try to save my mail-settings I receive the following Error message:
After a logout and login my settings are the old again:
In the logfile I have found the following lines:
Hope someone can solve my problem
Thanks for help.
oprocopio
Code:
Error code: An SQL error occurred (USS-0001,-1406330596-46)
In the logfile I have found the following lines:
Code:
6004 at java.lang.Thread.run(Thread.java:619) 6005 Jun 12, 2007 1:05:08 PM com.openexchange.pooling.ReentrantLockPool get 6006 FINEST: Get time: 0, Created: false 6007 Jun 12, 2007 1:05:08 PM com.openexchange.pooling.ReentrantLockPool back 6008 FINEST: Back time: 0 6009 Jun 12, 2007 1:05:08 PM com.openexchange.groupware.imap.UserSettingMail saveUserSettingMail [B]6010 SEVERE: Unknown column 'confirmed_spam' in 'field list'[/B] 6011 java.sql.SQLException: Unknown column 'confirmed_spam' in 'field list' 6012 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) 6013 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) 6014 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) 6015 at com.mysql.jdbc.Connection.execSQL(Connection.java:3004) 6016 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128) 6017 at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1222) 6018 at com.openexchange.groupware.imap.UserSettingMail.saveUserSettingMail(UserSettingMail.java:239) 6019 at com.openexchange.groupware.imap.UserSettingMail.saveUserSettingMail(UserSettingMail.java:222) 6020 at com.openexchange.groupware.settings.ConfigTree$AbstractMailFuncs.writeValue(ConfigTree.java:298) 6021 at com.openexchange.groupware.settings.RdbSettingStorage.save(RdbSettingStorage.java:138) 6022 at com.openexchange.ajax.ConfigMenu.saveSettingWithSubs(ConfigMenu.java:270) 6023 at com.openexchange.ajax.ConfigMenu.saveSettingWithSubs(ConfigMenu.java:284) 6024 at com.openexchange.ajax.ConfigMenu.doPut(ConfigMenu.java:219) 6025 at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) 6026 at com.openexchange.ajax.SessionServlet.service(SessionServlet.java:132) 6027 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 6028 at com.openexchange.tools.ajp13.AJPv13Request.response(AJPv13Request.java:92) 6029 at com.openexchange.tools.ajp13.AJPv13RequestHandler.createResponse(AJPv13RequestHandler.java:335) 6030 at com.openexchange.tools.ajp13.AJPv13Connection.createResponse(AJPv13Connection.java:170) 6031 at com.openexchange.tools.ajp13.AJPv13Listener.run(AJPv13Listener.java:237) 6032 at java.lang.Thread.run(Thread.java:619) 6033 Jun 12, 2007 1:05:08 PM com.openexchange.tools.servlet.ServletContextWrapper log 6034 INFO: null: USS-0001 Category=8 Message=An SQL error occurred exceptionID=-1406330596-46 6035 USS-0001 Category=8 Message=An SQL error occurred exceptionID=-1406330596-46 6036 at com.openexchange.groupware.settings.ConfigTree$AbstractMailFuncs.writeValue(ConfigTree.java:301) 6037 at com.openexchange.groupware.settings.RdbSettingStorage.save(RdbSettingStorage.java:138) 6038 at com.openexchange.ajax.ConfigMenu.saveSettingWithSubs(ConfigMenu.java:270) 6039 at com.openexchange.ajax.ConfigMenu.saveSettingWithSubs(ConfigMenu.java:284) 6040 at com.openexchange.ajax.ConfigMenu.doPut(ConfigMenu.java:219) 6041 at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) 6042 at com.openexchange.ajax.SessionServlet.service(SessionServlet.java:132) 6043 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 6044 at com.openexchange.tools.ajp13.AJPv13Request.response(AJPv13Request.java:92) 6045 at com.openexchange.tools.ajp13.AJPv13RequestHandler.createResponse(AJPv13RequestHandler.java:335) 6046 at com.openexchange.tools.ajp13.AJPv13Connection.createResponse(AJPv13Connection.java:170) 6047 at com.openexchange.tools.ajp13.AJPv13Listener.run(AJPv13Listener.java:237) 6048 at java.lang.Thread.run(Thread.java:619) 6049 Caused by: USS-0001 Category=8 Message=An SQL error occurred exceptionID=-1406330596-45 6050 at com.openexchange.groupware.imap.UserSettingMail.saveUserSettingMail(UserSettingMail.java:311) 6051 at com.openexchange.groupware.imap.UserSettingMail.saveUserSettingMail(UserSettingMail.java:222) 6052 at com.openexchange.groupware.settings.ConfigTree$AbstractMailFuncs.writeValue(ConfigTree.java:298) 6053 ... 12 more 6054 Caused by: java.sql.SQLException: Unknown column 'confirmed_spam' in 'field list' 6055 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) 6056 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) 6057 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) 6058 at com.mysql.jdbc.Connection.execSQL(Connection.java:3004) 6059 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128) 6060 at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1222) 6061 at com.openexchange.groupware.imap.UserSettingMail.saveUserSettingMail(UserSettingMail.java:239) 6062 ... 14 more
Thanks for help.
oprocopio
Comment