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

Banner
  Find a Player or Clan

Search For:
In:
Game:


  Search Results



ERROR
Database Error

Server Address: 192.168.1.189
Server Username: hlstatsxce

Error Diagnostic:
Bad query.

Server Error: (1267) Illegal mix of collations (utf8mb4_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

Last SQL Query:
					SELECT
						hlstats_PlayerNames.playerId AS player_id,
						hlstats_PlayerNames.name,
						hlstats_Players.flag,
						hlstats_Players.country,
						hlstats_Games.name AS gamename
					FROM
						hlstats_PlayerNames
					LEFT JOIN
						hlstats_Players
					ON
						hlstats_Players.playerId = hlstats_PlayerNames.playerId
					LEFT JOIN
						hlstats_Games
					ON
						hlstats_Games.code = hlstats_Players.game
					WHERE
						hlstats_Games.hidden = '0'
						AND hlstats_PlayerNames.name LIKE '%🥀Lolly🥀%'
						
					ORDER BY
						name asc,
						player_id asc
					LIMIT
						0,
						50