L2J Server

» Find Revision
L2J Revision Number:3301
L2JDP Revision Number:6418

Hello. I updated from G2, and i got this error:


Could not update item 269062619 in DB: Reason: Data truncation: Out of range val
ue for column 'count' at row 1
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu
mn 'count' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3513)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1761)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2046)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1964)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1949)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
at net.sf.l2j.gameserver.model.L2ItemInstance.updateInDb(L2ItemInstance.
java:1480)
at net.sf.l2j.gameserver.model.L2ItemInstance.updateDatabase(L2ItemInsta
nce.java:1295)
at net.sf.l2j.gameserver.model.itemcontainer.ItemContainer.updateDatabas
e(ItemContainer.java:587)
at handlers.voicedcommandhandlers.Banking.useVoicedCommand(Unknown Sourc
e)
at handlers.chathandlers.ChatAll.handleChat(Unknown Source)
at net.sf.l2j.gameserver.network.clientpackets.Say2.runImpl(Say2.java:16

at net.sf.l2j.gameserver.network.clientpackets.L2GameClientPacket.run(L2
GameClientPacket.java:76)
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 find it to be in "items" table, at column "count", and its about adena count. Error happens once every few minutes, and i dont think it affects gameplay, but i would really like to understand it.
Anybody could help me figure this out ? Thanks in advance.

Sounds like someone didn't update properly. Check your SQL files. still using int instead of long maybe?

Thats it. I didnt knew what it was about at the begining, but now i get it. Still using int instead of long. Can i change it to long ? If so, how ? Thanks alot

i belive i found somth. should this work without losing data?

ALTER TABLE `items` MODIFY `count` BIGINT;

DeathCall wrote:i belive i found somth. should this work without losing data?

ALTER TABLE `items` MODIFY `count` BIGINT;

yes, it is a safe operation.

Apply ALL update scripts from update folder, or you will have different problems later. They are here not for increasing size.

Thanks. Problem fixed.
I didnt used update folder, i resolved some problems manually, now i know why update folder is there, better later then never. The question is, if i resolved those problems manually, should i have conflicts if i run all updates from update folder ? Gameserver running ok now ...

Update scripts will return error if already applied.

Thats it, thanks all for help and keep up the good work.