Thread: GeoIP2 in HLXCE
View Single Post
nikooo777
AlliedModders Donor
Join Date: Apr 2010
Location: Lugano, Switzerland
Old 03-10-2019 , 13:52   Re: GeoIP2 in HLXCE
Reply With Quote #6

Please be careful eveyone when updating the scripts with the above changes.

the charset is changed from utf8 to utf8mb4, which is great, but if you database isn't adjusted then you'll end up with errors such as:

Code:
DBD::mysql::st execute failed: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' at .//HLstats.plib line 185.
Unable to execute query:

                        SELECT
                                playerId
                        FROM
                                hlstats_PlayerNames
                        WHERE
                                playerId = 1180307
                                AND name ='{����} ��������'

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
__________________
nikooo777 is offline