Mysql-server, erro ou duvida?
Ola, tenho um server de Tibia que roda o banco de dados mysql da plataforma Debian versão Lenny, porem quando eu executo o sql abaixo, da o seguinte erro, #1062 - Duplicate entry '2-0' for key 1
.
Porem se vocês notarem não tem nenhuma duplicação, todos as outras tabelas estão ok, só a dos players é que ta dando "pau" no INSERT, e o interessante é que se for de um em um da erro mas ele guarda no banco de dados.
Eu acho que o problema é por que a tabela é grande demais, tem mas de 50 campos, porem procurei na net e não achei nada que me ajuda-se, se alguém poder dar uma luz eu agradeço.
--
-- Estrutura da tabela `players`
--
CREATE TABLE IF NOT EXISTS `players` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`world_id` tinyint(2) unsigned NOT NULL default '0',
`group_id` int(11) NOT NULL default '1',
`account_id` int(11) NOT NULL default '0',
`level` int(11) NOT NULL default '1',
`vocation` int(11) NOT NULL default '0',
`health` int(11) NOT NULL default '150',
`healthmax` int(11) NOT NULL default '150',
`experience` bigint(20) NOT NULL default '0',
`lookbody` int(11) NOT NULL default '0',
`lookfeet` int(11) NOT NULL default '0',
`lookhead` int(11) NOT NULL default '0',
`looklegs` int(11) NOT NULL default '0',
`looktype` int(11) NOT NULL default '136',
`lookaddons` int(11) NOT NULL default '0',
`maglevel` int(11) NOT NULL default '0',
`mana` int(11) NOT NULL default '0',
`manamax` int(11) NOT NULL default '0',
`manaspent` int(11) NOT NULL default '0',
`soul` int(10) unsigned NOT NULL default '0',
`town_id` int(11) NOT NULL default '0',
`posx` int(11) NOT NULL default '0',
`posy` int(11) NOT NULL default '0',
`posz` int(11) NOT NULL default '0',
`conditions` blob NOT NULL,
`cap` int(11) NOT NULL default '0',
`sex` int(11) NOT NULL default '0',
`lastlogin` bigint(20) unsigned NOT NULL default '0',
`lastip` int(10) unsigned NOT NULL default '0',
`save` tinyint(1) NOT NULL default '1',
`skull` tinyint(1) unsigned NOT NULL default '0',
`skulltime` int(11) NOT NULL default '0',
`rank_id` int(11) NOT NULL default '0',
`guildnick` varchar(255) NOT NULL default '',
`lastlogout` bigint(20) unsigned NOT NULL default '0',
`blessings` tinyint(2) NOT NULL default '0',
`balance` bigint(20) NOT NULL default '0',
`stamina` bigint(20) NOT NULL default '151200000' COMMENT 'stored in miliseconds',
`direction` int(11) NOT NULL default '2',
`loss_experience` int(11) NOT NULL default '100',
`loss_mana` int(11) NOT NULL default '100',
`loss_skills` int(11) NOT NULL default '100',
`loss_containers` int(11) NOT NULL default '100',
`loss_items` int(11) NOT NULL default '100',
`premend` int(11) NOT NULL default '0' COMMENT 'NOT IN USE BY THE SERVER',
`online` tinyint(1) NOT NULL default '0',
`marriage` int(10) unsigned NOT NULL default '0',
`marrystatus` int(10) unsigned NOT NULL,
`promotion` int(11) NOT NULL default '0',
`deleted` tinyint(1) NOT NULL default '0',
`description` varchar(255) NOT NULL default '',
`created` int(11) NOT NULL default '0',
`nick_verify` int(11) NOT NULL default '0',
`old_name` varchar(255) NOT NULL default '',
`hide_char` int(11) NOT NULL default '0',
`comment` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`deleted`),
KEY `account_id` (`account_id`),
KEY `group_id` (`group_id`),
KEY `online` (`online`),
KEY `deleted` (`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=216 ;
--
-- Gatilhos `players`
--
DROP TRIGGER IF EXISTS `tibia_roxpox`.`oncreate_players`;
DELIMITER //
CREATE TRIGGER `tibia_roxpox`.`oncreate_players` AFTER INSERT ON `tibia_roxpox`.`players`
FOR EACH ROW BEGIN
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END
//
DELIMITER ;
DROP TRIGGER IF EXISTS `tibia_roxpox`.`ondelete_players`;
DELIMITER //
CREATE TRIGGER `tibia_roxpox`.`ondelete_players` BEFORE DELETE ON `tibia_roxpox`.`players`
FOR EACH ROW BEGIN
DELETE FROM `bans` WHERE `type` IN (2, 5) AND `value` = OLD.`id`;
UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;
END
//
DELIMITER ;
--
-- Extraindo dados da tabela `players`
--
INSERT INTO `players` (`id`, `name`, `world_id`, `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`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `marrystatus`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES
(1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 32360, 31782, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 0, '', 0, 0, '', 0, ''),
(2, 'Rook Sample', 0, 1, 1, 7, 0, 185, 185, 0, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 32360, 31782, 7, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, 0, '', 1284173987, 1, '', 1, ''),
(3, 'Sorcerer Sample', 0, 1, 1, 7, 1, 185, 185, 0, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 32360, 31782, 7, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, 0, '', 1284173987, 1, '', 1, ''),
...
Reply to: