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

ERROR
Database Error

Server Address: 127.0.0.1
Server Username: www973_ustats

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'www973_stats.hlstats_Awards.awardId' 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
				MAX(hlstats_Players_Awards.awardTime) AS awardTime,
				hlstats_Awards.name,
				hlstats_Awards.verb,
				COUNT(verb) AS count,
				hlstats_Awards.awardId
			FROM
				hlstats_Players_Awards
			INNER JOIN
				hlstats_Awards
			ON
				hlstats_Awards.awardId = hlstats_Players_Awards.awardId
			WHERE
				hlstats_Players_Awards.playerId = 3493
			GROUP BY
				hlstats_Awards.name,
				hlstats_Awards.verb
			ORDER BY
				awardTime desc,
				name desc
			LIMIT
				0,50