Announcement

Collapse
No announcement yet.

Errormessage when saving Mail-Settings

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

  • Errormessage when saving Mail-Settings

    If I try to save my mail-settings I receive the following Error message:

    Code:
    Error code: An SQL error occurred (USS-0001,-1406330596-46)
    After a logout and login my settings are the old again:

    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
    Hope someone can solve my problem

    Thanks for help.

    oprocopio

  • #2
    nobody has a solution for my problem??

    Comment


    • #3
      - I have deleted both DB's (config and ox)
      - created new with oxinstaller

      now seems to be solved.

      Comment

      Working...
      X