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

Quote · 17 Sep 2010

 

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.

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 17 Sep 2010

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?

Quote · 17 Sep 2010

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

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 17 Sep 2010

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?

Quote · 18 Sep 2010

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.

Quote · 18 Sep 2010

exactly what have you put in the field in maps module

Profile address field name for exact address geocoding:

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 18 Sep 2010

 

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.


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


https://www.deanbassett.com
Quote · 18 Sep 2010

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

Quote · 19 Sep 2010
 
 
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.