HLstatsX Community Edition
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Games

 Game  Players  Top Player  Top Clan
ERROR
Database Error

Server Address: 5.9.16.178:4936
Server Username: hlstats32

Error Diagnostic:
Bad query.

Server Error: (144) Table './hlstats/hlstats_Clans' is marked as crashed and last (automatic?) repair failed

Last SQL Query:
				SELECT
					hlstats_Clans.clanId,
					hlstats_Clans.name,
					AVG(hlstats_Players.skill) AS skill,
					AVG(hlstats_Players.kills) AS kills,
					COUNT(hlstats_Players.playerId) AS numplayers
				FROM
					hlstats_Clans
				LEFT JOIN
					hlstats_Players
				ON
					hlstats_Players.clan = hlstats_Clans.clanId
				WHERE
					hlstats_Clans.game='arena'
					AND hlstats_Clans.hidden = 0
					AND hlstats_Players.hideranking=0
				GROUP BY
					hlstats_Clans.clanId
				HAVING
					skill IS NOT NULL
					AND numplayers >= 3
				ORDER BY
					skill DESC
				LIMIT 1