Page 1 of 1
Could not store char base data
Posted: Thu Feb 11, 2010 10:30 am
by qwerty13
L2J Revision
3921:
L2JDP Revision
7043:
Sometimes i am see this messages in console:
Code: Select all
Could not store char base data: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'punish_ti$Could not store char base data: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'punish_ti$Could not store char base data: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'punish_ti$
This happens after update to revisions 3921\7043. What is that? Maybe im miss something in update?
Re: Could not store char base data
Posted: Thu Feb 11, 2010 10:51 am
by BiggBoss
the value you are trying to store in the column punish_ti (i guess is punish_time) is longer than the allowed by the column structure (INT UNSIGNED NOT NULL DEFAULT 0)
SQL INT = From -2^31 (-2.147.483.648) to 2^31-1 (2.147.483.647)
Re: Could not store char base data
Posted: Thu Feb 11, 2010 10:52 am
by janiii
characters table:
Code: Select all
`punish_timer` INT UNSIGNED NOT NULL DEFAULT 0,
that means, the timer can have values from 0 to 4294967295 miliseconds (~49 days). so you probably set the timer to more than that allowed value.
Re: Could not store char base data
Posted: Thu Feb 11, 2010 11:07 am
by qwerty13
I am check, yes, this happens only when punish time is too big. Its my moderators issue.
Thanks guys for your explanations.
