kacpersky
Mr. Brightside
- Joined
- Jan 25, 2009
- Messages
- 499
- Reaction score
- 3
when i try to import database on console i get this error.
yo5jddafsdfgdw4 is the name of database
line 26582:
someone could help me ?
yo5jddafsdfgdw4 is the name of database
PHP:
ERROR 1146 (42S02) at line 26582: Table 'yo5jddafsdfgdw4.player_skills' doesn't exist
line 26582:
PHP:
--
-- Triggers `players`
--
DELIMITER //
CREATE TRIGGER `yo5jddafsdfgdw4`.`oncreate_players` AFTER INSERT ON `yo5jddafsdfgdw4`.`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 ;