Alguém ajuda com esses erros na distro.

 

mysql_real_query(): SELECT `guild_id` FROM `guild_invites` WHERE `player_id` = 10 - MYSQL ERROR: Table 'onlycrazy.guild_invites' doesn't exist (1146)
[15:13:02.245] Biosil has logged in.
[15:13:06.805] Biosil has logged out.
[15:13:06.834] mysql_real_query(): DELETE FROM `guild_invites` WHERE player_id = 10 - MYSQL ERROR: Table 'onlycrazy.guild_invites' doesn't exist (1146)
[15:13:06.895] mysql_real_query(): DELETE FROM `guild_invites` WHERE player_id = 10 - MYSQL ERROR: Table 'onlycrazy.guild_invites' doesn't exist (1146)
[15:13:06.958] mysql_real_query(): DELETE FROM `guild_invites` WHERE player_id = 10 - MYSQL ERROR: Table 'onlycrazy.guild_invites' doesn't exist (1146)
[15:13:07.043] Error while saving player: Biosil.

 

Obs: O player não salva quando reloga volta tudo. ajudem Por favor.

aq ja esta informando o error [15:13:06.958] mysql_real_query(): DELETE FROM `guild_invites` WHERE player_id = 10 - MYSQL ERROR: Table 'onlycrazy.guild_invites' doesn't exist (1146)

na sua database falta a tabela guild_invites

Em 15/02/2018 em 16:22, Tchuka disse:

Alguém ajuda com esses erros na distro.

 

mysql_real_query(): SELECT `guild_id` FROM `guild_invites` WHERE `player_id` = 10 - MYSQL ERROR: Table 'onlycrazy.guild_invites' doesn't exist (1146)
[15:13:02.245] Biosil has logged in.
[15:13:06.805] Biosil has logged out.
[15:13:06.834] mysql_real_query(): DELETE FROM `guild_invites` WHERE player_id = 10 - MYSQL ERROR: Table 'onlycrazy.guild_invites' doesn't exist (1146)
[15:13:06.895] mysql_real_query(): DELETE FROM `guild_invites` WHERE player_id = 10 - MYSQL ERROR: Table 'onlycrazy.guild_invites' doesn't exist (1146)
[15:13:06.958] mysql_real_query(): DELETE FROM `guild_invites` WHERE player_id = 10 - MYSQL ERROR: Table 'onlycrazy.guild_invites' doesn't exist (1146)
[15:13:07.043] Error while saving player: Biosil.

 

Obs: O player não salva quando reloga volta tudo. ajudem Por favor.

importa pro seu banco de dados

CREATE TABLE `guild_invites`
(
   `player_id` INT NOT NULL DEFAULT 0,
   `guild_id` INT NOT NULL DEFAULT 0,
   UNIQUE (`player_id`, `guild_id`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
   FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

Eu tento cria a tabela no phpmyadmin e da esse erro: 

 

#1146 - Table 'theonlyone.guild_invites' doesn't exist 

Editado Fevereiro 17, 2018 7 anos por Tchuka (veja o histórico de edições)