Store Skill MySQL Error

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
Starter
Posts: 484
Joined: Sat Jan 23, 2010 4:42 pm

Store Skill MySQL Error

Post 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)
???
I have promises to keep and miles to go before I sleep.
Top
MasterJinz
Posts: 54
Joined: Mon Sep 27, 2010 9:01 pm

Re: Store Skill MySQL Error

Post by MasterJinz »

Delete your skill table in Navicat then excute the new one . The easiest way :D
Sry for bad english :)
Top
Starter
Posts: 484
Joined: Sat Jan 23, 2010 4:42 pm

Re: Store Skill MySQL Error

Post 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
I have promises to keep and miles to go before I sleep.
Top
_DS_
L2j Veteran
L2j Veteran
Posts: 3437
Joined: Wed Apr 30, 2008 8:53 am
Location: Russia

Re: Store Skill MySQL Error

Post by _DS_ »

Something wrong with your server skills - 1434 has no level.
Commiter of the shit
public static final int PI = 3.1415926535897932384626433832795;
Top
Starter
Posts: 484
Joined: Sat Jan 23, 2010 4:42 pm

Re: Store Skill MySQL Error

Post 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
I have promises to keep and miles to go before I sleep.
Top
MasterJinz
Posts: 54
Joined: Mon Sep 27, 2010 9:01 pm

Re: Store Skill MySQL Error

Post 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
Sry for bad english :)
Top
Starter
Posts: 484
Joined: Sat Jan 23, 2010 4:42 pm

Re: Store Skill MySQL Error

Post 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.. :/
I have promises to keep and miles to go before I sleep.
Top
Post Reply

Return to “High Five Support”