World Map Error: "Illegal mix of collations"

Hi all,

The Homepage World Map do not display nothing and give me  a db error:

"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/ilovericcione.com/httpdocs/modules/boonex/map_profiles/classes/BxMapDb.php' at line 137.
Called 'getAll' function with erroneous argument #0."

+ in the admin panel/modules/world map/ I can update the profiles but when trying to update cities I have one more time e db error page displayed :-(

I already read all the forum post about this error and try everything to display members and cities on the homepage world map.

But nothing work for me.

Can someone find a solution to fix this issue?

PS: Dolphin version: 7.0.4 upgraded from 7.0.2

Thank you in advance for your answer.

VM

******

Here the other forum link related the same "Illegal mix of collations" issue for World Map and other mods.

http://www.boonex.com/unity/forums/?action=goto&topic_id=World-Maps

http://www.boonex.com/unity/forums/?action=goto&topic_id=Home-page-map-problems

http://www.boonex.com/unity/forums/?action=goto&topic_id=Database-query-error-2010-12-03

http://www.boonex.com/unity/forums/?action=goto&topic_id=Database-error-in--2010-06-23

You  have 2 type of collation on the same database   you  need to change it  in your database

@BangLoungeFM,

thkz for your answer.

I already change the all db default collations in "utf8_general_ci"

+ bx_map_cities / bx_map_profile / bx_map_countries and all the field.

But the issue is not resolved. Profile are still not displayed on Map.

Any idea?

same here so how that fix?

Change  your database bx_map_cities / bx_map_profile / bx_map_countries to  utf8_unicode_ci