Forum Replies Created
-
AuthorPosts
-
March 29, 2018 at 5:30 am in reply to: Calendar PRO still crippling our site, need to eliminate Google Map queries #1491540Mike KirbyParticipant
Thank you Andras,
We will update our PRO plugin on staging today, and plan to update production on Sunday.
February 27, 2018 at 10:54 am in reply to: Events Calendar PRO crippling our site, can google map queries be shut down? #1465151Mike KirbyParticipantMy server admin says “we’re down to a very small number of active processes now. The database seems to be keeping up at this point, but I’m afraid what will happen when we get a boost in traffic (say a siteimprove/monsido scan).”
February 27, 2018 at 10:48 am in reply to: Events Calendar PRO crippling our site, can google map queries be shut down? #1465139Mike KirbyParticipantHi again,
We added this to our site, but when we restored the PRO plugin the database was hammered again. Attached is a sample query of what’s eating up resources.
February 26, 2018 at 12:45 pm in reply to: Events Calendar PRO crippling our site, can google map queries be shut down? #1464167Mike KirbyParticipantWe have read the materials you linked to, the caching discussion appears geared toward sites that don’t leverage the event calendar to the extent we do.
For example, our home page umaine.edu lists events from calendar.umaine.edu in the ‘event highlights’ category; there are many such areas of our site where events from calendar.umaine.edu or any other site on our multisite network can be listed on any other site. Caching this would take an enormous amount of resources I think.
Are there any tools or commands that can be used to clean up the event calendar data? For example, deleting all events where the end date was more than 12 months ago, or —even better— a way to delete all venues that are not currently in use?
I single out the venues because what appears to have happened is that the venues in the system are querying Google Maps API on the back end, and when those number in the thousands it is bringing our server down.
I can put you in direct touch with my system administrator, he can share more about our specific hardware setup and what he is seeing in the logs.
February 22, 2018 at 6:15 am in reply to: Events Calendar PRO crippling our site, can google map queries be shut down? #1460834Mike KirbyParticipantDo I need to provide more information? We are currently running without Events Calendar PRO due to this issue and we need to get the recurring event feature back in place ASAP.
Mike KirbyParticipantMy attempts to upload screenshots are failing. I guess you’ll have to take my word for it that these are set to import daily but have not imported since early September.
August 16, 2017 at 8:26 am in reply to: Google Calendar import probem— ical file showing events not in calendar? #1336017Mike KirbyParticipantWe had the owner of the calendar delete an OLD “Upload Study USA” event that was showing up for February 2017, and that seems to have gotten rid of these odd entries.
The calendar we are importing was created more recently than that, so it’s very strange that this event in February would have attached itself to this calendar in the first place.
I’ll leave this open in case this is a known issue we can avoid, if we see no further oddities I’ll close in a few days.
August 16, 2017 at 5:36 am in reply to: Using event aggregator on staging server for testing #1335951Mike KirbyParticipantThat worked for me (disconnecting/reconnecting the license key), I’m able to test the event aggregator on my staging server now. Many thanks.
January 19, 2017 at 6:46 am in reply to: Multisite WordPress site — regular outages due to calendar db problems #1220898Mike KirbyParticipantThis reply is private.
Mike KirbyParticipantHi Geoff,
I have returned from vacation, any updates on this issue? I see that Events Calendar Pro was updated on 4/11, but the ical importer is still at the version we are using.
Mike KirbyParticipantThis reply is private.
- This reply was modified 8 years ago by Mike Kirby. Reason: set as private so the whole world doesn't know I'm on vacation lol
Mike KirbyParticipantLooking at the category pages on our website, it looks like it is the Intramurals calendar that is repeating, and the others are not.
https://umaine.edu/campusrecreation/events/category/group-exercise/month/
https://umaine.edu/campusrecreation/events/category/kids-and-family/month/
https://umaine.edu/campusrecreation/events/category/maine-bound/month/
https://umaine.edu/campusrecreation/events/category/public-skate/month/
https://umaine.edu/campusrecreation/events/category/session-based-fitness/month/I believe the large quantity of events is not actually duplicates but rather events going back to 2013. Does “import all” pull all events in the ical file, or all events that show up based on the original query (setting what date to start finding events)?
A venue is duplicating as well, with the group exercise category. An example: https://umaine.edu/campusrecreation/venue/free-this-week-only-57/
Note, the “FREE this week only)” is actually what is appearing within the event location field: https://calendar.google.com/calendar/render?eid=dGN1dDliZTU0cWZvZ2RrbG1jYmtlY2tnM2MgdW1jcmVjQG0&ctz=America/New_York&sf=true&output=xml#eventpage_6
Most of these I checked had no upcoming events.
Mike KirbyParticipantAs far as I know, you are simply using the public link provided by Google Calendar, could you confirm ?
Correct— We have calendars via Google Apps for Education that are made available to the public via their sharing settings, here is one such calendar embedded in an iframe on our public website:
We then go to ‘calendar settings’ for the named calendar, and choose the ICAL web address from the Calendar Address section. I can share more of these calendar URLs if that will help with testing (some are empty unless the importer is set to import past events):
Group Exercise – https://calendar.google.com/calendar/ical/umcrec%40gmail.com/public/basic.ics
Intramurals- https://calendar.google.com/calendar/ical/7357k65seetlltq4b7ochq0ckc%40group.calendar.google.com/public/basic.ics
Kids and Family – https://calendar.google.com/calendar/ical/hlnnufqgqtjmum8j7rb3bagm7o%40group.calendar.google.com/public/basic.ics
Maine Bound – https://calendar.google.com/calendar/ical/b1r1vmcqv7th4m31aam09ukps8%40group.calendar.google.com/public/basic.ics
Public Skate -https://calendar.google.com/calendar/ical/b1r1vmcqv7th4m31aam09ukps8%40group.calendar.google.com/public/basic.ics
Session-Based Fitness – https://calendar.google.com/calendar/ical/fbcmcak43k6bklsj0gd602k768%40group.calendar.google.com/public/basic.ics
Special Events – https://calendar.google.com/calendar/ical/4hpq8ap5ogu6roiv1oisilg0pg%40group.calendar.google.com/public/basic.ics
- This reply was modified 8 years ago by Mike Kirby.
Mike KirbyParticipantHi Geoff,
This is helpful, and sounds like it does identify why we are seeing duplicate events on subsequent imports.
Is there a better link we should be using to import Google Calendars in particular?
Kind regards,
Mike
-
AuthorPosts