HLstatsX :: Game-server.sk - Counter-Strike

Daily Awards (Sunday 19 May)

AK47 No Award Winner 0 kills with ak47	AWP No Award Winner 0 snipings with awp	Best Latency No Award Winner 0 ms average connection	Colt M4A1 Carbine No Award Winner 0 kills with m4a1	Desert Eagle No Award Winner 0 kills with deagle
Dual Berretta Elites No Award Winner 0 kills with elite	Fusil Automatique No Award Winner 0 kills with famas	Galil No Award Winner 0 kills with galil	Glock No Award Winner 0 kills with glock18	Grenadier No Award Winner 0 kills with grenade
Headshot King No Award Winner 0 headshots	Knife Maniac No Award Winner 0 knifings	P90 No Award Winner 0 kills with p90	Shotgun No Award Winner 0 kills with m3 shotgun	Top Assassin No Award Winner 0 assassinations
Top Defuser No Award Winner 0 bomb defusions	Top Demolitionist No Award Winner 0 bomb plantings	Top Hostage Rescuer No Award Winner 0 hostages rescued	USP Master No Award Winner 0 kills with usp

Global Awards

AK47 cztry 2 kills with ak47	AWP No Award Winner 0 snipings with awp	Best Latency Baron Respect 92 16 ms average connection	Colt M4A1 Carbine cztry 1 kills with m4a1	Desert Eagle No Award Winner 0 kills with deagle
Dual Berretta Elites No Award Winner 0 kills with elite	Fusil Automatique No Award Winner 0 kills with famas	Galil No Award Winner 0 kills with galil	Glock No Award Winner 0 kills with glock18	Grenadier No Award Winner 0 kills with grenade
Headshot King cztry 2 headshots	Knife Maniac No Award Winner 0 knifings	P90 No Award Winner 0 kills with p90	Shotgun No Award Winner 0 kills with m3 shotgun	Top Assassin No Award Winner 0 assassinations
Top Defuser No Award Winner 0 bomb defusions	Top Demolitionist No Award Winner 0 bomb plantings	Top Hostage Rescuer No Award Winner 0 hostages rescued	USP Master No Award Winner 0 kills with usp

ERROR

Database Error

Server Address: localhost
Server Username: root

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlstatsx.hlstats_Ranks.rankId' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Last SQL Query:

		SELECT
			rankName,
			minKills,
			rankId,
			count(playerId) AS obj_count
		FROM
			hlstats_Ranks
		INNER JOIN
			hlstats_Players
		ON (
           hlstats_Ranks.game=hlstats_Players.game
           )	
		WHERE
			kills>=minKills
			AND kills<=maxKills
			AND hlstats_Ranks.game='cstrike'
		GROUP BY
			rankName,
			minKills