Michael Newton

  • 1271
I run a gaming community with UNA.

ManOfTeal.com
Profile Feed
Michael Newton
added a discussion

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) {        -footer-wrapper,        -menu-main-bar-wrapper,        -toolbar {            display:none;        }        html -content-wrapper {            border:none;            padding-bottom:0;        }    }     -content-wrapper {        padding-top: 0px;        padding-bottom: 4rem;    }     .bx-page-wrapper,    -content-container,    -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: ;    }     /*--- Join button ---*/     .bx-spl-join,    .bx-spl-join {        display: inline-block;        border-color: ;    }    .bx-spl-join a,    .bx-spl-join a {        display: block;        padding-left: 3.75rem;        padding-right: 3.75rem;        text-decoration: none;    }     /*--- Slides ---*/     -spl-slide01 .bx-spl-container,    -spl-slide03 .bx-spl-container {        position: absolute;        display: -webkit-flex;        display: flex;        -webkit-align-items: center;        align-items: center;    }    -spl-slide01 .bx-spl-content,    -spl-slide03 .bx-spl-content {        text-align: center;        text-shadow: 0px 0px 0.25rem #000;    }    -spl-slide02 .bx-spl-content h3,    -spl-slide04 .bx-spl-content h3 {        text-align: center;    }     /*--- Slide 1 ---*/     -spl-slide01 {        width:100%;        height:100vh;    }    -spl-slide01 .bx-spl-bg {        background-position: center center;        background-repeat: no-repeat;        background-size: cover;    }    -spl-slide01 .bx-spl-slide-video {        object-fit: cover;         width: 100%;        height: 100vh;    }     /*--- Slide 2 ---*/     -spl-slide02 .bx-spl-bg {        background-color: ;        height: 35vw;        max-height:400px;    }    -spl-slide02 .bx-spl-image {        position: absolute;        width: 60%;        height: 100%;        background-position: center bottom;        background-repeat: no-repeat;        background-size: contain;    }    -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) {        -spl-slide02.bx-spl-slide .bx-spl-content h3 {            font-size: 0.8rem;        }    }     /*--- Slide 3 ---*/     -spl-slide03 {        width:100%;        height:150vh;    }    -spl-slide03 .bx-spl-bg {        background-position: center center;        background-repeat: repeat;        background-attachment: fixed;        background-size:100%;    }     /*--- Slide 4 ---*/     -spl-slide04 {        width:100%;        height:100vh;    }    -spl-slide04 .bx-spl-bg {        background-color:;    }    -spl-slide04 .bx-spl-container {        display: -webkit-flex;        -webkit-align-items: center;        -webkit-justify-content: center;        display: flex;        align-items: center;        justify-content: center;    }    -spl-slide04 .bx-spl-content {        width: 50%;    }    @media (max-width:720px) {        -spl-slide04 .bx-spl-content {            width: 90%;        }    }    -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="-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="-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\': \'-spl-slide01, -spl-slide01 .bx-spl-slide-video, -spl-slide04\',                    \'1.5\': \'-spl-slide03\'                };                var aSelVw = {                    \'0.35\': \'-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="" style="margin:0; padding:0;">        <div style="padding:20px; background-color:;">            <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">                <tr><td valign="top">                    <div style="color:#333; padding:20px; border:1px solid ; border-radius:3px; background-color:; font:14px Helvetica, Arial, sans-serif;">                        <div style="border-bottom:2px solid 

Called script:
/searchKeyword.php

Request parameters:

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


Auto-report system






Michael Newton
added a discussion

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


Michael Newton
added a discussion

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

ymcpqk9ush7fijhhrutx2ksqxnbtey6f.jpg

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

9nrhdzc4jvfiqrvzy98ruaajsajgknqh.jpg

Michael Newton
added a discussion

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.


fugh42klnscab899qdt5cskhizf8nin3.jpg

Michael Newton
added a discussion

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.

Michael Newton
added a discussion

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


nvwqkrjabfhqdwuvmcsmhkdhfvv2jpyc.jpg

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

Michael Newton
added a discussion

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?

Michael Newton
added an album

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

Michael Newton
added a discussion

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

Michael Newton
added a discussion

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.

bwbhi2m6dguxzn8myrwgyt4jqwv2azqa.png

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

Michael Newton
added a discussion

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 is not an array in /home/manofteal/public_html/modules/boonex/timeline/classes/BxTimelineTemplate.php on line 1497

... or jump to: 2018, 2017, 2016
Info
Gender:
Man
Full Name:
Michael Newton
Joined Organizations
  • 3 members
Membership

Contributor

My Discussions
I've looked further into my emails, using that one word for a city in PL I guess is Poland.This is w…
by Michael Newton
7
I can't reproduce the issue, could you describe steps how to reproduce it and provide access to your…
by Alex T⚜️
2
Trying to use the "Post of the Day" block on the homepage. When in the middle the photo or post is s…
by Michael Newton
1
Hello Michael!With the enabled Profiler, the similar situations may appear because this app requires…
by LeonidS
2
You can try to fix the problem by executing the following queries:TRUNCATE `bx_timeline_handlers`; …
by Alex T⚜️
7
I thought I'd respond to this since I fixed my problem.I hadn't fully setup my Virtualmin/Webmin DNS…
by Michael Newton
10
My Posts
My Albums

OpenRCT2

These are some photos from my members Roller Coaster Tycoon park builds. Each build is block of graphics.
73250Shningka Plot View 1.png34149Shningka Plot View 3.png77498SCR24.png18164Shningka Plot View 2.png23670Shningka Plot View 4.png

Downtown view

This is a view of my downtown area here in Jacksonville Florida.
DJI_0009.pngDJI_0003.JPG