Could not store char base data

[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?

[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)

[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.

[qwerty13]

I am check, yes, this happens only when punish time is too big. Its my moderators issue.
Thanks guys for your explanations.