Помогите Как убрать предупреждение в консоли от MobHunting?

  • Автор темы Автор темы Detfor
  • Дата начала Дата начала
Detfor

Detfor

Активный участник
Пользователь
Баллы
61
Ник в Minecraft
Detfor
Переодически в консоли всплывает предупреждение от плагина MobHunting:

[11:08:20 WARN]: one.lindegaard.MobHunting.storage.DataStoreException: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`s547_vgdatabase`.`mh_Bounties`, CONSTRAINT `mh_Bounties_Player_Id_1` FOREIGN KEY (`BOUNTYOWNER_ID`) REFERENCES `mh_Players` (`PLAYER_ID`) ON DELETE CASCADE)
[11:08:20 WARN]: at one.lindegaard.MobHunting.storage.MySQLDataStore.saveBounties(MySQLDataStore.java:337)
[11:08:20 WARN]: at one.lindegaard.MobHunting.storage.asynch.StoreTask.run(StoreTask.java:53)
[11:08:20 WARN]: at one.lindegaard.MobHunting.storage.asynch.StoreTask.run(StoreTask.java:13)
[11:08:20 WARN]: at one.lindegaard.MobHunting.storage.DataStoreManager$TaskThread.run(DataStoreManager.java:404)
[11:08:20 WARN]: Caused by: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`s547_vgdatabase`.`mh_Bounties`, CONSTRAINT `mh_Bounties_Player_Id_1` FOREIGN KEY (`BOUNTYOWNER_ID`) REFERENCES `mh_Players` (`PLAYER_ID`) ON DELETE CASCADE)
[11:08:20 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:08:20 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[11:08:20 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[11:08:20 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[11:08:20 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[11:08:20 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[11:08:20 WARN]: at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1163)
[11:08:20 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1778)
[11:08:20 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1262)
[11:08:20 WARN]: at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970)
[11:08:20 WARN]: at one.lindegaard.MobHunting.storage.MySQLDataStore.saveBounties(MySQLDataStore.java:330)
[11:08:20 WARN]: ... 3 more
[11:08:20 WARN]: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`s547_vgdatabase`.`mh_Bounties`, CONSTRAINT `mh_Bounties_Player_Id_1` FOREIGN KEY (`BOUNTYOWNER_ID`) REFERENCES `mh_Players` (`PLAYER_ID`) ON DELETE CASCADE)
[11:08:20 WARN]: at sun.reflect.GeneratedConstructorAccessor325.newInstance(Unknown Source)
[11:08:20 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[11:08:20 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[11:08:20 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[11:08:20 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[11:08:20 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
[11:08:20 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[11:08:20 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[11:08:20 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[11:08:20 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[11:08:20 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
[11:08:20 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[11:08:20 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
[11:08:20 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1756)
[11:08:20 WARN]: ... 6 more

Я так понимаю, там что-то связано с базой данных, я написал разработчику и он мне ответил:
"How did you end up in this situation?

You have to login to your MySQL database and do a:

alter table mh_Bounties drop FOREIGN KEY `mh_Bounties_Player_Id_1;"

Я не совсем понял что нужно сделать, объясните пожалуйста
 
Сортировать по дате Сортировать по голосам
Detfor сказал(а):
Переодически в консоли всплывает предупреждение от плагина MobHunting:

[11:08:20 WARN]: one.lindegaard.MobHunting.storage.DataStoreException: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`s547_vgdatabase`.`mh_Bounties`, CONSTRAINT `mh_Bounties_Player_Id_1` FOREIGN KEY (`BOUNTYOWNER_ID`) REFERENCES `mh_Players` (`PLAYER_ID`) ON DELETE CASCADE)
[11:08:20 WARN]: at one.lindegaard.MobHunting.storage.MySQLDataStore.saveBounties(MySQLDataStore.java:337)
[11:08:20 WARN]: at one.lindegaard.MobHunting.storage.asynch.StoreTask.run(StoreTask.java:53)
[11:08:20 WARN]: at one.lindegaard.MobHunting.storage.asynch.StoreTask.run(StoreTask.java:13)
[11:08:20 WARN]: at one.lindegaard.MobHunting.storage.DataStoreManager$TaskThread.run(DataStoreManager.java:404)
[11:08:20 WARN]: Caused by: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`s547_vgdatabase`.`mh_Bounties`, CONSTRAINT `mh_Bounties_Player_Id_1` FOREIGN KEY (`BOUNTYOWNER_ID`) REFERENCES `mh_Players` (`PLAYER_ID`) ON DELETE CASCADE)
[11:08:20 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:08:20 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[11:08:20 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[11:08:20 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[11:08:20 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[11:08:20 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[11:08:20 WARN]: at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1163)
[11:08:20 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1778)
[11:08:20 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1262)
[11:08:20 WARN]: at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970)
[11:08:20 WARN]: at one.lindegaard.MobHunting.storage.MySQLDataStore.saveBounties(MySQLDataStore.java:330)
[11:08:20 WARN]: ... 3 more
[11:08:20 WARN]: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`s547_vgdatabase`.`mh_Bounties`, CONSTRAINT `mh_Bounties_Player_Id_1` FOREIGN KEY (`BOUNTYOWNER_ID`) REFERENCES `mh_Players` (`PLAYER_ID`) ON DELETE CASCADE)
[11:08:20 WARN]: at sun.reflect.GeneratedConstructorAccessor325.newInstance(Unknown Source)
[11:08:20 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[11:08:20 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[11:08:20 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[11:08:20 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[11:08:20 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
[11:08:20 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[11:08:20 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[11:08:20 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[11:08:20 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[11:08:20 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
[11:08:20 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[11:08:20 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
[11:08:20 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1756)
[11:08:20 WARN]: ... 6 more

Я так понимаю, там что-то связано с базой данных, я написал разработчику и он мне ответил:
"How did you end up in this situation?

You have to login to your MySQL database and do a:

alter table mh_Bounties drop FOREIGN KEY `mh_Bounties_Player_Id_1;"

Я не совсем понял что нужно сделать, объясните пожалуйста
Нажмите, чтобы раскрыть...
Разработчик же тебе и написал, зайди в базу данных mysql и введи там запрос
 
За 0 Против
Для ответа нужно войти/зарегистрироваться
Назад
Верх Низ