ManOfTeal.com
-
All posts
-
All posts
-
Posts by Michael Newton
-
Posts by Michael Newton
-
Posts by others
-
Posts by others
-
RSS
-
RSS
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
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.
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.
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
Contributor
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
|
Private
OpenRCT2
- ·
- · Michael Newton