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

[appealarms 0]

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

Edited April 20, 2014 by appealarms

[Emistry 144]

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

[appealarms 0]

 

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

Thank you very much.

This error has been solved.

[quesoph 105]

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 1244]

 

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)