World Map

hello,

i migrated about 2000 old profiles from 6.1.6.

in the world map i first updated the profiles which took about 3 hours and after that the cities with about 2 hours till all was finished.

now every user has his own map in the profile.

but on the map on the homepage and in members section all profiles are not shown on the map, only the new ones which registered.

where could be the problem?

I think it is a bug with the update - several others have reported it.   I didn't realized the homepage map would work with new registrants - thanks for letting us know.

Rob

Gecealem, you are right, changes not show in homepage, but when you as admin or user make changes in profiles them user will apear in homepage.

mmmmm - didn't work for me, though the small profile maps seem to work fine.   Could someone post a link with the big map working for all members - I would like to see it.

Rob

Does the homepage map need the user to log in before they start showing up?  In D6 googlemaps mods required member logging in before the member would show up on the map, thinking this might be the same issue.

also the users which logged in are not shown on my site

Not only login, what you need to show user in homepage map is that users edit and save their profiles, in my page is what I saw

I had this same problem and noticed that the permission field needed to be updated in the maps profile table.  If you run this query it should fix it (Note - this selects all active profiles in the system - you may want to adjust as needed):

UPDATE `bx_map_profiles` SET `allow_view_location_to` = 3
WHERE `id` IN (SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active')

After running this the locations should appear in your main world map.

Darn, didn't seem to work on mine.  Still playing around with it.

Rob

p.s.  Does anyone one know how to display a partial map -i.e. for a state or city?  Does that use latitude and longitude?   Where are those settings?  That would be a nice thing to have on the World Map settings panel, wouldn't it?

Hi Rob,

Take a look in your bx_map_profiles table and double check that the geo data is there and if you ran that query they should all have a setting of 3 in the allow_view_location_to field, which lets them display on the main map.  Also double check the cities table (which I think is next to it in the list - it should have one instance of every city in your profiles table).

You can use the module settings to zoom into an area of your choice, i.e. state / county and then set it there.  This is what I did for my site as it is mostly Ireland and UK members.

Ian

Well you diagnosed the problem correctly Carnig - the city table is empty.  Good call, thank you for that.       

Trying to "update cities" however, generates a database error. Any more ideas?

Rob

UPDATE:  This worked on my CalTrade site - thanks again for posting it.  These errors are from a different site - still would like to solve it, but not as critical.

----------

Database error in

Query:

SELECT `m`.`country`, `m`.`city`, `m`.`lat`, `m`.`lng`, COUNT(`p`.`ID`) AS `num`
FROM `bx_map_cities` AS `m`
INNER JOIN `Profiles` AS `p` ON (`p`.`Country` = `m`.`country` AND `p`.`City` = `m`.`city` AND `p`.`Status` = 'Active')
INNER JOIN `bx_map_profiles` AS `pm` ON (`pm`.`id` = `p`.`ID` AND `pm`.`failed` = 0 AND `pm`.`allow_view_location_to` = '3')
WHERE `m`.`failed` = 0  AND `m`.`lat` < 35.406960932702 AND `m`.`lat` > 33.119150226769  AND `m`.`lng` < -113.5986328125 AND `m`.`lng` > -120.59692382812 
GROUP BY `m`.`city`
LIMIT 100

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

nice work with the sql update

Hi Rob,

First of all I am assuming you put mysite,cin in to replace your site for the purpose of this posting - if not the comma should definately not be there.  Assuming that you have the correct path I would at this point try from scratch:

Clean out both the bx_map_profiles and bx_map_cities by running delete from statements on both so there are no records left.  Also check the bx_map_countries table to make sure your countries are in there (don't delete anything from this table).  Then re-run the Update Profiles from the admin panel and wait until its done.  Once finished go back to your db and check the count of records in bx_map_profiles matches your actual system profiles table and if not keep running the Update Profiles until it does (I had to do this several times myself and it took several hours!!).  Only after that then run the Update Cities, which shouldn't take as long as the profiles as it only has one entry for each distinct city in your profiles - much less records.

Hopefully that will help.

Ian

Thanks for your help with this carnid.  Yes, that was to mask a site name - I will go through this procedure later tonight with that site.  I do have it working on my Catrade site though.  You can see it under the member block here: http://www.caltrade.com/community/

In general, I like it, but I don't like those blue icons that display a member location at all - what are those supposed to be - buildings?  I have some much smaller icons I like - can I use those there or is that from google?

Rob

Worked great on my site. Thanks a lot for this!

FuGuM

Glad the query worked for others too!  Rob, there are several different icons for the map module.  If you zoom out further these groups (which I believe are buildings to represent cities) dissappear and are replaced by country flags.  Alternatively if you zoom in you get individual icons for profile groups and / or photos of individual members.  All of these images (except the flags) are stored in path/modules/boonex/map_profiles/templates/base/images/icons/ and you can replace them as needed.  The one I think you are referring to is the city icon and on your site can be located here: http://www.caltrade.com/community/modules/boonex/map_profiles/templates/base/images/icons/city.png -  simply replace that image with something else keeping the name city.png and it should work for you.  By the way I like your site.

Cheers,

Ian

 DUDE!

Saved by another smart guy......!

Thanks!

Any ideas how to have different Avatars (or Icons) on the map for different Membership Types ?

for example , Student (red Icon) and Teachers (blue Icons) and faculty (house icon) ?