• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

dropQuery

bomba

bomba

Member
Joined
Feb 26, 2008
Messages
635
Reaction score
7
Location
Brazil
How I can drop the query(?):
PHP: 
ALTER TABLE `players` ADD `marrystatus` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `marriage` ;
 
Sort by date Sort by votes
I have dropped and have an error on my server:

[15/02/2009 23:20:11] mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `redskulltime`, `redskull`, `guildnick`, `rank_id`, `town_id`, `balance`, `stamina`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items`, `marriage`, `promotion` FROM `players` WHERE `name` = 'Underkill' AND `deleted` = 0;: MYSQL ERROR: Unknown column 'marriage' in 'field list'
Click to expand...
 
Upvote 0 Downvote
Probably you have dropped 'marriage' field instead 'marrystatus'? Server is using this marriage field, but it does not exist in your db.

Code: 
ALTER TABLE `players` ADD `marriage` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `online`;
 
Upvote 0 Downvote
Back
Top