Database error
Recent database error.
Database error in Man of Teal | An OpenRCT2 Community
Query:
SELECT * FROM `sys_profiles` INNER JOIN `bx_groups_data` ON `bx_groups_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_groups_meta_locations` ON `bx_groups_meta_locations`.`object_id`=`bx_groups_data`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_groups' AND `bx_groups_data`.`allow_view_to` IN(3,5,'c',5) AND `bx_groups_meta_locations`.`country` ='PL' AND `bx_groups_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 764.
collation_connection:
utf8mb4_unicode_ci
Debug backtrace:
Array ( [0] => Array ( [file] => /home/manofteal/public_html/inc/classes/BxDolDb.php [line] => 1080 [function] => execute [class] => PDOStatement [type] => -> [args] => Array ( [0] => ) ) [1] => Array ( [file] => /home/manofteal/public_html/inc/classes/BxDolDb.php [line] => 1068 [function] => executeStatementException [class] => BxDolDb [type] => -> [args] => Array ( [0] => PDOStatement Object ( [queryString] => SELECT * FROM `sys_profiles` INNER JOIN `bx_groups_data` ON `bx_groups_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_groups_meta_locations` ON `bx_groups_meta_locations`.`object_id`=`bx_groups_data`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_groups' AND `bx_groups_data`.`allow_view_to` IN(3,5,'c',5) AND `bx_groups_meta_locations`.`country` ='PL' AND `bx_groups_meta_locations`.`state` ='śląskie' LIMIT 0, 4 ) [1] => Array ( ) [2] => ) ) [2] => Array ( [file] => /home/manofteal/public_html/inc/classes/BxDolDb.php [line] => 486 [function] => executeStatement [class] => BxDolDb [type] => -> [args] => Array ( [0] => PDOStatement Object ( [queryString] => SELECT * FROM `sys_profiles` INNER JOIN `bx_groups_data` ON `bx_groups_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_groups_meta_locations` ON `bx_groups_meta_locations`.`object_id`=`bx_groups_data`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_groups' AND `bx_groups_data`.`allow_view_to` IN(3,5,'c',5) AND `bx_groups_meta_locations`.`country` ='PL' AND `bx_groups_meta_locations`.`state` ='śląskie' LIMIT 0, 4 ) [1] => Array ( ) [2] => ) ) [3] => Array ( [file] => /home/manofteal/public_html/inc/classes/BxDolDb.php [line] => 364 [function] => res [class] => BxDolDb [type] => -> [args] => Array ( [0] => PDOStatement Object ( [queryString] => SELECT * FROM `sys_profiles` INNER JOIN `bx_groups_data` ON `bx_groups_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_groups_meta_locations` ON `bx_groups_meta_locations`.`object_id`=`bx_groups_data`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_groups' AND `bx_groups_data`.`allow_view_to` IN(3,5,'c',5) AND `bx_groups_meta_locations`.`country` ='PL' AND `bx_groups_meta_locations`.`state` ='śląskie' LIMIT 0, 4 ) [1] => Array ( ) ) ) [4] => Array ( [file] => /home/manofteal/public_html/inc/classes/BxDolSearch.php [line] => 764 [function] => getAll [class] => BxDolDb [type] => -> [args] => Array ( [0] => PDOStatement Object ( [queryString] => SELECT * FROM `sys_profiles` INNER JOIN `bx_groups_data` ON `bx_groups_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_groups_meta_locations` ON `bx_groups_meta_locations`.`object_id`=`bx_groups_data`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_groups' AND `bx_groups_data`.`allow_view_to` IN(3,5,'c',5) AND `bx_groups_meta_locations`.`country` ='PL' AND `bx_groups_meta_locations`.`state` ='śląskie' LIMIT 0, 4 ) ) ) [5] => Array ( [file] => /home/manofteal/public_html/inc/classes/BxDolSearch.php [line] => 748 [function] => getNum [class] => BxDolSearchResult [type] => -> [args] => Array ( ) ) [6] => Array ( [file] => /home/manofteal/public_html/inc/classes/BxDolSearch.php [line] => 582 [function] => setConditionParams [class] => BxDolSearchResult [type] => -> [args] => Array ( ) ) [7] => Array ( [file] => /home/manofteal/public_html/template/scripts/BxBaseSearchResult.php [line] => 52 [function] => getSearchData [class] => BxDolSearchResult [type] => -> [args] => Array ( ) ) [8] => Array ( [file] => /home/manofteal/public_html/modules/base/general/classes/BxBaseModGeneralSearchResult.php [line] => 117 [function] => displayResultBlock [class] => BxBaseSearchResult [type] => -> [args] => Array ( ) ) [9] => Array ( [file] => /home/manofteal/public_html/modules/base/profile/classes/BxBaseModProfileSearchResult.php [line] => 169 [function] => displayResultBlock [class] => BxBaseModGeneralSearchResult [type] => -> [args] => Array ( ) ) [10] => Array ( [file] => /home/manofteal/public_html/inc/classes/BxDolSearch.php [line] => 430 [function] => displayResultBlock [class] => BxBaseModProfileSearchResult [type] => -> [args] => Array ( ) ) [11] => Array ( [file] => /home/manofteal/public_html/inc/classes/BxDolSearch.php [line] => 112 [function] => processing [class] => BxDolSearchResult [type] => -> [args] => Array ( ) ) [12] => Array ( [file] => /home/manofteal/public_html/searchKeyword.php [line] => 31 [function] => response [class] => BxDolSearch [type] => -> [args] => Array ( ) )
)
I've omitted the Settings:
Called script:
/searchKeyword.php
Request parameters:
array ( 'type' => 'location_country_state', 'keyword' => 'PL', 'state' => 'śląskie', 'lang' => 'en', )