• 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!

Linux Sample error

C

Cristianvrb

New Member
Joined
Jul 20, 2014
Messages
9
Reaction score
0
  • I do not know what I did wrong, but I think I deleted the samples. Now is giving this error when creating char the site:
    The Following Errors Have Occurred:
    Wrong configuration characters. Try again or contact with admin. ADMIN: Edit file config / config.php and Set valid characters to copy names. Character to copySorcerer Sample does not exist.

    game and when I try to log account manager of this error:
    Your character could not be loaded
 
Sort by date Sort by votes
/phpmyadmin -> sql -> [text field]
Code: 
    INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, skulltime, skull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Rook Sample", 1, 1, 1, 0, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.tim e().',1,1)
    INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, skulltime, skull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Sorcerer Sample", 1, 1, 1, 1, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.tim e().',1,1)
    INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, skulltime, skull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Druid Sample", 1, 1, 1, 2, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.tim e().',1,1)
    INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, skulltime, skull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Paladin Sample", 1, 1, 1, 3, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.tim e().',1,1)
    INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, skulltime, skull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Knight Sample", 1, 1, 1, 4, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.tim e().',1,1)

Next time post your tfs version :)
 
Upvote 0 Downvote
[20:50:55.456] Error while saving player: Loucura.
[20:50:55.452] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1405903847, `lastip` = 2907103674, `level` = 8, `group_id` = 1, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 157, `posy` = 54, `posz` = 7, `cap` = 435, `sex` = 1, `balance` = 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1405903855, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 19 LIMIT 1; - MYSQL ERROR: Unknown column 'castViewers' in 'field list' (1054)
[20:50:55.454] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1405903847, `lastip` = 2907103674, `level` = 8, `group_id` = 1, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 157, `posy` = 54, `posz` = 7, `cap` = 435, `sex` = 1, `balance` = 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1405903855, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 19 LIMIT 1; - MYSQL ERROR: Unknown column 'castViewers' in 'field list' (1054)
[20:50:55.456] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1405903847, `lastip` = 2907103674, `level` = 8, `group_id` = 1, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 157, `posy` = 54, `posz` = 7, `cap` = 435, `sex` = 1, `balance` = 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1405903855, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 19 LIMIT 1; - MYSQL ERROR: Unknown column 'castViewers' in 'field list' (1054)
[20:50:55.456] Error while saving player: Loucura.









new error
 
Upvote 0 Downvote
Cristianvrb said:
[20:50:55.456] Error while saving player: Loucura.
[20:50:55.452] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1405903847, `lastip` = 2907103674, `level` = 8, `group_id` = 1, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 157, `posy` = 54, `posz` = 7, `cap` = 435, `sex` = 1, `balance` = 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1405903855, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 19 LIMIT 1; - MYSQL ERROR: Unknown column 'castViewers' in 'field list' (1054)
[20:50:55.454] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1405903847, `lastip` = 2907103674, `level` = 8, `group_id` = 1, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 157, `posy` = 54, `posz` = 7, `cap` = 435, `sex` = 1, `balance` = 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1405903855, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 19 LIMIT 1; - MYSQL ERROR: Unknown column 'castViewers' in 'field list' (1054)
[20:50:55.456] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1405903847, `lastip` = 2907103674, `level` = 8, `group_id` = 1, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 157, `posy` = 54, `posz` = 7, `cap` = 435, `sex` = 1, `balance` = 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1405903855, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 19 LIMIT 1; - MYSQL ERROR: Unknown column 'castViewers' in 'field list' (1054)
[20:50:55.456] Error while saving player: Loucura.









new error
Click to expand...

That because you didn't add cast lines or have problem with it

try add it
Code: 
ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0',
ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0',
ADD  `castDescription` VARCHAR( 255 ) NOT NULL
 
Upvote 0 Downvote
elking said:
That because you didn't add cast lines or have problem with it

try add it
Code: 
ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0',
ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0',
ADD  `castDescription` VARCHAR( 255 ) NOT NULL
Click to expand...



#1060 - Duplicate column name 'cast'
 
Upvote 0 Downvote
Back
Top