Hello !
I make DB on old PMA version and now have a problem with skills save.
When i sew problem with skills save i update my PMA and want add triggers (code on down)
But while adding is this error:
While make a new DB triggers be adding without errors, on this time i have 700 players and can't make new DB ;/
Maybe someone know how i can make this ?
I make DB on old PMA version and now have a problem with skills save.
When i sew problem with skills save i update my PMA and want add triggers (code on down)
PHP:
DELIMITER |
CREATE TRIGGER `oncreate_players`
AFTER INSERT
ON `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 ;
But while adding is this error:
PHP:
Fatal error: Maximum execution time of 300 seconds exceeded in /usr/share/phpmyadmin/libraries/import/sql.php on line 99
While make a new DB triggers be adding without errors, on this time i have 700 players and can't make new DB ;/
Maybe someone know how i can make this ?