Unknown column 'players.rebirths' in 'field list'

[Kuroshere]

Hi guys, i have a problem, maybe someone can help me?
I create this column, but still:

Query:	SELECT id, name, password, premdays, lastday, email, key, group_id, create_ip, create_date, premium_points, page_access, location, rlname, email_new, email_new_time, email_code, next_email, last_post, flag FROM accounts WHERE name = 'k'
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT bans.id, bans.type, bans.value, bans.param, bans.active, bans.expires, bans.added, bans.admin_id, bans.comment FROM bans WHERE type = '3' AND value = '9438173' AND active = '1'
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT players.id, players.name, players.world_id, players.group_id, players.account_id, players.rebirths, players.level, players.vocation, players.health, players.healthmax, players.experience, players.lookbody, players.lookfeet, players.lookhead, players.looklegs, players.looktype, players.lookaddons, players.maglevel, players.mana, players.manamax, players.manaspent, players.soul, players.town_id, players.posx, players.posy, players.posz, players.conditions, players.cap, players.sex, players.lastlogin, players.lastip, players.save, players.skull, players.skulltime, players.rank_id, players.guildnick, players.lastlogout, players.blessings, players.balance, players.stamina, players.direction, players.loss_experience, players.loss_mana, players.loss_skills, players.loss_containers, players.loss_items, players.premend, players.online, players.marriage, players.promotion, players.deleted, players.description, players.create_ip, players.create_date, players.comment, players.hide_char FROM players WHERE account_id = '9438173' ORDER BY name ASC
SQLSTATE:	42S22
Driver code:	1054
Error message:	Unknown column 'players.rebirths' in 'field list'

 

[ranita]

Hey Red, currently getting this error

 Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '9438173' ORDER BY name ASC; = 7' at line 1

Any solutions?

 

[Dakos]

ALTER TABLE players ADD rebirths int(11) NOT NULL default 0;

 

[ranita]

Solved, much appreciated.
Although for me it had to be ran as:

ALTER TABLE players ADD rebirth int(11) NOT NULL default 0;

Much appreciated man.