- This topic is empty.
7th August 2020 at 5:16 pm #3061
Trying to use the short code [church_admin_map member_type_id="#" zoom="13" small_group="1"] but there is a false small group in the database (even if you use the function to “Remove/Delete all small groups”) whose location is somewhere in the Gulf of Guinea. The problem this causes is that the map tries to use your zoom level and centers in the middle of nowhere (between the Gulf of Guinea and real groups – like Michigan, US) – so the map looks blank until you zoom out to a global level. Help with this specific DB issue would be appreciated, as it directly impacts the end user.
P.S. There are other database artifacts that I can’t seem to account for (like extra blanks showing up as “Venue’s” in addition to the two real venues I created). Is there any advice on where these entries are at a DB level, and safe ways to clean them?7th August 2020 at 5:22 pm #4669
Oh dear! I’ve never heard of that happening before!
The xml file that puts the pointers on the map is generated on the fly – but your browser probably caches it – Shift F5 will be your friend (or hold shift while clicking refresh)
So if you are happy to delve into PHPMyAdmin – the tables to look at are
Assuming wp_ is your table prefix (it’s the default!)
wp_church_admin_smallgroup – you can delete that pesky group if it’s hiding.
wp_church_admin_sites will contain any erroneous venues – that’s more important as the small group map centre is an average of your sites!7th August 2020 at 6:36 pm #4670
The good news is – there are no erroneous database entries. I also located the issue:
It is a BLUE pin and specifically says “Small Groups null” when you click it. I manually inserted some “central” coordinates to the “unattached” group ID #1 (instead of “NULL”) – and that fixed it. For some reason, “unattached” does not show up in PDF export and such, but it does map as it’s own group using that shortcode. Please check the XML generation to exclude group index #1 “unattached”.
Unfortunately, even though all my pins are now moved into the correct are, I cannot get the map to move its default starting position. I cleared my cache, etc, and it still shows me opening in the same old spot… Any ideas?
Thanks7th August 2020 at 11:36 pm #4671
Worked it out. The map was centred (blue pin) on the average of site venues lat and lng. That was causing an issue especially if you have a non-gecoded site! So now it centres on the first site.8th August 2020 at 12:24 pm #4672
I updated the plug-in, but there was no discernible change. If I revert the “Unattached” default group ID 1 (that comes with the plugin) to NULL in the DB, then the map generation puts it back in the Gulf of Guinea, which makes the map center in the middle of nowhere (since my other groups are in Michigan). Also, if I then plug in manual coordinates for group ID 1 “Unattached” – it will successfully show the blue pin in Michigan, but my map still centers in the middle of nowhere, as if I still had a location in the Gulf of Guinea.8th August 2020 at 12:56 pm #4673
OK, I found the issue with the centering now… Apparently the maps function is considering the “Sites” list as well. We had a “Site” with an address of “virtual – online” – which of course Google maps could not resolve. When I updated that to have a physical address, the map shortcode is now working.8th August 2020 at 4:13 pm #4674
The latest update now just uses the first site stored, but I think I must get it to check it is geocoded!10th August 2020 at 9:21 pm #4676
So, with all the work done above (the key being putting an address on all venues – even if they are virtual), as I mentioned, the map at least displays the groups and centers in nearly the correct area. This blue flag in the Gulf of Guinea is just killing me though. I’m the sort of guy that knows it’s there – just waiting to glare back at me if I zoom the map out – and not knowing where it is coming from is keeping me up at night LOL.
I mean, why is it labeled:
…when I have literally one household with a geocached address, one small group with an address, the default “unattached” group (which I also even gave an address to), and two venues with addresses? (and there are no extra records in the database) Where is this blue tag coming from? Thanks,
Nathan10th August 2020 at 9:25 pm #4677
Can you give me a login at support@ so I can take a look. Seems weird!
It maybe that your browser has cached the xml file that is created for small groups and so it is still there. Try deleting your internet cache and see if that fixes it
- You must be logged in to reply to this topic.