Ir para conteúdo
  • 0

leozinpbb

Pergunta

Galera como assim do nada minha tabela players e apagada do nada pela 2x , e outro dia foi a do player_depotitens 

 surgiram esse erro na minha distro ( uso linux ubutu 12.04 ) , me ajudem ai pfv.

 

Erro Distro :

Citar

mysql_store_result(): SELECT `TRIGGER_NAME` FROM `information_schema`.`triggers` WHERE `TRIGGER_SCHEMA` = 'fuckpl' AND `TRIGGER_NAME` = 'ondelete_accounts'; - MYSQL ERROR: Table '/tmp/#sql_164_0' is marked as crashed and should be repaired (1194) 
> Trigger: ondelete_accounts does not exist, creating it... 
mysql_real_query(): CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN(1, 2) AND `value` = OLD.`id`; END; - MYSQL ERROR: This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' (1235) 
mysql_store_result(): SELECT `TRIGGER_NAME` FROM `information_schema`.`triggers` WHERE `TRIGGER_SCHEMA` = 'fuckpl' AND `TRIGGER_NAME` = 'oncreate_guilds'; - MYSQL ERROR: Table '/tmp/#sql_164_0' is marked as crashed and should be repaired (1194) 
> Trigger: oncreate_guilds does not exist, creating it... 
mysql_real_query(): CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds` FOR EACH ROW BEGIN INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`); END; - MYSQL ERROR: This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' (1235) 
mysql_store_result(): SELECT `TRIGGER_NAME` FROM `information_schema`.`triggers` WHERE `TRIGGER_SCHEMA` = 'fuckpl' AND `TRIGGER_NAME` = 'ondelete_guilds'; - MYSQL ERROR: Table '/tmp/#sql_164_0' is marked as crashed and should be repaired (1194) 
> Trigger: ondelete_guilds does not exist, creating it... 
mysql_real_query(): CREATE TRIGGER `ondelete_guilds` BEFORE DELETE ON `guilds` FOR EACH ROW BEGIN UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`); END; - MYSQL ERROR: This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' (1235) 
mysql_store_result(): SELECT `TRIGGER_NAME` FROM `information_schema`.`triggers` WHERE `TRIGGER_SCHEMA` = 'fuckpl' AND `TRIGGER_NAME` = 'oncreate_players'; - MYSQL ERROR: Table '/tmp/#sql_164_0' is marked as crashed and should be repaired (1194) 
> Trigger: oncreate_players does not exist, creating it... 
mysql_real_query(): 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; - MYSQL ERROR: This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' (1235) 
mysql_store_result(): SELECT `TRIGGER_NAME` FROM `information_schema`.`triggers` WHERE `TRIGGER_SCHEMA` = 'fuckpl' AND `TRIGGER_NAME` = 'ondelete_players'; - MYSQL ERROR: Table '/tmp/#sql_164_0' is marked as crashed and should be repaired (1194) 
> Trigger: ondelete_players does not exist, creating it... 
mysql_real_query(): CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` = 2 AND `value` = OLD.`id`; UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`; END; - MYSQL ERROR: This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' (1235) 
> Optimizing table: bans... [success] 
> Optimizing table: players... [success] 
> Optimizing table: tiles... Failed connecting to database - MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2002) 
Failed connecting to database - MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2002) 
Failed connecting to database - MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2002) 
Failed connecting to database - MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2002) 
Failed connecting to database - MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2002) 
Failed connecting to database - MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2002) 
Failed connecting to database - MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2002) 
Failed connecting to database - MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2002) 
Failed connecting to database - MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2002) 
Failed connecting to database - MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2002) 
Failed connecting to database - MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2002) 
Unable to reconnect - too many attempts, limit exceeded! 
mysql_real_query(): OPTIMIZE TABLE `tiles`; - MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2006) 
[failure] 

 

Link para o comentário
Compartilhar em outros sites

0 respostass a esta questão

Posts Recomendados

Até agora não há respostas para essa pergunta

×
×
  • Criar Novo...