• 3 followers

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                (                )         )
)


Called script:
/searchKeyword.php

Request parameters:

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


Auto-report system






  • 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  


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

                    6
                    1
                    3
                    Labels:
                    Added:
                    Category: