Trouble creating character using znote aac

[hangnail34]

Hello, i'm having trouble creating a character with znote after i added a column under players named 'rebirths' it was working fine until today and i got this error when i clicked create character

string(750) "INSERT INTO [ICODE]players[/ICODE]([ICODE]name[/ICODE], [ICODE]group_id[/ICODE], [ICODE]account_id[/ICODE], [ICODE]level[/ICODE], [ICODE]vocation[/ICODE], [ICODE]health[/ICODE], [ICODE]healthmax[/ICODE], [ICODE]experience[/ICODE], [ICODE]lookbody[/ICODE], [ICODE]lookfeet[/ICODE], [ICODE]lookhead[/ICODE], [ICODE]looklegs[/ICODE], [ICODE]looktype[/ICODE], [ICODE]lookaddons[/ICODE], [ICODE]maglevel[/ICODE], [ICODE]mana[/ICODE], [ICODE]manamax[/ICODE], [ICODE]manaspent[/ICODE], [ICODE]soul[/ICODE], [ICODE]town_id[/ICODE], [ICODE]posx[/ICODE], [ICODE]posy[/ICODE], [ICODE]posz[/ICODE], [ICODE]conditions[/ICODE], [ICODE]cap[/ICODE], [ICODE]sex[/ICODE], [ICODE]lastlogin[/ICODE], [ICODE]lastip[/ICODE], [ICODE]save[/ICODE], [ICODE]skull[/ICODE], [ICODE]skulltime[/ICODE], [ICODE]lastlogout[/ICODE], [ICODE]blessings[/ICODE], [ICODE]balance[/ICODE], [ICODE]skill_fist[/ICODE], [ICODE]skill_club[/ICODE], [ICODE]skill_sword[/ICODE], [ICODE]skill_axe[/ICODE], [ICODE]skill_dist[/ICODE], [ICODE]skill_shielding[/ICODE], [ICODE]skill_fishing[/ICODE]) VALUES ('Corrupt Titan', '1', '2', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '0', '1', '0', '0', '0', '0', '0', '10', '10', '10', '10', '10', '10', '10');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'player_id' in 'field list'

Tried to add the column in my db but it wouldn't work

 

[Znote]

How did you add the rebirth column?
When adding custom columns, it should have a default value configured to it so other queries don't break.

 

[hangnail34]

ALTER TABLE players ADD rebirths INT NOT NULL DEFAULT 0;

it was from the script post i used for it.