MobHunting

MobHunting

114k Downloads

MySql Error

cdmvirt opened this issue ยท 10 comments

commented

Do you know how to drop the table "mh_Bounties" in your database ?

commented

I think I have found another solution. But I have to test this first.

commented
commented

That should not be needed :-)

I decided to drop the CONSTRAINT completely

PLease test build 700
https://fractal.lindegaard.one:8181/job/MobHunting/700/

commented

still not fixed... I have another ๐Ÿ‘Ž
[21:22:03 WARN]: one.lindegaard.MobHunting.storage.DataStoreException: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (mobhunting.mh_Bounties, CONSTRAINT mh_Bounties_Player_Id_1 FOREIGN KEY (BOUNTYOWNER_ID) REFERENCES mh_Players (PLAYER_ID) ON DELETE CASCADE) [21:22:03 WARN]: at one.lindegaard.MobHunting.storage.MySQLDataStore.saveBounties(MySQLDataStore.java:336) [21:22:03 WARN]: at one.lindegaard.MobHunting.storage.asynch.StoreTask.run(StoreTask.java:53) [21:22:03 WARN]: at one.lindegaard.MobHunting.storage.asynch.StoreTask.run(StoreTask.java:13) [21:22:03 WARN]: at one.lindegaard.MobHunting.storage.DataStoreManager$TaskThread.run(DataStoreManager.java:404) [21:22:03 WARN]: Caused by: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (mobhunting.mh_Bounties, CONSTRAINT mh_Bounties_Player_Id_1 FOREIGN KEY (BOUNTYOWNER_ID) REFERENCES mh_Players (PLAYER_ID) ON DELETE CASCADE) [21:22:03 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [21:22:03 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [21:22:03 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [21:22:03 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [21:22:03 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) [21:22:03 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408) [21:22:03 WARN]: at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1163) [21:22:03 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1778) [21:22:03 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1262) [21:22:03 WARN]: at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970) [21:22:03 WARN]: at one.lindegaard.MobHunting.storage.MySQLDataStore.saveBounties(MySQLDataStore.java:329) [21:22:03 WARN]: ... 3 more [21:22:03 WARN]: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (mobhunting.mh_Bounties, CONSTRAINT mh_Bounties_Player_Id_1 FOREIGN KEY (BOUNTYOWNER_ID) REFERENCES mh_Players (PLAYER_ID) ON DELETE CASCADE) [21:22:03 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [21:22:03 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [21:22:03 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [21:22:03 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [21:22:03 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) [21:22:03 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408) [21:22:03 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) [21:22:03 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976) [21:22:03 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912) [21:22:03 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) [21:22:03 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) [21:22:03 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) [21:22:03 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) [21:22:03 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) [21:22:03 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1756) [21:22:03 WARN]: ... 6 more

commented

i dropped all the tables and let the plugin regenerate them still same issue

commented

Does it work now?

commented

will test sorry been busy :P

commented

any news?