Repeating DB error
Same DB error almost daily..
This is the same everytime.. "array ( 'type' => 'location_country_state', 'keyword' => 'PL', 'state' => 'śląskie', 'lang' => 'en', )"
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 ( ) )
)
Settings: array ( 'sys_install_time' => '1464840957', 'sys_ftp_login' => '', 'sys_ftp_password' => '', 'sys_ftp_dir' => '', 'sys_site_logo' => '21', 'sys_site_logo_alt' => 'Man Of Teal', 'sys_site_icon' => '46', 'sys_site_logo_width' => '400', 'sys_site_logo_height' => '150', 'sys_site_splash_code' => '<style> /*--- General ---*/ @media (max-width:1024px) {#bx-footer-wrapper,#bx-menu-main-bar-wrapper,#bx-toolbar { display:none; } html#bx-content-wrapper { border:none; padding-bottom:0; } }#bx-content-wrapper { padding-top: 0px; padding-bottom: 4rem; } .bx-page-wrapper,#bx-content-container,#bx-content-main { width: 100%; margin: 0px; padding: 0px; } /*--- Splash ---*/ .bx-splash { position: relative; } .bx-spl-preload { position: absolute; top: 0px; left: 0px; width: 1px; height: 1px; overflow: hidden; } .bx-spl-slide { position: relative; display: block; overflow: hidden; } .bx-spl-bg { position: relative; width: 100%; height: 100%; } .bx-spl-container { position: relative; top: 0px; left: 0px; width: 100%; height: 100%; } .bx-spl-content { position: relative; width:100%; } .bx-spl-slide .bx-spl-content h1 { font-size: 2.25rem; } .bx-spl-slide .bx-spl-content h3 { font-size: 1.5rem; } .bx-spl-white-text-all * { color:#fff; } /*--- Join button ---*/ .bx-spl-join, .bx-spl-join { display: inline-block; border-color:#fff; } .bx-spl-join a, .bx-spl-join a { display: block; padding-left: 3.75rem; padding-right: 3.75rem; text-decoration: none; } /*--- Slides ---*/#bx-spl-slide01 .bx-spl-container,#bx-spl-slide03 .bx-spl-container { position: absolute; display: -webkit-flex; display: flex; -webkit-align-items: center; align-items: center; }#bx-spl-slide01 .bx-spl-content,#bx-spl-slide03 .bx-spl-content { text-align: center; text-shadow: 0px 0px 0.25rem #000; }#bx-spl-slide02 .bx-spl-content h3,#bx-spl-slide04 .bx-spl-content h3 { text-align: center; } /*--- Slide 1 ---*/#bx-spl-slide01 { width:100%; height:100vh; }#bx-spl-slide01 .bx-spl-bg { background-position: center center; background-repeat: no-repeat; background-size: cover; }#bx-spl-slide01 .bx-spl-slide-video { object-fit: cover; width: 100%; height: 100vh; } /*--- Slide 2 ---*/#bx-spl-slide02 .bx-spl-bg { background-color:#fff; height: 35vw; max-height:400px; }#bx-spl-slide02 .bx-spl-image { position: absolute; width: 60%; height: 100%; background-position: center bottom; background-repeat: no-repeat; background-size: contain; }#bx-spl-slide02 .bx-spl-content { position: absolute; display: -webkit-flex; -webkit-align-items: center; -webkit-justify-content: center; display: flex; align-items: center; justify-content: center; top: 0px; right: 0px; width: 40%; height: 100%; } @media (max-width:720px) {#bx-spl-slide02.bx-spl-slide .bx-spl-content h3 { font-size: 0.8rem; } } /*--- Slide 3 ---*/#bx-spl-slide03 { width:100%; height:150vh; }#bx-spl-slide03 .bx-spl-bg { background-position: center center; background-repeat: repeat; background-attachment: fixed; background-size:100%; } /*--- Slide 4 ---*/#bx-spl-slide04 { width:100%; height:100vh; }#bx-spl-slide04 .bx-spl-bg { background-color:#fff; }#bx-spl-slide04 .bx-spl-container { display: -webkit-flex; -webkit-align-items: center; -webkit-justify-content: center; display: flex; align-items: center; justify-content: center; }#bx-spl-slide04 .bx-spl-content { width: 50%; } @media (max-width:720px) {#bx-spl-slide04 .bx-spl-content { width: 90%; } }#bx-spl-slide04 .bx-spl-content h3 { margin-top: 0px; margin-bottom: 2rem; } </style> <div id="skrollr-body" class="bx-splash bx-def-color-bg-page"> <div id="bx-spl-preload" class="bx-spl-preload"> <img src="<bx_image_url:cover01.jpg />"> <img src="<bx_image_url:cover02.jpg />"> <img src="<bx_image_url:cover03.jpg />"> </div> <div id="bx-spl-slide01" class="bx-spl-slide"> <div class="bx-spl-bg" style="background-image:url(<bx_image_url:cover01.jpg />);"> <video class="bx-spl-slide-video bx-def-media-phone-hide bx-def-media-tablet-hide" poster="<bx_image_url:cover01.jpg />" loop autoplay muted> <source src="<bx_image_url:cover01.mp4 />" type="video/mp4"> <source src="<bx_image_url:cover01.webm />" type="video/webm"> </video> </div> <div class="bx-spl-container"> <div class="bx-spl-content bx-spl-white-text-all" data-anchor-target="#bx-spl-slide01 .bx-spl-bg" data-top="opacity:1" data-top-center="opacity:0"> <h1 class="bx-def-font-semibold"><bx_text:_sys_txt_splash_slide01_title /></h1> <h3 class="bx-def-font-normal"><bx_text:_sys_txt_splash_slide01_desc /></h3> <div class="bx-spl-join bx-def-margin-topbottom bx-def-border bx-def-round-corners"> <a class="bx-def-padding-sec-topbottom bx-def-font-h3 bx-def-font-normal" href="__join_link__"><bx_text:_sys_txt_splash_btn_join /></a> </div> </div> </div> </div> <div id="bx-spl-slide02" class="bx-spl-slide"> <div class="bx-spl-bg"> <div class="bx-spl-container"> <div class="bx-spl-image" style="background-image:url(<bx_image_url:cover02.jpg />);" data-bottom-top="bottom:-100%;" data-100-center-center="bottom:0%;"></div> <div class="bx-spl-content" data-bottom-top="right:-50%;" data-100-center-center="right:0%;"> <h3 class="bx-def-font-normal"><bx_text:_sys_txt_splash_slide02_txt /></h3> </div> </div> </div> </div> <div id="bx-spl-slide03" class="bx-spl-slide"> <div class="bx-spl-bg" style="background-image:url(<bx_image_url:cover03.jpg />)"></div> <div class="bx-spl-container"> <div class="bx-spl-content bx-spl-white-text-all"> <h3 class="bx-def-font-normal"><bx_text:_sys_txt_splash_slide03_txt /></h3> <div class="bx-spl-join bx-def-margin-topbottom bx-def-border bx-def-round-corners"> <a class="bx-def-padding-sec-topbottom bx-def-font-h3 bx-def-font-normal" href="__join_link__"><bx_text:_sys_txt_splash_btn_join /></a> </div> </div> </div> </div> <div id="bx-spl-slide04" class="bx-spl-slide"> <div class="bx-spl-bg"> <div class="bx-spl-container" data-anchor-target="#bx-spl-slide03 .bx-spl-bg" data-100-center-bottom="opacity:0; transform:scale(0.7,0.7);" data-200-end="opacity:1; transform:scale(1,1);"> <div class="bx-spl-content"> <h3 class="bx-def-font-normal"><bx_text:_sys_txt_splash_slide04_txt /></h3> <div class="bx-spl-login">__login_form__</div> </div> </div> </div> </div> <script type="text/javascript"> $(document).ready(function () { // workaround for iOS 7 if (!!navigator.userAgent.match(/i(Pad|Phone|Pod).+(Version\\/7\\.\\d+ Mobile)/i)) { var aSelVh = { \'1\': \'#bx-spl-slide01,#bx-spl-slide01 .bx-spl-slide-video,#bx-spl-slide04\', \'1.5\': \'#bx-spl-slide03\' }; var aSelVw = { \'0.35\': \'#bx-spl-slide02 .bx-spl-bg\' }; function fixMobileSafariViewport() { $.each(aSelVh, function (sVal, sSel) { $(sSel).css(\'height\', window.innerHeight * parseFloat(sVal)); }); $.each(aSelVw, function (sVal, sSel) { $(sSel).css(\'height\', window.innerWidth * parseFloat(sVal)); }); } // listen to portrait/landscape changes window.addEventListener(\'orientationchange\', fixMobileSafariViewport, true); fixMobileSafariViewport(); } skrollr.init(); }); </script> </div>', 'sys_site_splash_enabled' => '', 'sys_template_cache_image_enable' => '', 'sys_template_cache_image_max_size' => '50', 'sys_redirect_after_account_added' => 'page.php?i=account-profile-switcher®ister=1', 'sys_editor_default' => 'sys_tinymce', 'sys_captcha_default' => 'sys_recaptcha_new', 'sys_live_updates_interval' => '10000', 'lang_default' => 'en', 'lang_subst_from_en' => 'on', 'sys_format_date' => 'D MMM YYYY', 'sys_format_time' => 'HH:mm', 'sys_format_datetime' => 'D MMM YYYY h:mm:ss a', 'sys_format_timeago' => '432000', 'template' => 'protean', 'sys_db_cache_enable' => 'on', 'sys_db_cache_engine' => 'XCache', 'sys_cache_memcache_host' => '', 'sys_cache_memcache_port' => '11211', 'sys_page_cache_enable' => 'on', 'sys_page_cache_engine' => 'File', 'sys_pb_cache_enable' => 'on', 'sys_pb_cache_engine' => 'File', 'sys_template_cache_enable' => 'on', 'sys_template_cache_engine' => 'XCache', 'sys_template_cache_css_enable' => 'on', 'sys_template_cache_js_enable' => 'on', 'sys_template_cache_minify_css_enable' => 'on', 'sys_template_cache_minify_js_enable' => 'on', 'sys_template_cache_compress_enable' => 'on', 'sys_oauth_key' => 'ysbyc3evdc', 'sys_oauth_secret' => 'vubzbwwybpampcxhv7em4pxcdtmgbzyl', 'currency_code' => 'USD', 'currency_sign' => '$', 'enable_gd' => 'on', 'useLikeOperator' => 'on', 'sys_transcoder_queue_storage' => '', 'permalinks_pages' => 'on', 'permalinks_modules' => 'on', 'sys_security_form_token_enable' => 'on', 'sys_security_form_token_lifetime' => '86400', 'sys_recaptcha_key_public' => '6LeOLw4UAAAAAL2CrhhZuTZUdMG1lbYfsK1hgQ9F', 'sys_recaptcha_key_private' => '6LeOLw4UAAAAABL-ydIGR64DqAQZnAYXIhdFeiww', 'sys_add_nofollow' => 'on', 'site_title' => 'Man of Teal | An OpenRCT2 Community', 'site_email' => 'mlnnflorida@gmail.com', 'site_email_notify' => 'admin@manofteal.com', 'sys_autoupdate' => '', 'sys_cron_time' => '1549883821', 'sys_autoupdate_force_modified_files' => '', 'sys_storage_default' => 'Local', 'sys_storage_s3_access_key' => '', 'sys_storage_s3_secret_key' => '', 'sys_storage_s3_bucket' => '', 'sys_storage_s3_domain' => '', 'sys_account_autoapproval' => '', 'bx_en_switcher_title' => 'English', 'bx_persons_autoapproval' => 'on', 'bx_persons_default_acl_level' => '10', 'bx_persons_num_connections_quick' => '6', 'bx_persons_num_rss' => '10', 'aqb_guests_def_duration' => 'all', 'bx_contact_email' => '', 'bx_convos_preview_messages_num' => '6', 'bx_notifications_events_hide_push' => '', 'bx_notifications_events_hide_email' => '', 'bx_organizations_autoapproval' => 'on', 'bx_organizations_default_acl_level' => '8', 'bx_organizations_num_connections_quick' => '6', 'bx_organizations_num_rss' => '10', 'bx_smtp_on' => 'on', 'bx_smtp_auth' => 'on', 'bx_antispam_block' => '', 'bx_smtp_username' => 'admin@manofteal.com', 'bx_smtp_password' => '2days4me', 'bx_smtp_host' => 'smtpout.secureserver.net', 'bx_smtp_port' => '465', 'bx_smtp_secure' => 'SSL', 'bx_smtp_from_name' => 'Man of Teal | An Open RCT2 Community', 'bx_smtp_from_email' => 'admin@manofteal.com', 'bx_smtp_allow_selfsigned' => '', 'bx_posts_summary_chars' => '200', 'bx_posts_plain_summary_chars' => '240', 'bx_posts_per_page_browse' => '6', 'bx_posts_rss_num' => '10', 'bx_timeline_enable_hot' => 'on', 'bx_timeline_enable_editor_toolbar' => 'on', 'bx_timeline_videos_autoplay' => 'on_mute', 'bx_organizations_per_page_browse_recommended' => '10', 'bx_events_per_page_browse_recommended' => '10', 'aqb_guests_per_page' => '10', 'sys_site_cover_common' => '128', 'sys_maps_api_key' => 'AIzaSyCRQtKGxhLOOcfsxJ0VSYiHwPV2vk7Z0w4', 'sys_default_payment' => '', 'sys_account_online_time' => '2', 'sys_acl_expire_notification_days' => '5', 'sys_acl_expire_notify_once' => 'on', 'bx_albums_rss_num' => '10', 'bx_albums_searchable_fields' => 'title,text', 'aqb_pcontests_summary_chars' => '700', 'bx_protean_switcher_title' => 'Protean', 'bx_protean_general_item_bg_color_hover' => 'rgba(210, 230, 250, 0.3)', 'bx_protean_general_item_bg_color_active' => 'rgba(210, 230, 250, 0.5)', 'bx_protean_header_height' => '3.4rem', 'bx_protean_header_content_padding' => '0.2rem', 'bx_protean_header_bg_color' => 'rgba(0, 131, 138, 0.79)', 'bx_protean_header_bg_image' => '11', 'bx_protean_header_bg_image_repeat' => 'no-repeat', 'bx_protean_header_bg_image_size' => 'auto', 'bx_protean_site_logo' => '12', 'bx_protean_site_logo_alt' => 'Man Of Teal', 'bx_protean_site_logo_width' => '240', 'bx_protean_site_logo_height' => '48', 'bx_protean_header_border_color' => 'rgba(178, 223, 238, 0.95)', 'bx_protean_header_border_size' => '1px', 'bx_protean_header_shadow' => '0px 0px 1px 1px rgba(0,0,0,0.2)', 'bx_protean_header_icon_color' => 'rgba(0, 229, 238, 1)', 'bx_protean_header_icon_color_hover' => 'rgba(250, 10, 10, 1)', 'bx_protean_header_link_color' => 'rgba(215, 235, 255, 1)', 'bx_protean_header_link_color_hover' => 'rgba(255, 255, 255, 1)', 'bx_protean_footer_bg_color' => 'rgba(0, 225, 237, 0.7)', 'bx_protean_footer_bg_image' => '0', 'bx_protean_footer_bg_image_repeat' => 'no-repeat', 'bx_protean_footer_bg_image_size' => 'cover', 'bx_protean_footer_content_padding' => '1rem', 'bx_protean_footer_border_color' => 'rgba(40, 60, 80, 0.1)', 'bx_protean_footer_border_size' => '5px', 'bx_protean_footer_shadow' => 'none', 'bx_protean_footer_font_color' => 'rgba(220, 242, 242, 1)', 'bx_protean_footer_icon_color' => 'rgba(255, 0, 30, 1)', 'bx_protean_footer_icon_color_hover' => 'rgba(0, 229, 238, 1)', 'bx_protean_footer_link_color' => 'rgba(255, 255, 255, 1)', 'bx_protean_footer_link_color_hover' => 'rgba(255, 0, 0, 1)', 'bx_protean_body_bg_color' => 'rgb(5, 5, 5)', 'bx_protean_body_bg_image' => '20', 'bx_protean_body_bg_image_repeat' => 'repeat-y', 'bx_protean_body_bg_image_size' => 'auto', 'bx_protean_page_width' => '90%', 'bx_protean_body_icon_color' => 'rgba(70, 130, 180, 1)', 'bx_protean_body_icon_color_hover' => 'rgba(60, 15, 194, 1)', 'bx_protean_body_link_color' => 'rgba(43, 65, 94, 1)', 'bx_protean_body_link_color_hover' => 'rgba(8, 43, 87, 1)', 'bx_protean_block_bg_color' => 'rgba(207, 208, 209, 0.9)', 'bx_protean_block_bg_image' => '0', 'bx_protean_block_bg_image_repeat' => 'no-repeat', 'bx_protean_block_bg_image_size' => 'cover', 'bx_protean_block_content_padding' => '1rem', 'bx_protean_block_border_color' => 'rgba(103, 130, 148, 0.76)', 'bx_protean_block_border_size' => '5px', 'bx_protean_block_border_radius' => '3px', 'bx_protean_block_shadow' => 'none', 'bx_protean_block_title_bg_color' => 'rgba(151, 209, 209, 0.91)', 'bx_protean_block_title_padding' => '0.2rem 1rem 0.2rem 1rem', 'bx_protean_block_title_font_family' => 'Asap, Asap Condensed, sans-serif', 'bx_protean_block_title_font_size' => '1.25rem', 'bx_protean_block_title_font_color' => 'rgba(0, 0, 0, 0.9)', 'bx_protean_block_title_font_weight' => '500', 'bx_protean_block_title_div_height' => '1px', 'bx_protean_block_title_div_bg_color' => 'rgba(40, 60, 80, 0.1)', 'bx_protean_card_bg_color' => 'rgba(240, 243, 245, 0)', 'bx_protean_card_bg_image' => '0', 'bx_protean_card_bg_image_repeat' => 'no-repeat', 'bx_protean_card_bg_image_size' => 'cover', 'bx_protean_card_content_padding' => '1rem', 'bx_protean_card_border_color' => 'rgba(40, 60, 80, 0.1)', 'bx_protean_card_border_size' => '1px', 'bx_protean_card_border_radius' => '3px', 'bx_protean_card_shadow' => 'none', 'bx_protean_popup_bg_color' => 'rgba(156, 161, 166, 0.91)', 'bx_protean_popup_bg_image' => '0', 'bx_protean_popup_bg_image_repeat' => 'no-repeat', 'bx_protean_popup_bg_image_size' => 'cover', 'bx_protean_popup_content_padding' => '1.25rem', 'bx_protean_popup_border_color' => 'rgba(40, 60, 80, 0.1)', 'bx_protean_popup_border_size' => '2px', 'bx_protean_popup_border_radius' => '3px', 'bx_protean_popup_shadow' => '0px 3px 5px 1px rgba(0,0,0,0.1)', 'bx_protean_popup_title_bg_color' => 'rgba(196, 196, 196, 0.9)', 'bx_protean_popup_title_padding' => '1.25rem', 'bx_protean_popup_title_font_family' => 'Asap, Asap Condensed, sans-serif', 'bx_protean_popup_title_font_size' => '1.5rem', 'bx_protean_popup_title_font_color' => 'rgba(163, 161, 161, 1)', 'bx_protean_menu_main_bg_color' => 'rgba(0, 225, 237, 0.7)', 'bx_protean_menu_main_bg_image' => '13', 'bx_protean_menu_main_bg_image_repeat' => 'no-repeat', 'bx_protean_menu_main_bg_image_size' => 'cover', 'bx_protean_menu_main_content_padding' => '0px', 'bx_protean_menu_main_border_color' => 'rgba(232, 23, 23, 1)', 'bx_protean_menu_main_border_size' => '2px', 'bx_protean_menu_main_shadow' => 'none', 'bx_protean_menu_main_font_family' => 'Asap, Asap Condensed, sans-serif', 'bx_protean_menu_account_bg_color' => 'rgba(22, 97, 110, 1)', 'bx_protean_menu_main_font_size' => '1.125rem', 'bx_protean_menu_main_font_color' => 'rgba(255, 255, 255, 1)', 'bx_protean_menu_main_font_color_hover' => 'rgba(255, 0, 38, 0.89)', 'bx_protean_menu_main_font_color_active' => 'rgba(0, 229, 238, 1)', 'bx_protean_menu_main_font_shadow' => 'none', 'bx_protean_menu_main_font_weight' => '400', 'bx_protean_menu_page_bg_color' => 'rgba(181, 167, 167, 0.85)', 'bx_protean_menu_page_bg_image' => '0', 'bx_protean_menu_page_bg_image_repeat' => 'no-repeat', 'bx_protean_menu_page_bg_image_size' => 'cover', 'bx_protean_menu_page_content_padding' => '0.2rem', 'bx_protean_menu_page_border_color' => 'rgba(0, 0, 0, 0)', 'bx_protean_menu_page_border_size' => 'none', 'bx_protean_menu_page_shadow' => 'inset 0px -1px 0px 0px rgba(0,0,0,0.1);', 'bx_protean_menu_page_font_family' => 'Asap, Asap Condensed, sans-serif', 'bx_protean_menu_page_font_size' => '1.0rem', 'bx_protean_menu_page_font_color' => 'rgba(209, 246, 255, 1)', 'bx_protean_menu_page_font_color_hover' => 'rgba(219, 219, 219, 1)', 'bx_protean_menu_page_font_color_active' => 'rgba(0, 0, 0, 1)', 'bx_protean_menu_page_font_shadow' => 'none', 'bx_protean_menu_page_font_weight' => '400', 'bx_protean_menu_slide_bg_color' => 'rgba(255, 255, 255, 1)', 'bx_protean_menu_slide_bg_image' => '0', 'bx_protean_menu_slide_bg_image_repeat' => 'no-repeat', 'bx_protean_menu_slide_bg_image_size' => 'cover', 'bx_protean_menu_slide_content_padding' => '1.25rem', 'bx_protean_menu_slide_border_color' => 'rgba(40, 60, 80, 0.1)', 'bx_protean_menu_slide_border_size' => '1px 0px 1px 0px', 'bx_protean_menu_slide_shadow' => 'none', 'bx_protean_form_input_height' => '2.5rem', 'bx_protean_form_input_bg_color' => 'rgba(245, 250, 255, 0.5)', 'bx_protean_form_input_bg_color_active' => 'rgba(150, 148, 148, 1)', 'bx_protean_form_input_border_color' => 'rgba(40, 60, 80, 0.5)', 'bx_protean_form_input_border_color_active' => 'rgba(30, 140, 240, 1)', 'bx_protean_form_input_border_size' => '2px', 'bx_protean_form_input_shadow' => 'inset 0px 0px 2px 1px rgba(0,0,0,0.15);', 'bx_protean_form_input_font_family' => 'Asap, Asap Condensed, sans-serif', 'bx_protean_form_input_font_size' => '1rem', 'bx_protean_form_input_font_color' => 'rgba(40, 60, 80, 0.9)', 'bx_protean_button_lg_height' => '2.0rem', 'bx_protean_button_lg_bg_color' => 'rgba(0, 2, 3, 0.87)', 'bx_protean_button_lg_bg_color_hover' => 'rgba(245, 245, 245, 0.9)', 'bx_protean_button_lg_border_color' => 'rgba(20, 40, 60, 0.8)', 'bx_protean_button_lg_border_color_hover' => 'rgba(200, 250, 250, 0.96)', 'bx_protean_button_lg_border_size' => '1px', 'bx_protean_button_lg_border_radius' => '3px', 'bx_protean_button_lg_shadow' => '0px 0px 0px 1px rgba(0,0,0,0.1);', 'bx_protean_button_lg_font_family' => 'Asap, Asap Condensed, sans-serif', 'bx_protean_button_lg_font_size' => '1rem', 'bx_protean_button_lg_font_color' => 'rgba(255, 255, 255, 0.9)', 'bx_protean_button_lg_font_color_hover' => 'rgba(49, 183, 204, 1)', 'bx_protean_button_lg_font_shadow' => 'none', 'bx_protean_button_lg_font_weight' => '400', 'bx_protean_button_sm_height' => '1.5rem', 'bx_protean_button_sm_bg_color' => 'rgba(40, 60, 80, 0.8)', 'bx_protean_button_sm_bg_color_hover' => 'rgba(219, 219, 219, 0.66)', 'bx_protean_button_sm_border_color' => 'rgba(20, 40, 60, 0.8)', 'bx_protean_button_sm_border_color_hover' => 'rgba(20, 40, 60, 0.9)', 'bx_protean_button_sm_border_size' => '1px', 'bx_protean_button_sm_border_radius' => '3px', 'bx_protean_button_sm_shadow' => '0px 0px 0px 1px rgba(0,0,0,0.1);', 'bx_protean_button_sm_font_family' => 'Asap, Asap Condensed, sans-serif', 'bx_protean_button_sm_font_size' => '0.75rem', 'bx_protean_button_sm_font_color' => 'rgba(255, 255, 255, 0.9)', 'bx_protean_button_sm_font_color_hover' => 'rgba(255, 255, 255, 1)', 'bx_protean_button_sm_font_shadow' => 'none', 'bx_protean_button_sm_font_weight' => '400', 'bx_protean_font_family' => 'Asap, Asap Condensed, sans-serif', 'bx_protean_font_size_default' => '15px', 'bx_protean_font_color_default' => 'rgba(10, 10, 10, 1)', 'bx_protean_font_color_grayed' => 'rgba(0, 0, 0, 0.72)', 'bx_protean_font_color_contrasted' => 'rgba(120, 184, 133, 1)', 'bx_protean_font_size_small' => '12px', 'bx_protean_font_size_middle' => '14px', 'bx_protean_font_size_large' => '18px', 'bx_protean_font_size_h1' => '32px', 'bx_protean_font_weight_h1' => '700', 'bx_protean_font_color_default_h1' => 'rgba(8, 9, 10, 0.9)', 'bx_protean_font_color_grayed_h1' => 'rgba(11, 36, 66, 1)', 'bx_protean_font_color_contrasted_h1' => 'rgba(252, 254, 255, 1)', 'bx_protean_font_color_link_h1' => 'rgba(245, 254, 255, 1)', 'bx_protean_font_color_link_h1_hover' => 'rgba(0, 3, 5, 1)', 'bx_protean_font_size_h2' => '24px', 'bx_protean_font_weight_h2' => '700', 'bx_protean_font_color_default_h2' => 'rgba(8, 9, 10, 0.9)', 'bx_protean_font_color_grayed_h2' => 'rgba(65, 93, 112, 0.9)', 'bx_protean_font_color_contrasted_h2' => 'rgba(9, 15, 20, 1)', 'bx_protean_font_color_link_h2' => 'rgba(232, 235, 237, 1)', 'bx_protean_font_color_link_h2_hover' => 'rgba(198, 201, 204, 1)', 'bx_protean_font_size_h3' => '20px', 'bx_protean_font_weight_h3' => '500', 'bx_protean_font_color_default_h3' => 'rgba(8, 9, 10, 0.9)', 'bx_protean_font_color_grayed_h3' => 'rgba(41, 91, 148, 0.95)', 'bx_protean_font_color_contrasted_h3' => 'rgba(95, 134, 161, 1)', 'bx_protean_font_color_link_h3' => 'rgba(255, 255, 255, 1)', 'bx_protean_font_color_link_h3_hover' => 'rgba(0, 2, 3, 1)', 'bx_protean_vpt_font_size_scale' => '100%', 'bx_protean_vpm_font_size_scale' => '85%', 'site_email_html_template_footer' => ' </div> </td></tr> <tr><td valign="top"> <div style="margin-top:5px; text-align:center; color:#999; font:11px Helvetica, Arial, sans-serif;">{about_us} {unsubscribe}</div> </td></tr> </table> </div> </body> </html>', 'site_email_html_template_header' => '<html> <head></head> <body bgcolor="#eee" style="margin:0; padding:0;"> <div style="padding:20px; background-color:#eee;"> <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center"> <tr><td valign="top"> <div style="color:#333; padding:20px; border:1px solid#ccc; border-radius:3px; background-color:#fff; font:14px Helvetica, Arial, sans-serif;"> <div style="border-bottom:2px solid#eee; padding-bottom:10px; margin-bottom:20px; font-weight:bold; font-size:22px; color:#999;">{site_name}</div>', 'enable_notification_account' => 'on', 'sys_account_limit_profiles_number' => '1', 'enable_notification_pruning' => 'on', 'sys_account_activation_letter' => 'on', 'site_tour_studio' => '', 'aqb_pcontests_title_chars_subentry' => '25', 'site_tour_home' => '', 'aqb_pcontests_subentries_max' => '4', 'bx_organizations_per_page_browse' => '24', 'bx_organizations_searchable_fields' => 'org_name,org_desc', 'bx_posts_searchable_fields' => 'title,text', 'bx_protean_block_title_border_color' => 'rgba(103, 130, 148, 0.76)', 'bx_protean_block_title_border_size' => '.5px', 'bx_protean_block_title_border_radius' => '0px', 'bx_protean_menu_slide_font_family' => 'Asap, Asap Condensed, sans-serif', 'bx_protean_menu_slide_font_size' => '1.0rem', 'bx_protean_menu_slide_font_color' => 'rgba(62, 134, 133, 1)', 'bx_protean_menu_slide_font_color_hover' => 'rgba(62, 134, 133, 1)', 'bx_protean_menu_slide_font_color_active' => 'rgba(0, 0, 0, 1)', 'bx_protean_menu_slide_font_shadow' => 'none', 'bx_protean_menu_slide_font_weight' => '400', 'bx_protean_styles_custom' => 'font-family: \'Play\', sans-serif;', 'bx_events_num_connections_quick' => '6', 'bx_events_num_rss' => '10', 'bx_events_time_format' => 'H:i', 'sys_iframely_api_key' => '8a66d72c60d3347300fd41', 'aqb_pcontests_plain_summary_chars_subentry' => '240', 'bx_timeline_events_hide' => '86,84', 'bx_timeline_rss_length' => '5', 'bx_timeline_events_per_page' => '8', 'bx_timeline_events_per_page_home' => '8', 'bx_ocean_site_logo' => '0', 'bx_ocean_site_logo_alt' => 'Man Of Teal', 'bx_ocean_switcher_title' => 'Ocean', 'bx_timeline_enable_edit' => 'on', 'bx_timeline_enable_delete' => 'on', 'bx_timeline_enable_show_all' => '', 'bx_timeline_events_per_page_profile' => '8', 'bx_timeline_events_per_page_account' => '8', 'permalinks_storage' => 'on', 'bx_ocean_page_width' => '1280', 'bx_ocean_site_logo_width' => '240', 'bx_ocean_site_logo_height' => '48', 'aqb_pcontests_rss_num' => '10', 'aqb_pcontests_searchable_fields' => 'title,text', 'sys_email_attachable_email_templates' => 'bx_timeline_send', 'sys_embedly_api_key' => '4e431c2b6dda497aaff66b3be3857256', 'sys_unit_cover_profile' => '129', 'sys_embed_default' => 'sys_embedly', 'sys_tinymce_plugins_mini' => 'autolink,image,link,lists,paste,fullscreen', 'sys_tinymce_toolbar_mini' => 'bold italic underline removeformat | bullist numlist | alignleft aligncenter alignright | blockquote | link unlink image | fullscreen', 'sys_tinymce_plugins_standard' => 'advlist,autolink,autosave,code,hr,image,link,lists,media,paste,fullscreen', 'sys_tinymce_toolbar_standard' => 'undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image | fullscreen', 'sys_tinymce_plugins_full' => 'advlist,anchor,autolink,autoresize,autosave,charmap,code,emoticons,hr,image,link,lists,media,nonbreaking,pagebreak,preview,paste,save,searchreplace,table,textcolor,visualblocks,fullscreen', 'sys_tinymce_toolbar_full' => 'undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image, preview media | forecolor emoticons | fullscreen', 'sys_account_confirmation_type' => 'email', 'sys_account_activation_2fa_enable' => '', 'sys_twilio_gate_sid' => 'MGdff0c5f1a4fa75c567f56f507d75f8c4', 'sys_twilio_gate_token' => 'hSyE66dh3L3pAVK5F1QwyZChZEWtUOny', 'sys_twilio_gate_from_number' => 'Man Of Teal', 'bx_timeline_hot_interval' => '48', 'bx_forum_summary_chars' => '700', 'bx_forum_plain_summary_chars' => '240', 'bx_forum_per_page_browse' => '12', 'bx_forum_per_page_index' => '6', 'bx_forum_per_page_profile' => '6', 'bx_forum_rss_num' => '10', 'bx_forum_searchable_fields' => 'title,text', 'bx_antispam_ip_list_type' => '0', 'bx_antispam_report' => 'on', 'bx_organizations_enable_profile_activation_letter' => 'on', 'client_image_resize_width' => '2048', 'client_image_resize_height' => '2048', 'sys_account_limit_incorrect_login_attempts' => '6', 'bx_persons_enable_profile_activation_letter' => 'on', 'bx_events_per_page_browse' => '24', 'bx_events_short_date_format' => 'j M y', 'bx_posts_per_page_profile' => '6', 'bx_protean_cover_height' => '20vh', 'bx_protean_cover_bg_color' => 'rgba(245, 237, 237, 1)', 'bx_protean_cover_content_padding' => '2rem 3rem 2rem 3rem', 'bx_protean_cover_border_color' => 'rgba(208, 208, 208, 0)', 'bx_protean_cover_border_size' => '0px', 'bx_protean_cover_border_radius' => '0px', 'bx_protean_cover_shadow' => 'none', 'bx_protean_cover_icon_border_color' => 'rgba(208, 208, 208, 1)', 'bx_protean_cover_icon_border_size' => '1px', 'bx_protean_cover_icon_border_radius' => '3px', 'bx_protean_cover_icon_shadow' => 'none', 'bx_protean_cover_text_align' => 'left', 'bx_protean_cover_text_shadow' => '0px 1px 3px rgba(0, 0, 0, .3)', 'bx_protean_cover_font_family' => 'Play, sans-serif', 'bx_protean_cover_font_size' => '2.0rem', 'bx_protean_cover_font_color' => 'rgba(255, 255, 255, 1)', 'bx_protean_cover_font_weight' => '700', 'bx_protean_menu_account_bg_image' => '0', 'bx_protean_menu_account_bg_image_repeat' => 'no-repeat', 'bx_protean_menu_account_bg_image_size' => 'cover', 'bx_protean_menu_account_content_padding' => '0px', 'bx_protean_menu_account_border_color' => 'rgba(61, 75, 82, 1)', 'bx_protean_menu_account_border_size' => '0px', 'bx_protean_menu_account_shadow' => 'none', 'bx_protean_menu_account_font_family' => 'Asap, Asap Condensed, sans-serif', 'bx_protean_menu_account_font_size' => '1.25rem', 'bx_protean_menu_account_font_color' => 'rgba(73, 181, 69, 1)', 'bx_protean_menu_account_font_color_hover' => 'rgba(44, 158, 67, 1)', 'bx_protean_menu_account_font_color_active' => 'rgba(41, 130, 35, 1)', 'bx_protean_menu_account_font_shadow' => 'none', 'bx_protean_menu_account_font_weight' => '400', 'aqb_pcontests_per_page_profiles' => '10', 'aqb_pcontests_per_page_browse' => '4', 'aqb_pcontests_plain_summary_chars' => '240', 'sys_per_page_search_keyword_plural' => '3', 'sys_per_page_search_keyword_single' => '24', 'sys_account_default_profile_type' => 'bx_persons', 'add_to_mobile_homepage' => 'on', 'site_login_social_compact' => 'on', 'bx_contact_add_reply_to' => '', 'bx_events_searchable_fields' => 'event_name,event_desc', 'bx_organizations_redirect_aadd' => 'profile', 'bx_organizations_redirect_aadd_custom_url' => '', 'bx_organizations_public_subscriptions' => 'on', 'bx_organizations_public_subscribed_me' => 'on', 'bx_persons_redirect_aadd' => 'profile', 'bx_persons_redirect_aadd_custom_url' => '', 'bx_persons_public_subscriptions' => 'on', 'bx_persons_public_subscribed_me' => 'on', 'sys_eq_send_per_start' => '500', 'sys_push_queue_send_per_start' => '500', 'bx_albums_per_page_profile' => '6', 'bx_albums_per_page_browse_showcase' => '32', 'sys_redirect_after_email_confirmation' => '', 'sys_account_auto_profile_creation' => 'on', 'sys_push_app_id' => '', 'sys_push_rest_api' => '', 'sys_push_short_name' => '', 'sys_push_safari_id' => '', 'bx_notifications_events_hide_site' => '', 'bx_notifications_events_per_page' => '12', 'bx_notifications_events_per_preview' => '5', 'bx_protean_header_bg_image_attachment' => 'scroll', 'bx_protean_footer_bg_image_attachment' => 'scroll', 'bx_protean_body_bg_image_attachment' => 'fixed', 'bx_protean_block_bg_image_attachment' => 'scroll', 'bx_protean_card_bg_color_hover' => 'rgba(255, 255, 255, 0.5)', 'bx_protean_card_bg_image_attachment' => 'scroll', 'bx_protean_popup_bg_image_attachment' => 'scroll', 'bx_protean_menu_main_bg_image_attachment' => 'scroll', 'bx_protean_menu_account_bg_image_attachment' => 'scroll', 'bx_protean_menu_page_bg_image_attachment' => 'scroll', 'bx_protean_menu_slide_bg_image_attachment' => 'scroll', 'bx_albums_per_page_browse' => '12', 'bx_events_per_page_browse_showcase' => '32', 'bx_organizations_per_page_browse_showcase' => '32', 'bx_persons_per_page_browse_showcase' => '32', 'bx_posts_per_page_browse_showcase' => '20', 'bx_persons_per_page_browse_recommended' => '10', 'bx_quoteofday_source' => 'rss', 'bx_quoteofday_rss_url' => 'https://manofteal.com/m/posts/rss/popular', 'bx_quoteofday_rss_max_items' => '5', 'bx_quoteofday_selection_mode' => 'random', 'bx_chat_plus_helpdesk_guest_only' => '', 'bx_chat_plus_url' => 'https://chat.manofteal.com', 'bx_chat_plus_helpdesk' => '', 'bx_albums_plain_summary_chars' => '200', 'bx_albums_summary_chars' => '700', 'sys_push_queue_send_per_start_to_recipient' => '2', 'sys_eq_send_per_start_to_recipient' => '2', 'sys_metatags_mentions_max' => '9', 'sys_metatags_hashtags_max' => '9', 'sys_eq_time' => '0', 'sys_revision' => '9', 'bx_forum_labels' => '', 'bx_notifications_enable_group_settings' => 'on', 'bx_organizations_labels' => '', 'bx_persons_labels' => '', 'bx_posts_labels' => '', 'bx_timeline_preload_comments' => '0', 'sys_push_queue_time' => '0', 'bx_antispam_dnsbl_enable' => 'on', 'bx_antispam_dnsbl_behaviour_login' => 'block', 'bx_antispam_dnsbl_behaviour_join' => 'approval', 'bx_antispam_uridnsbl_enable' => 'on', 'bx_antispam_akismet_enable' => '', 'bx_antispam_akismet_api_key' => '', 'bx_antispam_stopforumspam_enable' => 'on', 'bx_antispam_stopforumspam_api_key' => '', 'bx_antispam_disposable_email_domains_mode' => 'blacklist', 'bx_antispam_disposable_email_domains_behaviour_join' => 'block', 'bx_groups_num_connections_quick' => '6', 'bx_groups_per_page_browse' => '24', 'bx_groups_num_rss' => '10', 'bx_groups_per_page_browse_showcase' => '32', 'bx_groups_per_page_browse_recommended' => '10', 'bx_groups_searchable_fields' => 'group_name,group_desc', )
Called script:
/searchKeyword.php
Request parameters:
array ( 'type' => 'location_country_state', 'keyword' => 'PL', 'state' => 'śląskie', 'lang' => 'en', )
Auto-report system
-
-
·
Alex T⚜️
- ·
I can't reproduce the issue, could you please describe the steps how to reproduce it ?
-
·
Alex T⚜️
-
I've never seen it, I'm getting the errors via email.
There was another today, same search.
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, 4Mysql 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.Called script:
/searchKeyword.phpRequest parameters:
array ( 'type' => 'location_country_state', 'keyword' => 'PL', 'state' => 'śląskie', 'lang' => 'en', )
-
- · antonioceravolo
- ·
I have similar problem i create a new topic!
-
-
·
Alex T⚜️
- ·
antonioceravolo you have another problem, I've replied to you in your thread
Michael Newton could you please provide URL on your site which generates this error ?
-
·
Alex T⚜️
-
- · Michael Newton
- ·
If I knew that I would have posted how it happens.
I've not had a single member say anything about this error, I only see them in email.
The same word "śląskie" which I don't even know what language that is.
I personally cannot repoduce the error, I do know it is an ongoing error for months now.
Called script:
/searchKeyword.phpRequest parameters:
array ( 'type' => 'location_country_state', 'keyword' => 'PL', 'state' => 'śląskie', 'lang' => 'en', )
-
- · Michael Newton
- ·
I've looked further into my emails, using that one word for a city in PL I guess is Poland.
This is what has "not" been purged. As you see this is an ongoing error, all with that
Called script:
/searchKeyword.phpRequest parameters:
array ( 'type' => 'location_country_state', 'keyword' => 'PL', 'state' => 'śląskie', 'lang' => 'en', )
-
-
·
Alex T⚜️
- ·
I've tried to reproduce it, but works just fine, I've used some other Polish names:
-
·
Alex T⚜️
-
- · Michael Newton
- ·
I found out what is causing error after turning off one module at a time.
It turns out it's the "Photo Contest" module.
I tested by turning it back on and did the search producing the database error!
This is from a module I purchased from AQB Soft #AQBSoft
-
- · Michael Newton
- ·
Update, I've removed it, deleted it and re-downloaded and it didn't fix it.