• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

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

Kuroshere

New Member
Joined
Jun 27, 2016
Messages
1
Reaction score
0
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'
 
Hey Red, currently getting this error
Code:
 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?
 
Solved, much appreciated.
Although for me it had to be ran as:
SQL:
ALTER TABLE players ADD rebirth int(11) NOT NULL default 0;
Much appreciated man.
 
Back
Top