[irishrunner16]

Tried the geofetch code on an install with no other plugins running and that got it to display, but its only showing the following:

Coordinates:

[irishrunner16]

Hi Barry,

Before I got to your latest response, I had tried some additional testing. One test I did (as I was, and still am, thinking it might be a server related issue) was increase the php memory limit from 256m to 1500m. Initially that seemed to fix the issue, as all test events I submitted did generate the Lat and Lng values. I also tried running the snippet to force the generation of those values for the venues that are missing those. That started ok, but it eventually crashed the server (I did check the database and about 30-40 events that were missing lat/lng values did have them created before the timeout/crash). Since then, I’ve tried submitting a few more events, and the Lat/Lng values are once again not being generated.

I was hoping the memory was the issue (although I was a bit surprised it seemed to have an effect, given that I had it at at least 256mb all along), but given how things have taken a step backwards again since trying the snippet to force the generation of lat/lng, I’m not as confident that is the source of the problem. Unless there could be another setting on the server that is overriding the higher memory limit I had put in my htaccess file?

I just tried adding that geofetch code to my functions.php file, but I’m not seeing any block on the page. Not sure if that means it was unsuccessful or not?

This sure is proving to be a tricky (and frustrating) one! At least the memory test did yield some changes…although I’m still not sure why it’d require such a high limit or why it seemed to work temporarily?

Thanks again,
Sean

[irishrunner16]

Ok, so I tried running that snippet but it unfortunately did not create any _VenueLat or _VenueLng values for the venues that are missing those. I also tried the snippet with the default theme and only The Events Calendar plugins activated, but it still didn’t work. Finally, tried deleting VenueGeoAddress from an event and ran the snippet, which recreated the VenueGeoAddress, but still not Lat or Lng coordinates.

What else could I do to force the creation of the VenueLat and VenueLng meta values?

Thanks,
Sean

[irishrunner16]

Sounds good Casey. Yes, please feel free to close this out. If I notice any further issues with the website links moving forward, I’ll certainly create a new thread. Thanks again!

[irishrunner16]

PS – if that snippet is what you’d suggest trying next, is it resource intensive? Wondering if should I add it to my functions.php during off-peak traffic hours and/or disable Community Events for a certain period of time while it runs? Not sure how long it would take to have those values generated for ~450 venues?

[irishrunner16]

I haven’t been able to pinpoint why some of the Venues of my import did not generate _VenueLat and _VenueLng values. However, other than a few random venues, it looks like all imported Venues after ~2,725 did not have those meta values/rows created. So perhaps it was related to a timeout issue or something similar.

In any case, I tried a few different things to see what might create those missing meta values for all venues:
1. Tried re-uploading a few of those Venues, but doing so didn’t create the missing values.
2. I then tried deleting the _VenueGeoAddress for some venues, but using the “Fix geolocation data” option that appeared in the calendar settings only recreated the _VenueGeoAddress for the venues; no _VenueLat or _VenueLng was created.
3. Next, I deleted the _VenueGeoAddress meta value for a venue, and went into the Venue editor. I saved the venue, but again, it only created the VenueGeoAddress and not the Lat or Lng meta values.

So, although those didn’t work, the one-off solutions wouldn’t have been feasible anyways for my case (there’s 400+ venues from my CSV import that are missing the Lat/Longitude values).
With that said, is the snippet you mentioned in the following topic still valid? https://tri.be/support/forums/topic/map-view-missing-venues/
If so, it seems that would be my best course of action to get the VenueLat and VenueLng generated for all venues that have previously been added to my database.

Please let me know either way. Once I get the existing data fixed (which hopefully that snippet would do), I’ll then go ahead and tackle the second part of this issue…figuring out what is causing the events submitted via Community Events to not generate the VenueLat and VenueLng meta values.

Thanks and sorry for the long post!
Sean

[irishrunner16]

ok thanks Casey!

[irishrunner16]

1. Yes, I do have the default status of events set to be “pending review”. So if that is indeed a bug and can lead to the _VenueLat and _VenueLng meta_keys not being created when an event is submitted, I hope the fix will include a way for those rows to be created for any venue in which they don’t already exist?

2. I’ll do some further testing this weekend to see if I can duplicate the import issue on a default theme with no non-TEC plugins activated. Thanks.

[irishrunner16]

Casey,
I was able to fix the effected events (those that had two _EventURL per post_id, with the lower meta_id having no value in its _EventURL). First, I deleted the blank _EventURL for the respective post_id. I checked the site, but the events still were not displaying the website meta. So I then tried updating the events (via “Edit Series”) and after doing that the event website info is being displayed for all events in the series.

Again, I still don’t know how or why the duplicate _EventURL rows were created, but it seems that it happened around the same time I updated to the 3.5 release. Not certain that it was due to that update, but the fact that that update changed how recurring events are saved in the database, I’d be it was related.

In any case, I’m going to keep the affected events in my notes and will check them periodically moving forward to ensure that things continue to display correctly.

Thanks,
Sean

[irishrunner16]

This reply is private.

[irishrunner16]

Although that’d probably only fix the existing venues…would also need a permanent fix as well. I’m trying further testing here to see if I can figure out what the cause might be.

In the meantime please do let me know if there is any way to get the Longitude/Latitude values created for all of the existing events (hoping the “Fix Venues Data” feature you mentioned might do just that?)

[irishrunner16]

Hi Barry,
Thanks for the quick reply. I looked throughout the Events settings but am not seeing any such option. Sounds like it could be what I need. Is that a back-end feature that I’d need you guys to send me the code for and install/use at my own risk?

[irishrunner16]

I’ve confirmed there are other events missing the _VenueLat and _VenueLng meta_keys. They include events that have been submitted via Community Events, so it appears there’s an ongoing issue since both events uploaded with the CSV Importer and added via Community Events are missing those meta_keys. I’m perplexed since it appears the majority of the events in our database are correctly having those rows created when the event is added to the database.

[irishrunner16]

Ok, just want to make sure I’m understanding this correctly…
So to add custom styles for the Filter Bar I’d have to:
1. Add the function you created above to my functions.php file,
2. Copy the default styles from filter-view.css into my tribe-events.css file,
3. Make my customizations to the Filter Bar styles that are now in tribe-events.css

[irishrunner16]

Ok thanks Barry! That helps point me in the right direction.

[Author]

Posts