Michael Newton

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&register=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

Called script:
/searchKeyword.php

Request parameters:

array (  'type' => 'location_country_state',  'keyword' => 'PL',  'state' => 'śląskie',  'lang' => 'en', )

Auto-report system

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', )

Trying to use the "Post of the Day" block on the homepage. When in the middle the photo or post is shifted left. 

When trying to post on the left or right with the 3col layout I get the post that's not fitting.

I found this when trying to delete a "Post to Feed" I made yesterday and decided to remove it. I do have the profiler module running as you can see.

Since the last update I've had a issue with my Albums module. If you watch the video I made you can see where I have tried to "enable" the module in the studio. 

The module still is working site side of the website. Which means I cannot switch it off like before. 

I know what most will say is to remove and reinstall the module. I don't want to do that.

Check out my site, 

I find that today my site has stopped uploading of any type of photos, profile, timeline or albums. See attached photo.

I did recently restore my server but that was weeks ago.

I looked all through my customized website "mix" on where to increase the websites width. I've done it in the past with D7 via a database edit.

Am I missing something?

These are some photos from my members Roller Coaster Tycoon park builds. Each build is block of graphics.

My site has been in maintenance mode since I ran the update 10 hours ago. Anton L 

I've noticed that the site search will not find member profiles from a few years ago. 

I have a profile number less than 100 so I know it is when the site was started. 

/page/view-persons-profile?id=89

Using the site search tab or from the search page it will not pull up this account, which is "Reak," There are many more but this one I can for sure test as the member is one of my admins.

The search pulls up many other results but not anything related to this profile.

I've moved my site and now have this error on some pages.

Suggestions?

Notice: unserialize(): Error at offset 486 of 486 bytes in /home/manofteal/public_html/modules/boonex/timeline/classes/BxTimelineTemplate.php on line 1497

Warning: array_merge(): Argument #2 is not an array in /home/manofteal/public_html/modules/boonex/timeline/classes/BxTimelineTemplate.php on line 1497