Advertisement
GOODPower

Untitled

Feb 1st, 2014
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.81 KB | None | 0 0
  1. 23:26:51.404 Update database...
  2. 23:26:51.426 31.11.2013_npc.sql
  3. 23:26:51.430 3.01.2014_community.sql
  4. Error executing: ALTER TABLE `community_buffs_group_skills`
  5. ADD COLUMN `sortf` int NOT NULL AFTER `skill_level`
  6. . Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'sortf'
  7. 23:26:51.449 Failed update database. Update: '3.01.2014_community.sql'. [date] -> 'Thu Jan 16 19:52:08 MSK 2014'
  8. l2n.commons.sql.RuntimeSqlException: Error executing: ALTER TABLE `community_buffs_group_skills`
  9. ADD COLUMN `sortf` int NOT NULL AFTER `skill_level`
  10. . Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'sortf'
  11. at l2n.commons.sql.ScriptRunner.executeLineByLine(ScriptRunner.java:137)
  12. at l2n.commons.sql.ScriptRunner.runScript(ScriptRunner.java:99)
  13. at l2n.Updater.acceptUpdate(Updater.java:215)
  14. at l2n.Updater.updateDatabase(Updater.java:182)
  15. at l2n.game.GameServer.main(GameServer.java:187)
  16. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'sortf'
  17. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  18. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  19. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  20. at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
  21. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  22. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  23. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
  24. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
  25. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
  26. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
  27. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
  28. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
  29. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
  30. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)
  31. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
  32. at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
  33. at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
  34. at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
  35. at l2n.commons.sql.ScriptRunner.executeStatement(ScriptRunner.java:226)
  36. at l2n.commons.sql.ScriptRunner.handleLine(ScriptRunner.java:198)
  37. at l2n.commons.sql.ScriptRunner.executeLineByLine(ScriptRunner.java:130)
  38. ... 4 more
  39.  
  40. 23:26:51.450 updater_change_format.sql
  41. 23:26:51.630 Failed update table 'last_update'.
  42. 23:26:51.631 Failed update database. Update: 'updater_change_format.sql'. [date] -> 'Sat Feb 01 01:30:30 MSK 2014'
  43. com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'accepted' at row 1
  44. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3607)
  45. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
  46. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
  47. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
  48. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
  49. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
  50. at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
  51. at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
  52. at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
  53. at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
  54. at l2n.database.FiltredPreparedStatement.execute(FiltredPreparedStatement.java:43)
  55. at l2n.Updater.updateDatabase(Updater.java:194)
  56. at l2n.game.GameServer.main(GameServer.java:187)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement