Primay key Fehler

[Melonemax]

Immer wenn ich etwas im SHop Kaufen möchte kommt der Fehler

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'd465f3f3-3e0b-4db2-bee3-da2475dbe795' for key 'PRIMARY'
[10:04:19] [Server thread/WARN]:        at sun.reflect.GeneratedConstructorAccessor36.newInstance(Unknown Source)
[10:04:19] [Server thread/WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[10:04:19] [Server thread/WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.Util.getInstance(Util.java:386)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1915)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2136)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2070)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5187)
[10:04:19] [Server thread/WARN]:        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2055)
[10:04:19] [Server thread/WARN]:        at de.melone.ulti.ExtraItemAbfrage.setfox(ExtraItemAbfrage.java:31)
[10:04:19] [Server thread/WARN]:        at de.melone.listener.Extras.onfoxbuy(Extras.java:227)
[10:04:19] [Server thread/WARN]:        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[10:04:19] [Server thread/WARN]:        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
[10:04:19] [Server thread/WARN]:        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
[10:04:19] [Server thread/WARN]:        at java.lang.reflect.Method.invoke(Unknown Source)
[10:04:19] [Server thread/WARN]:        at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:315)
[10:04:19] [Server thread/WARN]:        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:70)
[10:04:19] [Server thread/WARN]:        at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:589)
[10:04:19] [Server thread/WARN]:        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:576)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.PlayerConnection.a(PlayerConnection.java:2277)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.PacketPlayInWindowClick.a(SourceFile:32)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.PacketPlayInWindowClick.a(SourceFile:10)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.PlayerConnectionUtils.lambda$0(PlayerConnectionUtils.java:19)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.TickTask.run(SourceFile:18)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.IAsyncTaskHandler.executeTask(SourceFile:144)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.IAsyncTaskHandlerReentrant.executeTask(SourceFile:23)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.IAsyncTaskHandler.executeNext(SourceFile:118)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.MinecraftServer.bb(MinecraftServer.java:942)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.MinecraftServer.executeNext(MinecraftServer.java:935)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.IAsyncTaskHandler.awaitTasks(SourceFile:127)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.MinecraftServer.sleepForTick(MinecraftServer.java:919)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.MinecraftServer.w(MinecraftServer.java:851)
[10:04:19] [Server thread/WARN]:        at net.minecraft.server.v1_16_R3.MinecraftServer.lambda$0(MinecraftServer.java:164)
[10:04:19] [Server thread/WARN]:        at java.lang.Thread.run(Unknown Source)

 

[JOO200]

Ich gehe mal davon aus, dass die Methode "de.melone.ulti.ExtraItemAbfrage.setfox" von dir stammt.
Kannst du einmal die Klasse hier reinstellen?

 

[Melonemax]

   public static void setbluebird(String uuid, int coins) {
        if (getfox(uuid) == 0) {
            try {
                PreparedStatement st = MySQL.con.prepareStatement("INSERT INTO head (UUID,BirdBlue) VALUES (?,?)");
                st.setString(1, uuid);
                st.setInt(2, coins);
                st.executeUpdate();
                st.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } else {
            try {
                PreparedStatement st = MySQL.con.prepareStatement("UPDATE head SET BirdBlue = ? WHERE UUID = ?");
                st.setString(2, uuid);
                st.setInt(1, coins);
                st.executeUpdate();
                st.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

Post automatically merged: 17 Mai 2021

ok habe Selber mein Fehler Gefunden es muss if (getfox(uuid) == 0) { aus sonst geht das nicht da ich versuche denn Spieler neu Hinzuzufügen

 

[JOO200]

Irgendwie wird bei deiner Methode ein INSERT INTO ausgeführt und du hast bereits einen Eintrag in dieser Tabelle.
Eine gute Möglichkeit das zu fixen, ist das Nutzen von ON DUPLICATE KEY UPDATE, dadurch hast du solche Probleme nicht mehr.

 

[Melonemax]

   public static void setbluebird(String uuid, int coins) {
        if (getfox(uuid) == 0) {
            try {
                PreparedStatement st = MySQL.con.prepareStatement("INSERT INTO head (UUID,BirdBlue) VALUES (?,?)");
                st.setString(1, uuid);
                st.setInt(2, coins);
                st.executeUpdate();
                st.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } else {
            try {
                PreparedStatement st = MySQL.con.prepareStatement("UPDATE head SET BirdBlue = ? WHERE UUID = ?");
                st.setString(2, uuid);
                st.setInt(1, coins);
                st.executeUpdate();
                st.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

Post automatically merged: 17 Mai 2021

ok habe Selber mein Fehler Gefunden es muss if (getfox(uuid) == 0) { aus sonst geht das nicht da ich versuche denn Spieler neu Hinzuzufügen

ja ich habe da Grade auch meinen Fehler Selber bemerkt aber Danke