| la2baium |
17.05.2017 13:16 |
Ошибка обновления таблицы 'character_hennas' (CLOSED)
каждый раз при запуске сервера ругаеться на невозможность обновить таблицу (дубликат столбцов).
Пересоздавал ее уже из файла gameserver/sql/install/character_hennas.sql
не думаю что это прям проблема но тем не менее
Код HTML:
[17.05.17 12:03:27:287] ERROR database.UpdatesInstaller: Error while install database update [2015_06_08 15-54]: java.sql.SQLException: Error executing 'ALTER TABLE character_hennas ADD COLUMN `draw_time` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `class_index` ' (line 1): Duplicate column name 'draw_time'
java.sql.SQLException: Error executing 'ALTER TABLE character_hennas ADD COLUMN `draw_time` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `class_index` ' (line 1): Duplicate column name 'draw_time'
at l2s.commons.dbutils.ScriptRunner.execCommand(ScriptRunner.java:185)
at l2s.commons.dbutils.ScriptRunner.runScript(ScriptRunner.java:148)
at l2s.commons.dbutils.ScriptRunner.runScript(ScriptRunner.java:99)
at l2s.gameserver.database.UpdatesInstaller.checkAndInstall(UpdatesInstaller.java:91)
at l2s.gameserver.GameServer.<init>(GameServer.java:194)
at l2s.gameserver.GameServer.main(GameServer.java:422)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'draw_time'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
at com.mysql.jdbc.Util.getInstance(Util.java:372)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at l2s.commons.dbutils.ScriptRunner.execCommand(ScriptRunner.java:178)
... 5 more
|
