Cities update for Google Map - database error

This is one of those days I am wondering if ANYTHING works with this software.   I thought I would try to make a google map but the "update cities" function generates the errors below.  I got the map to display, but no profile locations are on it.

Also, we asked on another thread.  Can you enter more than one "profile address field name" - i.e.  City, country and zip - if so, do we separate by commas?  What are others putting in this field.

Thanks

Rob

-------------

Database error in

Query:

SELECT `p`.`City`, `p`.`Country` FROM `Profiles` AS `p` LEFT JOIN `bx_map_cities` AS `m` ON (`m`.`country` = `p`.`Country` AND `m`.`city` = `p`.`City`) WHERE ISNULL(`m`.`country`) LIMIT 4

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

Found error in the file '/var/www/vhosts/mysite.com/httpdocs/modules/boonex/map_profiles/classes/BxMapDb.php' at line 67.
Called 'getPairs' function with erroneous argument #0.

Quote · 29 Dec 2009

UPDATE:  The map works on the individual profiles, but the bigger map on the homepage doesn't have any indicators showing where the profile are - it is supposed to, isn't it?

Quote · 29 Dec 2009

i gave up on the map long time ago like you said profiles showed fine but on the homepage map shows up without members on it

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

you can only have one  City or country,zip cant have both see your are doing something illegal there lol

Quote · 29 Dec 2009

You can log to my site to see World map how it's work. Last night i spend whole night to change data in PhPMyadmin for google map. Fortunately i have 36 user... I have to enter for every user manual in the database for worl map data for country and the city. I have googl-it for latitude and longitude for the cities and now is work 100%

here is my site so check if you want, on the home page right to the botom of the page...

www.amanebudalibre.com/new/

Quote · 29 Dec 2009
 
 
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.