[SQL]: DB error - Field 'uniqueitem_counter' doesn't have a default value

[appealarms]

: DB error - Field 'uniqueitem_counter' doesn't have a default value
[Debug]: at c:herculessrccharchar.c:1626 -
INSERT INTO `char` (`account_id`, `char_num`, `name`, `zeny`, `status_point`,`st
r`, `agi`, `vit`, `int`, `dex`, `luk`, `max_hp`, `hp`,`max_sp`, `sp`, `hair`, `h
air_color`, `last_map`, `last_x`, `last_y`, `save_map`, `save_x`, `save_y`) VALU
ES ('2000000', '3', 'YJJJJGJJGFVCGVG', '0',  '48','1', '1', '1', '1', '1', '1',
'40', '40','11', '11','1', '0', 'new_1-1', '53', '111', 'new_1-1', '53', '111')
 

I got this Error.

Could anyone tell me How to solve this problem?

 

[Emistry]

ALTER TABLE `char` ALTER `uniqueitem_counter` SET DEFAULT '0'

 

[appealarms]

ALTER TABLE `char` ALTER `uniqueitem_counter` SET DEFAULT '0'

Thank you very much.

This error has been solved.

 

[quesoph]

check your sql-files/upgrades/

#1396893866ALTER TABLE `char` ADD COLUMN `uniqueitem_counter`  bigint(20) NOT NULL AFTER `unban_time`;INSERT INTO `sql_updates` (`timestamp`) VALUES (1396893866);

 

[Dastgir]

check your sql-files/upgrades/

#1396893866ALTER TABLE `char` ADD COLUMN `uniqueitem_counter`  bigint(20) NOT NULL AFTER `unban_time`;INSERT INTO `sql_updates` (`timestamp`) VALUES (1396893866);

But it does not have any Default value, so executing this to MySQL would also show some problem(if it contains data already)

and if any newly imported data is there, (there won't be any problem i guess, since uniqueitem is enabled bydefault now)