• 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 mysql - problem with import

kacpersky

Mr. Brightside
Joined
Jan 25, 2009
Messages
499
Reaction score
3
when i import database i get this error:
PHP:
ERROR 1146 (42S02) at line 4531: Table 'roxor.player_skills' doesn't exist

line 4531:
PHP:
INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `redskull`, `redskulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `premend`, `online`, `created`, `nick_verify`, `hide_char`, `comment`, `exphist_lastexp`, `exphist1`, `exphist2`, `exphist3`, `exphist4`, `exphist5`, `exphist6`, `exphist7`, `onlinetimetoday`, `onlinetime1`, `onlinetime2`, `onlinetime3`, `onlinetime4`, `onlinetime5`, `onlinetime6`, `onlinetime7`, `onlinetimeall`) VALUES

someone could help me ?
 
Last edited:
CREATE TABLE `roxon`.`roxon.player_skills` (
`sd` VARCHAR( 12 ) NOT NULL
) ENGINE = MYISAM

#1103 - Incorrect table name 'roxor.player_skills'

i create i table : player_skills. Now its ok, bu i get another error:
PHP:
Cannot add or update a child row: a foreign key constraint fails (`roxon/#sql-1c3f_334`, CONSTRAINT `guild_ranks_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE)
 
Last edited:
Back
Top