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_Actions.reward_player' 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
				hlstats_Events_PlayerPlayerActions.playerId,
				hlstats_Players.lastName AS playerName,
				hlstats_Players.flag as flag,
				COUNT(hlstats_Events_PlayerPlayerActions.id) AS obj_count,
				COUNT(hlstats_Events_PlayerPlayerActions.id) * hlstats_Actions.reward_player AS obj_bonus
			FROM
				hlstats_Events_PlayerPlayerActions, hlstats_Players, hlstats_Actions
			WHERE
				hlstats_Actions.code = 'domination' AND
				hlstats_Players.game = 'css' AND
				hlstats_Players.playerId = hlstats_Events_PlayerPlayerActions.playerId AND
				hlstats_Events_PlayerPlayerActions.actionId = hlstats_Actions.id AND
				hlstats_Players.hideranking = '0'
			GROUP BY
				hlstats_Events_PlayerPlayerActions.playerId
			ORDER BY
				obj_count desc,
				playerName desc
			LIMIT 0,40