2 Replies Latest reply on Jul 9, 2007 6:59 AM by dcarter

    SQL error - Page hang in 1.2

      I just upgraded a 1.0.4 installation to 1.2. From the main page, if I click the "discussions" link in the "What's new" section, it just hangs. In the logs, I see this message repeated many times:


      Jun 29, 2007 7:51:04 AM com.jivesoftware.base.Log error

      SEVERE: Duplicate entry '382-2047-1178953200000' for key 1

      java.sql.SQLException: Duplicate entry '382-2047-1178953200000' for key 1

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)

              at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedSt



      I've rebuild the index and restarted tomcat several times, the problem still exists.


      Any ideas?