offline traders problem

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
User avatar
goncafa
Posts: 385
Joined: Thu Aug 05, 2010 2:10 pm
Location: Santiago, Chile

offline traders problem

Post by goncafa »

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
Best Regards

PS: im sorry my bad english.
Image
Top
Starter
Posts: 484
Joined: Sat Jan 23, 2010 4:42 pm

Re: offline traders problem

Post by Starter »

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)
I have promises to keep and miles to go before I sleep.
Top
User avatar
pinkcore
Posts: 247
Joined: Fri Jul 24, 2009 3:04 am
Location: Czech Republic

Re: offline traders problem

Post by pinkcore »

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?
I'm not here only for food!
Top
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Re: offline traders problem

Post by momo61 »

Did you update your SQL properly ?
Top
hope
Posts: 1160
Joined: Thu Aug 30, 2007 5:17 pm

Re: offline traders problem

Post by hope »

value for column 'item' make value bigger
Top
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Re: offline traders problem

Post by momo61 »

;) it seems that you are using custom itemz ;)
Top
Solace
Posts: 17
Joined: Thu Jan 13, 2011 1:40 am

Re: offline traders problem

Post by Solace »

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.
Top
User avatar
MELERIX
L2j Veteran
L2j Veteran
Posts: 6667
Joined: Sat Sep 23, 2006 11:31 pm
Location: Chile
Contact:
Contact MELERIX

Re: offline traders problem

Post by MELERIX »

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

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.
Top
Starter
Posts: 484
Joined: Sat Jan 23, 2010 4:42 pm

Re: offline traders problem

Post by Starter »

No custom items here. oO
I have promises to keep and miles to go before I sleep.
Top
User avatar
JIV
L2j Veteran
L2j Veteran
Posts: 1882
Joined: Sun Jan 06, 2008 8:17 pm
Location: Slovakia
Contact:
Contact JIV

Re: offline traders problem

Post by JIV »

really? nobody sees the real problem?
Top
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: offline traders problem

Post by jurchiks »

hmmm... negative ID? dunno...
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Top
User avatar
JIV
L2j Veteran
L2j Veteran
Posts: 1882
Joined: Sun Jan 06, 2008 8:17 pm
Location: Slovakia
Contact:
Contact JIV

Re: offline traders problem

Post by JIV »

wrong
Top
User avatar
Flashy
Posts: 310
Joined: Mon Sep 29, 2008 11:49 am
Location: Germany

Re: offline traders problem

Post by Flashy »

wrong title in shop...
Top
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: offline traders problem

Post by jurchiks »

title is stored in `character_offline_trade`, not `character_offline_trade_items`
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Top
User avatar
JIV
L2j Veteran
L2j Veteran
Posts: 1882
Joined: Sun Jan 06, 2008 8:17 pm
Location: Slovakia
Contact:
Contact JIV

Re: offline traders problem

Post by JIV »

momo61 wrote:;) it seems that you are using custom itemz ;)
Wrong
Flashy wrote:wrong title in shop...
Wrong
Top
Post Reply

Return to “High Five Support”