Good morning people, everything fine?! (I use XAMPP V7.1.1 - Control panel 3.2.2) Older version because only it ran this site!
I have an error related to TOPS GUILDS,
the mistake:
Linha 17:
Enabling debug, for more details on the error:
If you can help me, thank you!!
I have an error related to TOPS GUILDS,
the mistake:
Code:
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\latestnews.php on line 17
Linha 17:
Code:
foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `player_deaths` pd ON `pd`.`killed_by` = `p`.`name` LEFT JOIN `guild_membership` gm ON `p`.`id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id` WHERE `g`.`id` > 0 AND `pd`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 4;') as $guild)
Enabling debug, for more details on the error:
Code:
SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `player_deaths` pd ON `pd`.`killed_by` = `p`.`name` LEFT JOIN `guild_membership` gm ON `p`.`id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id` WHERE `g`.`id` > 0 AND `pd`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 4;
SQLSTATE: 42S02
Driver code: 1146
Error message: Table 'otx.guild_membership' doesn't exist
If you can help me, thank you!!
Last edited: