auditing events not showing on map display but on list display

[cyrilsack]

Hi folks,

I’m noticing some of my events aren’t showing on my map view, which is the default view for my calendar, making people report to me that I’m missing events, yet the events populate in the various list views. There must be something wrong with the venues for some events, but does anyone know a scalable way of identify all of them that are faulty?

Also, any recommendations on what might be causing some of the events to not show? Here’s a good example: https://adventureracehub.com/race/bend-ar-30-hour-adventure-race/

[Barry]

Hi @cyrilsack,

Thanks for posting – though I’m sorry to hear you’ve hit up against some difficulties.

In all probability, those events that are missing from map view probably are not associated with a venue or else the venue they are associated with does not have any geolocation data (perhaps because the address was not one that Google’s geolocation API could interpret, or else network difficulties may have prevented that information from being returned to the site).

Are you comfortable running database queries? If so, something like the following could help you to identify any venues that do not have geolocation data:

SELECT wp_posts.ID,
       wp_posts.guid
FROM   wp_posts

LEFT JOIN wp_postmeta ON (
	wp_posts.ID = wp_postmeta.post_id
	AND wp_postmeta.meta_key = '_VenueGeoAddress'
)

LEFT JOIN wp_postmeta AS venueless ON (
	wp_posts.ID = venueless.post_id
)

WHERE (
	wp_postmeta.post_id IS NULL
	AND ( venueless.meta_key = '_VenueAddress' 
		AND venueless.meta_value != '' 
	)
) AND (
	wp_posts.post_type = 'tribe_venue'
)

GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC

[cyrilsack]

Hi Barry, thanks for the suggestion. I’m moderately familiar with SQL, so the query you’ve provided above isn’t strange to me. However, I’m totally ignorant as how to query against Events Calendar. Can you provide any guidance on how to setup the necessary framework to even do the query? Are you using SQL workbench or something similar to run the query? How do you setup access to the database?

[Barry]

Hi 🙂

Yep, you’d need a tool such as SQL Workbench, phpMyAdmin or similar. Lots of web hosts provide access to phpMyAdmin from the hosting control panel and, if that’s true of your hosting account, you can use that.

It’s worth noting though that the table names in my example are prefix wp_ whereas in pratice they could be something else. If you can connect via phpMyAdmin and view the list of tables, though, this should become pretty clear.

I hope that helps!

[cyrilsack]

alright, I took a shot at it through the existing database manager in my cPanel. If I did it correctly (big IF), it’s saying there are 0 results, which clearly isn’t the case as we know there are events not populating on the map. Can you take a look at the attached file and see if you spot anything wrong?

What’s weird is this location (Bend, OR), has shown on the map before, and I’ve even gone so far to include a specific street address and Lat/Long to make sure the map knows precisely where it is.

[Barry]

Hmm, perhaps the problem is something other than what we thought.

Can you link me to an upcoming event that has a venue, but is not showing in map view, so I can take a look and see if there’s anything else unusual about it?

Thanks!

[cyrilsack]

sure thing. Take a look at this event: https://adventureracehub.com/race/bend-ar-30-hour-adventure-race/
the individual event displays on the Google Map widget, but when you look at the overall calendar in Map view, it’s nowhere to be found. Instead, you’ve got to switch to list or month view to find it: https://adventureracehub.com/adventureracescalendar/

[Barry]

Hi Cyril,

The venue associated with that event does appear to have valid geolocation data and I also see it within map view (albeit on page 2, approximately half way down the page).

To avoid over-taxing typical web hosting environments, the plugin will only display up to a certain number of results at any one time – and the rest are accessible by paging forward. You can however configure this, if you are confident your hosting setup can handle it, by altering the number of events to show per page setting found within the Events → Settings → General admin tab.

Does that clarify things at all?

[cyrilsack]

Hi Barry,

Thanks man, that helps a lot. I feel embarrassed the fix was that easy… I should have found it myself

[Barry]

Nope no worries, glad it wasn’t something more serious. I’ll go ahead and close this topic – but if anything else crops up please don’t hesitate to let us know by opening a new topic and one of the team will be only too happy to help 🙂

[Author]

Posts