World Maps

Hi all i am struggling to get the world maps working :( i keep getting this error though

Database error in

Query:

SELECT `m`.`country`, `m`.`lat`, `m`.`lng`, COUNT(`p`.`ID`) AS `num`
            FROM `bx_map_countries` AS `m` 
            INNER JOIN `Profiles` AS `p` ON (`p`.`Country` = `m`.`country` AND `p`.`Status` = 'Active') 
            INNER JOIN `bx_map_profiles` AS `pm` ON (`pm`.`id` = `p`.`ID` AND `pm`.`failed` = 0 AND `pm`.`allow_view_location_to` = '3')
            WHERE `m`.`failed` = 0  AND `m`.`lat` < 74.590108008823 AND `m`.`lat` > -52.482780222078  AND `m`.`lng` < 180 AND `m`.`lng` > -180  
            GROUP BY `p`.`Country`
            LIMIT 250

Mysql error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Found error in the file '/var/www/vhosts/I HAVE EDITED THIS AND THE PATH IS CORRECT/map_profiles/classes/BxMapDb.php' at line 126.
Called 'getAll' function with erroneous argument #0.

Can anyone help

I am a noob but i just noticed a difference in the utf8 code, 1 is general and 1 is unicode, what does this mean ???

I would check the tables structure in phpmyadmin.

I have done this and it is the same as yours . So where is it pulling the unicode form

Did you check the three tables involved or just the one?

bx_map_countries

Profiles

bx_map_profiles

Hi i have found the problem and yes you were correct, i checked all the tables and for some reason some had general and some had unicode. Thanks for your help :)

Your welcome. :)

Sorry I was not more detailed the first time around.

Could you possibly tell me what you did as I am now getting the same error

Regards

Toni