Скилл "Data truncation: Out of range value for column 'skill_id' at row 1"

[trane18]

Добавил 2 кастом скила на рейт адены и на рейт експ\сп , все работает но появилась ошибка про то что значение выходит за пределы. Хроники классик.

Ошибка

[21:36:22] ERROR Error could not store skills!
com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'skill_id' at row 1
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:95)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:938)
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:359)
at com.mysql.cj.jdbc.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:552)
at l2.gameserver.model.Player.a(Unknown Source)
at l2.gameserver.model.Player.addSkill(Unknown Source)
at l2.gameserver.model.Player.a(Unknown Source)
at l2.gameserver.model.Player.setActiveSubClass(Unknown Source)
at l2.gameserver.model.Player.restoreCharSubClasses(Unknown Source)
at l2.gameserver.model.Player.restore(Unknown Source)
at l2.gameserver.network.l2.GameClient.loadCharFromDisk(Unknown Source)
at l2.gameserver.network.l2.c2s.CharacterSelected.runImpl(Unknown Source)
at l2.gameserver.network.l2.c2s.L2GameClientPacket.run(Unknown Source)
at l2.commons.net.nio.impl.MMOExecutableQueue.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:840)


Скилл

<skill id="99901" levels="5" name="ExpBalance">
<table name="#magicLevel">1 40 52 61 76</table>
<table name="#power">1.1 0.9 0.7 0.5 0.3</table>
<set name="icon" val="icon.skill10079_2"/>
<set name="magicLevel" val="#magicLevel"/>
<set name="target" val="TARGET_SELF"/>
<set name="skillType" val="HARDCODED"/>
<set name="operateType" val="OP_PASSIVE"/>
<set name="isCommon" val="true"/>
<for>
<mul order="0x30" stat="ExpMultiplier" val="#power"/>
<mul order="0x30" stat="SpMultiplier" val="#power"/>
</for>
</skill>


Поиск юзал похожая ошибка была с ботами , но не уверен что мне подходит то решение.

 

[zerohero]

maybe skill_id 99901 is too long for the data type in use.

 

[aly]

@trane18 try ID not bigger than 32000

 

[trane18]

I'll try it and report back on the results. Thanks.

 

[trane18]

[EN] Yes, the problem is gone, it was necessary to make the skill ID smaller, thanks
[RU] Да, проблема ушла , необходимо было сделать ид скила меньше , спасибо