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
Player Инквизитор reverted to base class. Possibly has tried a relogin exploit while subclassing.Could not restore classes for Инквизитор: com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '1.7413527201E10' in column '3' is outside valid range for the datatype INTEGER.com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '1.7413527201E10' in column '3' is outside valid range for the datatype INTEGER. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1024) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:986) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:981) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.ResultSetImpl.throwRangeException(ResultSetImpl.java:7970) at com.mysql.jdbc.ResultSetImpl.parseIntAsDouble(ResultSetImpl.java:7199) at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2702) at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2813) at com.mchange.v2.c3p0.impl.NewProxyResultSet.getInt(NewProxyResultSet.java:2573) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restoreSubClassData(L2PcInstance.java:7566) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7373) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1112) at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:496) at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:92) at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:92) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619)
I think player try to do a multi-profession? Somebody can help me to avoid this? Thanks.
As you can see, 'sp' column is saved as integer:
storeCharSub():
statement.setInt(2, subClass.getSp());
so server technically can't save so big value (17413527201).
Check - as usual, any suspective things
Commiter of the shit
public static final int PI = 3.1415926535897932384626433832795;
it can happen on hi-rate sp player killing and killing mobs, get SP and if is autoskilllearn - he cant spend it. so SP accumulates)
exit - SP rate must be low. or change to "long" in core.
Tiger, once tasted human flesh, will want to taste it again
L2J - the place where glad to see you any time!
Could not restore classes for Инквизитор: com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '9.180546785E9' in column '3' is outside valid range for the datatype INTEGER.com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '9.180546785E9' in column '3' is outside valid range for the datatype INTEGER. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1024) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:986) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:981) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.ResultSetImpl.throwRangeException(ResultSetImpl.java:7970) at com.mysql.jdbc.ResultSetImpl.parseIntAsDouble(ResultSetImpl.java:7199) at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2702) at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2813) at com.mchange.v2.c3p0.impl.NewProxyResultSet.getInt(NewProxyResultSet.java:2573) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restoreSubClassData(L2PcInstance.java:7566) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7373) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1112) at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:496) at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:92) at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:92) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619)Could not restore char subclass info: com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '1.7413527201E10' in column '2' is outside valid range for the datatype INTEGER.Could not restore classes for Инквизитор: com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '1.7413527201E10' in column '3' is outside valid range for the datatype INTEGER.com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '1.7413527201E10' in column '3' is outside valid range for the datatype INTEGER. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1024) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:986) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:981) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.ResultSetImpl.throwRangeException(ResultSetImpl.java:7970) at com.mysql.jdbc.ResultSetImpl.parseIntAsDouble(ResultSetImpl.java:7199) at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2702) at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2813) at com.mchange.v2.c3p0.impl.NewProxyResultSet.getInt(NewProxyResultSet.java:2573) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restoreSubClassData(L2PcInstance.java:7566) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7373) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1112) at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:496) at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:92) at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:92) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619)
