Page 1 of 1

Store Skill MySQL Error

Posted: Sun Dec 12, 2010 12:53 pm
by Starter
If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number: 4430
L2JDP Revision Number: 7672

Ok guys, heres another wierd error (of many other similar ones for other skills) I get after applying the latest update:

Code: Select all

Error could not store char skills: Duplicate entry '268551461-1434-0' for key 'PRIMARY'com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268551461-1434-0' for key 'PRIMARY'        at sun.reflect.GeneratedConstructorAccessor127.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)        at com.mysql.jdbc.Util.getInstance(Util.java:384)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeSkill(L2PcInstance.java:8727)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.addSkill(L2PcInstance.java:8605)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.giveAvailableSkills(L2PcInstance.java:3045)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.rewardSkills(L2PcInstance.java:2965)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.setClassId(L2PcInstance.java:2738)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7790)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1256)        at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:564)        at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:103)        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1001)        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)        at java.lang.Thread.run(Unknown Source)
???

Re: Store Skill MySQL Error

Posted: Sun Dec 12, 2010 12:58 pm
by MasterJinz
Delete your skill table in Navicat then excute the new one . The easiest way :D

Re: Store Skill MySQL Error

Posted: Sun Dec 12, 2010 1:03 pm
by Starter
MasterJinz wrote:Delete your skill table in Navicat then excute the new one . The easiest way :D
I guess you mean all char skills right? :D

Re: Store Skill MySQL Error

Posted: Sun Dec 12, 2010 1:08 pm
by _DS_
Something wrong with your server skills - 1434 has no level.

Re: Store Skill MySQL Error

Posted: Sun Dec 12, 2010 1:14 pm
by Starter
_DS_ wrote:Something wrong with your server skills - 1434 has no level.
Well I havent customized anything relating the skills except maybe some modifications relating the power of some skills and added levels for the custom mana pots but I havent done anything to for example 1434. oO

Re: Store Skill MySQL Error

Posted: Sun Dec 12, 2010 1:52 pm
by MasterJinz
Starter wrote:
_DS_ wrote:Something wrong with your server skills - 1434 has no level.
Well I havent customized anything relating the skills except maybe some modifications relating the power of some skills and added levels for the custom mana pots but I havent done anything to for example 1434. oO
I have problem with this error , i deleted it and try to excute sql again and it works fine

Re: Store Skill MySQL Error

Posted: Sun Dec 12, 2010 1:54 pm
by Starter
MasterJinz wrote:
Starter wrote:
_DS_ wrote:Something wrong with your server skills - 1434 has no level.
Well I havent customized anything relating the skills except maybe some modifications relating the power of some skills and added levels for the custom mana pots but I havent done anything to for example 1434. oO
I have problem with this error , i deleted it and try to excute sql again and it works fine
Ok so I should really consider a skill wipe? Because replacing the skill_trees file or so would make no sense to me as nothing was changed in it.. :/