Database hack attempt?
Database error in Man of Teal | An OpenRCT2 Community
Query:
SELECT * FROM `bx_ads_entries` INNER JOIN `bx_ads_meta_locations` ON `bx_ads_meta_locations`.`object_id`=`bx_ads_entries`.`id`WHERE 1 AND `bx_ads_entries`.`status` ='active' AND `bx_ads_entries`.`status_admin` ='active' AND `bx_ads_meta_locations`.`country` ='PL' AND `bx_ads_meta_locations`.`state` ='śląskie' LIMIT 0, 4
Mysql error:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '='
Location:
The error was found in getAll function in the file /home/manofteal/public_html/inc/classes/BxDolSearch.php at line 816.
collation_connection:
utf8mb4_unicode_ci
-
- · Michael Newton
- ·
Debug backtrace:
I will include it if needed. Alex T⚜️
-
Hello Michael Newton !
You may try to add the proper collation to this table as a fix. Run the following query in your UNA database"
ALTER TABLE `bx_ads_entries` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-
Thank you, kind sir.