HLstatsX :: Game-server.sk - Game-server.sk | Fy-Snow only - Player Details

Player Information

Player Profile
matei
Location: Cluj-Napoca, Romania
Steam: STEAM_0:1:584017345
Status: Offline
Click here to add as friend
Karma: In good standing
Member of Clan:	(None)
Real Name:	(Not Specified)
E-mail Address:	(Not Specified)
Home Page:	(Not Specified)
MM Rank:
Last Connect:*	Sun. Apr. 28th, 2024 @ 21:26:55
Total Connection Time:	0d 13:01:13h
Average Ping:*	-
Favorite Server:*	Game-server.sk \| Fy-Snow only
Favorite Map:*	fy_snow
Favorite Weapon:*

ERROR

Database Error

Server Address: localhost
Server Username: root

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlstatsx.hlstats_Weapons.name' 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_Frags.weapon,
									hlstats_Weapons.name,
									COUNT(hlstats_Events_Frags.weapon) AS kills,
									SUM(hlstats_Events_Frags.headshot=1) as headshots
								FROM
									hlstats_Events_Frags
								LEFT JOIN
									hlstats_Weapons
								ON
									hlstats_Weapons.code = hlstats_Events_Frags.weapon
								WHERE
									hlstats_Events_Frags.killerId=692
								GROUP BY
									hlstats_Events_Frags.weapon
								ORDER BY
									kills desc, headshots desc
								LIMIT
									1