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

Quote · 4 Feb 2011

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

Quote · 4 Feb 2011

@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?

collations.jpg · 320.5K · 103 views
collations2.jpg · 44K · 95 views
Quote · 5 Feb 2011

same here so how that fix?

Quote · 30 Mar 2011

 

same here so how that fix?

Change  your database bx_map_cities / bx_map_profile / bx_map_countries to  utf8_unicode_ci


Quote · 2 Apr 2011
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.