Home page map problems

Hi all,

Got a problem with world map on homepage.

No users showing on there.

When zoom in it shows a conecting circle.

In the admin, i ask update profiles is ok

then update cities and data base error comes up.

Stranger than ever all this works fine on the profile pages.

To see what i mean please visit my half done site

http://www.aupairsworld.co.uk

I looked at your main page map, I have to zoom very close to "Cardiff" to get member icons...fully zoomed out like you have set will no show any members...experiment with the zoom levels.

ALSO on your member profile page you have this error between custom rss feeds and the wall...

allow_url_include is On (warning, you should have this param in Off state, or your site will unsafe)
Please go to the
Dolphin Troubleshooter
and solve the problem.

firstly thx for taking the time to look and try to help

Well i have tried moving in like you said and yes when on scale of about 2 mile it shows the profiles.

But before it showed country flags on large scale.

What have i done wrong?

maybe you could try removing module and doing a re install..

Tried that no change

updating profiles still ok

updating cities and error - database query error 

stuck now as can not see anywhere to go with this

removed map profiler and reinstalled it

anyone any ideas?

This is error in full

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 '/home/clubavis/public_html/aupairsworld.co.uk/modules/boonex/map_profiles/classes/BxMapDb.php' at line 67.
Called 'getPairs' function with erroneous argument #0.

exactly what have you put in the field in maps module

Profile address field name for exact address geocoding:

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

Right there. Illegal mix of collations. For some reason the collation type for one of the tables has changed. Most likely the table bx_map_cities.

But if you had uninstalled the module as you said you did, that should have been corrected on reinstall.

But you need to look at it in phpMyadmin. the table bx_map_cities or one of it's string values is set to a collation type of utf8_unicode_ci and should be utf8_general_ci

Thanks for help.

I reinstalled Dolphin 7 and that sorted it, plus bonus was alot of what i had done remained.

Lost some profiles but not worried as was early days anyway.

Cheers