L2J Server

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 4477:
L2JDP Revision 7747:

I have been updated my server to latest version of SNV and now, vendor offline traders are cleaning each restart, only de buy traders offline are saved.

Best Regards

And I think I got the appropriate error in the gs log:

Starter wrote:And I think I got the appropriate error in the gs log:

Code: Select all

OfflineTradersTable[storeTradeItems()]: Error while saving offline trader: ---com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'item' at row 1com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'item' at row 1        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)        at com.l2jserver.gameserver.datatables.OfflineTradersTable.storeOffliners(OfflineTradersTable.java:103)        at com.l2jserver.gameserver.Shutdown.run(Shutdown.java:222)

Out of range value for column 'item' at row 1

Have you some custom items?

Did you update your SQL properly ?

value for column 'item' make value bigger

it seems that you are using custom itemz

Yea, I'm going to guess he did update the tables and that's what caused the problem.

SQL Update 20110112 modifies the item column in the offline shop table, making it a smallint. I'd like to know who's bright idea this was... Change the `item` column in `character_offline_trade_items` back to an int and all will be good.

Enjoy.

INT use more bytes (4) than SMALLINT tha only use (2)

so better for you is use custom items with ID <= 65535

you don't need to use big ID for custom items, currently max number used by NCZ0ft in client is 22172.

so you can make custom items from 22173 -> 65535

you have 43362 IDs free! for you available in client.

No custom items here. oO

really? nobody sees the real problem?

hmmm... negative ID? dunno...

wrong

wrong title in shop...

title is stored in `character_offline_trade`, not `character_offline_trade_items`

momo61 wrote: it seems that you are using custom itemz

Wrong

Flashy wrote:wrong title in shop...

Wrong