Seed Importing Into DB Problem Dupicate Entry for PRIMARY KEY

Issue #240 new
Vampire created an issue

Hey guys, I wanted to ask you how do I fix this problem ?

Jan 08, 2018 8:06:27 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Seed: Alternative Twin Coba(15336)[268553183] into DB: Reason: Duplicate entry '268553183' for key 'PRIMARY'
java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '268553183' for key 'PRIMARY'
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:533)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
    at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
    at com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1826)
    at com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2034)
    at com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:1970)
    at com.mysql.cj.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:4984)
    at com.mysql.cj.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1955)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1699)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1470)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1440)
    at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.addItem(ItemContainer.java:360)
    at com.l2jserver.gameserver.model.itemcontainer.PcInventory.addItem(PcInventory.java:510)
    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.addItem(L2PcInstance.java:3197)
    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.addItem(L2PcInstance.java:3121)
    at com.l2jserver.gameserver.network.clientpackets.RequestBuySeed.runImpl(RequestBuySeed.java:186)
    at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:69)
    at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1135)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

And this happnes with all seeds. Thanks to the dev crew in advance.

Comments (2)

  1. Log in to comment