•  · 25 friends

Repeating DB error

Same DB error almost daily..

This is the same everytime.. "array (  'type' => 'location_country_state',  'keyword' => 'PL',  'state' => 'śląskie',  'lang' => 'en', )"

Database error in Man of Teal | An OpenRCT2 Community


Query:
SELECT * FROM `sys_profiles` INNER JOIN `bx_groups_data` ON `bx_groups_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_groups_meta_locations` ON `bx_groups_meta_locations`.`object_id`=`bx_groups_data`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_groups' AND `bx_groups_data`.`allow_view_to` IN(3,5,'c',5) AND `bx_groups_meta_locations`.`country` ='PL' AND `bx_groups_meta_locations`.`state` ='śląskie' LIMIT 0, 4

Mysql error:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '='

Location:
The error was found in getAll function in the file /home/manofteal/public_html/inc/classes/BxDolSearch.php at line 764.

collation_connection:
utf8mb4_unicode_ci

Debug backtrace:

Array (    [0] => Array        (            [file] => /home/manofteal/public_html/inc/classes/BxDolDb.php            [line] => 1080            [function] => execute            [class] => PDOStatement            [type] => ->            [args] => Array                (                    [0] =>                 )         )     [1] => Array        (            [file] => /home/manofteal/public_html/inc/classes/BxDolDb.php            [line] => 1068            [function] => executeStatementException            [class] => BxDolDb            [type] => ->            [args] => Array                (                    [0] => PDOStatement Object                        (                            [queryString] => SELECT * FROM `sys_profiles`  INNER JOIN `bx_groups_data`  ON `bx_groups_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts`  ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_groups_meta_locations`  ON `bx_groups_meta_locations`.`object_id`=`bx_groups_data`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_groups' AND `bx_groups_data`.`allow_view_to` IN(3,5,'c',5) AND `bx_groups_meta_locations`.`country` ='PL' AND `bx_groups_meta_locations`.`state` ='śląskie' LIMIT 0, 4                        )                     [1] => Array                        (                        )                     [2] =>                 )         )     [2] => Array        (            [file] => /home/manofteal/public_html/inc/classes/BxDolDb.php            [line] => 486            [function] => executeStatement            [class] => BxDolDb            [type] => ->            [args] => Array                (                    [0] => PDOStatement Object                        (                            [queryString] => SELECT * FROM `sys_profiles`  INNER JOIN `bx_groups_data`  ON `bx_groups_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts`  ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_groups_meta_locations`  ON `bx_groups_meta_locations`.`object_id`=`bx_groups_data`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_groups' AND `bx_groups_data`.`allow_view_to` IN(3,5,'c',5) AND `bx_groups_meta_locations`.`country` ='PL' AND `bx_groups_meta_locations`.`state` ='śląskie' LIMIT 0, 4                        )                     [1] => Array                        (                        )                     [2] =>                 )         )     [3] => Array        (            [file] => /home/manofteal/public_html/inc/classes/BxDolDb.php            [line] => 364            [function] => res            [class] => BxDolDb            [type] => ->            [args] => Array                (                    [0] => PDOStatement Object                        (                            [queryString] => SELECT * FROM `sys_profiles`  INNER JOIN `bx_groups_data`  ON `bx_groups_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts`  ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_groups_meta_locations`  ON `bx_groups_meta_locations`.`object_id`=`bx_groups_data`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_groups' AND `bx_groups_data`.`allow_view_to` IN(3,5,'c',5) AND `bx_groups_meta_locations`.`country` ='PL' AND `bx_groups_meta_locations`.`state` ='śląskie' LIMIT 0, 4                        )                     [1] => Array                        (                        )                 )         )     [4] => Array        (            [file] => /home/manofteal/public_html/inc/classes/BxDolSearch.php            [line] => 764            [function] => getAll            [class] => BxDolDb            [type] => ->            [args] => Array                (                    [0] => PDOStatement Object                        (                            [queryString] => SELECT * FROM `sys_profiles`  INNER JOIN `bx_groups_data`  ON `bx_groups_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts`  ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_groups_meta_locations`  ON `bx_groups_meta_locations`.`object_id`=`bx_groups_data`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_groups' AND `bx_groups_data`.`allow_view_to` IN(3,5,'c',5) AND `bx_groups_meta_locations`.`country` ='PL' AND `bx_groups_meta_locations`.`state` ='śląskie' LIMIT 0, 4                        )                 )         )     [5] => Array        (            [file] => /home/manofteal/public_html/inc/classes/BxDolSearch.php            [line] => 748            [function] => getNum            [class] => BxDolSearchResult            [type] => ->            [args] => Array                (                )         )     [6] => Array        (            [file] => /home/manofteal/public_html/inc/classes/BxDolSearch.php            [line] => 582            [function] => setConditionParams            [class] => BxDolSearchResult            [type] => ->            [args] => Array                (                )         )     [7] => Array        (            [file] => /home/manofteal/public_html/template/scripts/BxBaseSearchResult.php            [line] => 52            [function] => getSearchData            [class] => BxDolSearchResult            [type] => ->            [args] => Array                (                )         )     [8] => Array        (            [file] => /home/manofteal/public_html/modules/base/general/classes/BxBaseModGeneralSearchResult.php            [line] => 117            [function] => displayResultBlock            [class] => BxBaseSearchResult            [type] => ->            [args] => Array                (                )         )     [9] => Array        (            [file] => /home/manofteal/public_html/modules/base/profile/classes/BxBaseModProfileSearchResult.php            [line] => 169            [function] => displayResultBlock            [class] => BxBaseModGeneralSearchResult            [type] => ->            [args] => Array                (                )         )     [10] => Array        (            [file] => /home/manofteal/public_html/inc/classes/BxDolSearch.php            [line] => 430            [function] => displayResultBlock            [class] => BxBaseModProfileSearchResult            [type] => ->            [args] => Array                (                )         )     [11] => Array        (            [file] => /home/manofteal/public_html/inc/classes/BxDolSearch.php            [line] => 112            [function] => processing            [class] => BxDolSearchResult            [type] => ->            [args] => Array                (                )         )     [12] => Array        (            [file] => /home/manofteal/public_html/searchKeyword.php            [line] => 31            [function] => response            [class] => BxDolSearch            [type] => ->            [args] => Array                (                )         )
)

Settings:
array (  'sys_install_time' => '1464840957',  'sys_ftp_login' => '',  'sys_ftp_password' => '',  'sys_ftp_dir' => '',  'sys_site_logo' => '21',  'sys_site_logo_alt' => 'Man Of Teal',  'sys_site_icon' => '46',  'sys_site_logo_width' => '400',  'sys_site_logo_height' => '150',  'sys_site_splash_code' => '<style>    /*--- General ---*/      @media (max-width:1024px) {        -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 ; padding-bottom:10px; margin-bottom:20px; font-weight:bold; font-size:22px; color:#999;">{site_name}</div>',  'enable_notification_account' => 'on',  'sys_account_limit_profiles_number' => '1',  'enable_notification_pruning' => 'on',  'sys_account_activation_letter' => 'on',  'site_tour_studio' => '',  'aqb_pcontests_title_chars_subentry' => '25',  'site_tour_home' => '',  'aqb_pcontests_subentries_max' => '4',  'bx_organizations_per_page_browse' => '24',  'bx_organizations_searchable_fields' => 'org_name,org_desc',  'bx_posts_searchable_fields' => 'title,text',  'bx_protean_block_title_border_color' => 'rgba(103, 130, 148, 0.76)',  'bx_protean_block_title_border_size' => '.5px',  'bx_protean_block_title_border_radius' => '0px',  'bx_protean_menu_slide_font_family' => 'Asap, Asap Condensed, sans-serif',  'bx_protean_menu_slide_font_size' => '1.0rem',  'bx_protean_menu_slide_font_color' => 'rgba(62, 134, 133, 1)',  'bx_protean_menu_slide_font_color_hover' => 'rgba(62, 134, 133, 1)',  'bx_protean_menu_slide_font_color_active' => 'rgba(0, 0, 0, 1)',  'bx_protean_menu_slide_font_shadow' => 'none',  'bx_protean_menu_slide_font_weight' => '400',  'bx_protean_styles_custom' => 'font-family: \'Play\', sans-serif;',  'bx_events_num_connections_quick' => '6',  'bx_events_num_rss' => '10',  'bx_events_time_format' => 'H:i',  'sys_iframely_api_key' => '8a66d72c60d3347300fd41',  'aqb_pcontests_plain_summary_chars_subentry' => '240',  'bx_timeline_events_hide' => '86,84',  'bx_timeline_rss_length' => '5',  'bx_timeline_events_per_page' => '8',  'bx_timeline_events_per_page_home' => '8',  'bx_ocean_site_logo' => '0',  'bx_ocean_site_logo_alt' => 'Man Of Teal',  'bx_ocean_switcher_title' => 'Ocean',  'bx_timeline_enable_edit' => 'on',  'bx_timeline_enable_delete' => 'on',  'bx_timeline_enable_show_all' => '',  'bx_timeline_events_per_page_profile' => '8',  'bx_timeline_events_per_page_account' => '8',  'permalinks_storage' => 'on',  'bx_ocean_page_width' => '1280',  'bx_ocean_site_logo_width' => '240',  'bx_ocean_site_logo_height' => '48',  'aqb_pcontests_rss_num' => '10',  'aqb_pcontests_searchable_fields' => 'title,text',  'sys_email_attachable_email_templates' => 'bx_timeline_send',  'sys_embedly_api_key' => '4e431c2b6dda497aaff66b3be3857256',  'sys_unit_cover_profile' => '129',  'sys_embed_default' => 'sys_embedly',  'sys_tinymce_plugins_mini' => 'autolink,image,link,lists,paste,fullscreen',  'sys_tinymce_toolbar_mini' => 'bold italic underline removeformat | bullist numlist | alignleft aligncenter alignright | blockquote | link unlink image | fullscreen',  'sys_tinymce_plugins_standard' => 'advlist,autolink,autosave,code,hr,image,link,lists,media,paste,fullscreen',  'sys_tinymce_toolbar_standard' => 'undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image | fullscreen',  'sys_tinymce_plugins_full' => 'advlist,anchor,autolink,autoresize,autosave,charmap,code,emoticons,hr,image,link,lists,media,nonbreaking,pagebreak,preview,paste,save,searchreplace,table,textcolor,visualblocks,fullscreen',  'sys_tinymce_toolbar_full' => 'undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image, preview media | forecolor emoticons | fullscreen',  'sys_account_confirmation_type' => 'email',  'sys_account_activation_2fa_enable' => '',  'sys_twilio_gate_sid' => 'MGdff0c5f1a4fa75c567f56f507d75f8c4',  'sys_twilio_gate_token' => 'hSyE66dh3L3pAVK5F1QwyZChZEWtUOny',  'sys_twilio_gate_from_number' => 'Man Of Teal',  'bx_timeline_hot_interval' => '48',  'bx_forum_summary_chars' => '700',  'bx_forum_plain_summary_chars' => '240',  'bx_forum_per_page_browse' => '12',  'bx_forum_per_page_index' => '6',  'bx_forum_per_page_profile' => '6',  'bx_forum_rss_num' => '10',  'bx_forum_searchable_fields' => 'title,text',  'bx_antispam_ip_list_type' => '0',  'bx_antispam_report' => 'on',  'bx_organizations_enable_profile_activation_letter' => 'on',  'client_image_resize_width' => '2048',  'client_image_resize_height' => '2048',  'sys_account_limit_incorrect_login_attempts' => '6',  'bx_persons_enable_profile_activation_letter' => 'on',  'bx_events_per_page_browse' => '24',  'bx_events_short_date_format' => 'j M y',  'bx_posts_per_page_profile' => '6',  'bx_protean_cover_height' => '20vh',  'bx_protean_cover_bg_color' => 'rgba(245, 237, 237, 1)',  'bx_protean_cover_content_padding' => '2rem 3rem 2rem 3rem',  'bx_protean_cover_border_color' => 'rgba(208, 208, 208, 0)',  'bx_protean_cover_border_size' => '0px',  'bx_protean_cover_border_radius' => '0px',  'bx_protean_cover_shadow' => 'none',  'bx_protean_cover_icon_border_color' => 'rgba(208, 208, 208, 1)',  'bx_protean_cover_icon_border_size' => '1px',  'bx_protean_cover_icon_border_radius' => '3px',  'bx_protean_cover_icon_shadow' => 'none',  'bx_protean_cover_text_align' => 'left',  'bx_protean_cover_text_shadow' => '0px 1px 3px rgba(0, 0, 0, .3)',  'bx_protean_cover_font_family' => 'Play, sans-serif',  'bx_protean_cover_font_size' => '2.0rem',  'bx_protean_cover_font_color' => 'rgba(255, 255, 255, 1)',  'bx_protean_cover_font_weight' => '700',  'bx_protean_menu_account_bg_image' => '0',  'bx_protean_menu_account_bg_image_repeat' => 'no-repeat',  'bx_protean_menu_account_bg_image_size' => 'cover',  'bx_protean_menu_account_content_padding' => '0px',  'bx_protean_menu_account_border_color' => 'rgba(61, 75, 82, 1)',  'bx_protean_menu_account_border_size' => '0px',  'bx_protean_menu_account_shadow' => 'none',  'bx_protean_menu_account_font_family' => 'Asap, Asap Condensed, sans-serif',  'bx_protean_menu_account_font_size' => '1.25rem',  'bx_protean_menu_account_font_color' => 'rgba(73, 181, 69, 1)',  'bx_protean_menu_account_font_color_hover' => 'rgba(44, 158, 67, 1)',  'bx_protean_menu_account_font_color_active' => 'rgba(41, 130, 35, 1)',  'bx_protean_menu_account_font_shadow' => 'none',  'bx_protean_menu_account_font_weight' => '400',  'aqb_pcontests_per_page_profiles' => '10',  'aqb_pcontests_per_page_browse' => '4',  'aqb_pcontests_plain_summary_chars' => '240',  'sys_per_page_search_keyword_plural' => '3',  'sys_per_page_search_keyword_single' => '24',  'sys_account_default_profile_type' => 'bx_persons',  'add_to_mobile_homepage' => 'on',  'site_login_social_compact' => 'on',  'bx_contact_add_reply_to' => '',  'bx_events_searchable_fields' => 'event_name,event_desc',  'bx_organizations_redirect_aadd' => 'profile',  'bx_organizations_redirect_aadd_custom_url' => '',  'bx_organizations_public_subscriptions' => 'on',  'bx_organizations_public_subscribed_me' => 'on',  'bx_persons_redirect_aadd' => 'profile',  'bx_persons_redirect_aadd_custom_url' => '',  'bx_persons_public_subscriptions' => 'on',  'bx_persons_public_subscribed_me' => 'on',  'sys_eq_send_per_start' => '500',  'sys_push_queue_send_per_start' => '500',  'bx_albums_per_page_profile' => '6',  'bx_albums_per_page_browse_showcase' => '32',  'sys_redirect_after_email_confirmation' => '',  'sys_account_auto_profile_creation' => 'on',  'sys_push_app_id' => '',  'sys_push_rest_api' => '',  'sys_push_short_name' => '',  'sys_push_safari_id' => '',  'bx_notifications_events_hide_site' => '',  'bx_notifications_events_per_page' => '12',  'bx_notifications_events_per_preview' => '5',  'bx_protean_header_bg_image_attachment' => 'scroll',  'bx_protean_footer_bg_image_attachment' => 'scroll',  'bx_protean_body_bg_image_attachment' => 'fixed',  'bx_protean_block_bg_image_attachment' => 'scroll',  'bx_protean_card_bg_color_hover' => 'rgba(255, 255, 255, 0.5)',  'bx_protean_card_bg_image_attachment' => 'scroll',  'bx_protean_popup_bg_image_attachment' => 'scroll',  'bx_protean_menu_main_bg_image_attachment' => 'scroll',  'bx_protean_menu_account_bg_image_attachment' => 'scroll',  'bx_protean_menu_page_bg_image_attachment' => 'scroll',  'bx_protean_menu_slide_bg_image_attachment' => 'scroll',  'bx_albums_per_page_browse' => '12',  'bx_events_per_page_browse_showcase' => '32',  'bx_organizations_per_page_browse_showcase' => '32',  'bx_persons_per_page_browse_showcase' => '32',  'bx_posts_per_page_browse_showcase' => '20',  'bx_persons_per_page_browse_recommended' => '10',  'bx_quoteofday_source' => 'rss',  'bx_quoteofday_rss_url' => 'https://manofteal.com/m/posts/rss/popular',  'bx_quoteofday_rss_max_items' => '5',  'bx_quoteofday_selection_mode' => 'random',  'bx_chat_plus_helpdesk_guest_only' => '',  'bx_chat_plus_url' => 'https://chat.manofteal.com',  'bx_chat_plus_helpdesk' => '',  'bx_albums_plain_summary_chars' => '200',  'bx_albums_summary_chars' => '700',  'sys_push_queue_send_per_start_to_recipient' => '2',  'sys_eq_send_per_start_to_recipient' => '2',  'sys_metatags_mentions_max' => '9',  'sys_metatags_hashtags_max' => '9',  'sys_eq_time' => '0',  'sys_revision' => '9',  'bx_forum_labels' => '',  'bx_notifications_enable_group_settings' => 'on',  'bx_organizations_labels' => '',  'bx_persons_labels' => '',  'bx_posts_labels' => '',  'bx_timeline_preload_comments' => '0',  'sys_push_queue_time' => '0',  'bx_antispam_dnsbl_enable' => 'on',  'bx_antispam_dnsbl_behaviour_login' => 'block',  'bx_antispam_dnsbl_behaviour_join' => 'approval',  'bx_antispam_uridnsbl_enable' => 'on',  'bx_antispam_akismet_enable' => '',  'bx_antispam_akismet_api_key' => '',  'bx_antispam_stopforumspam_enable' => 'on',  'bx_antispam_stopforumspam_api_key' => '',  'bx_antispam_disposable_email_domains_mode' => 'blacklist',  'bx_antispam_disposable_email_domains_behaviour_join' => 'block',  'bx_groups_num_connections_quick' => '6',  'bx_groups_per_page_browse' => '24',  'bx_groups_num_rss' => '10',  'bx_groups_per_page_browse_showcase' => '32',  'bx_groups_per_page_browse_recommended' => '10',  'bx_groups_searchable_fields' => 'group_name,group_desc', )

Called script:
/searchKeyword.php

Request parameters:

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


Auto-report system






  • 169
  • I can't reproduce the issue, could you please describe the steps how to reproduce it ?

    • I've never seen it, I'm getting the errors via email.

      There was another today, same search. 

      Query:
      SELECT * FROM `sys_profiles` INNER JOIN `bx_groups_data` ON `bx_groups_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id` INNER JOIN `bx_groups_meta_locations` ON `bx_groups_meta_locations`.`object_id`=`bx_groups_data`.`id`WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_groups' AND `bx_groups_data`.`allow_view_to` IN(3,5,'c',5) AND `bx_groups_meta_locations`.`country` ='PL' AND `bx_groups_meta_locations`.`state` ='śląskie' LIMIT 0, 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.

      Called script:
      /searchKeyword.php

      Request parameters:

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


      • I have similar problem i create a new topic! 

        • antonioceravolo you have another problem, I've replied to you in your thread

          Michael Newton could you please provide URL on your site which generates this error ?

          • If I knew that I would have posted how it happens.

             I've not had a single member say anything about this error, I only see them in email.

             The same word "śląskie" which I don't even know what language that is.

            I personally cannot repoduce the error, I do know it is an ongoing error for months now.

            Called script:
            /searchKeyword.php

            Request parameters:

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

            • I've looked further into my emails, using that one word for a city in PL I guess is Poland.

              This is what has "not" been purged. As you see this is an ongoing error, all with that 

              Called script:
              /searchKeyword.php

              Request parameters:

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

              • I've tried to reproduce it, but works just fine, I've used some other Polish names:

                • I found out what is causing error after turning off one module at a time. 

                  It turns out it's the "Photo Contest" module. 

                  I tested by turning it back on and did the search producing the database error!

                  This is from a module I purchased from AQB Soft #AQBSoft 


                  • Update, I've removed it, deleted it and re-downloaded and it didn't fix it.

                    6
                    1
                    3
                    Labels:
                    Added:
                    Category: