Forum Replies Created
-
Posts
-
Thanks, I found it and removed it. Will let you know if there are any issues going forward, but I think we are set.
Hey! I couldn’t figure out how to add the plugin you sent (I suspect the Add New button is disabled by our developer). So, I forwarded the instructions, etc onto our website developer and he figured out the issue. He sent this along to me, which may mean more to you than it does to me. But I thought it might be useful for your team:
WordPress runs the main query twice in the Admin (I never noticed this before, not sure if it’s default or some plugin causing it). Once seemingly right away, and once again right before the main wp-list-table element is printed (actually before tablenav-pages).
In the ECP Date_filter.php file ( events-calendar-pro/src/Tribe/APM_Filters/Date_Filter.php ) line 74, the “where” function is removed so that it’s only called once per page load. So, it’s called on the first query but not in the query that’s actually used to show the Admin table of posts.I print_r the request string at the ‘posts_request’ filter to verify that the query is bein run twice and that the second time it has no reference to my date details (but doe in the first one).
To prove it out, I went ahead and temporarily commented out that line and all of our date filters work again; the WHERE data is in the ”posts_request’ string both places and the correct events show.
[code] // remove_filter( ‘posts_where’, array( $this, ‘where’ ), 10, 2 ); [/code]
Doing some more tests, the Dates, Title, & Description filters all have the same issue – the filters do nothing. Commenting out that line makes it work as expected. Hoping for a longer term solution, but it shows the problem at least.
Title_Filter.php – line 43
Content_Filter.php – line 32
Date_Filter.php – line 73The Venue, Organizer, & Recur Filter files have no such remove_action and work as expected.
Using:
WP (Multisite) Version 4.8.3
The Events Calendar – Version 4.6.6
The Events Calendar PRO – Version 4.4.19I just tried October 27th, that gave me 9.5 pages of Dec. 25, with the remaining 1/2 page devoted to Dec. 23rd and 24th. Which, will help me in deleting my Christmas Day classes, I guess.
Whatever the logic is, we are going to need to learn to think like a computer to figure this one out;).Yes, the 4 pages are all Dec. 20th.I can share a copy of my database – if you tell me how to do that.
If you can’t figure out where this disconnect is, maybe you can just figure out what date I should select to return results of all classes on 11/23/17 – okay that was just a joke! I realize being snarky is difficult via chat.
I had my developer update the plugin, because, although it may have been simple, it was not simple for me. So, we are updated now, but the issue is not resolved. I sent a screenshot of the results I get when I filter for 11/23/17. Oddly, I now get all events on 12/20, which, although an improvement over the previous results, is still not what I requested;). I included another screenshot.
I did not see that the Events Pro had an updated version available. I updated the Events Calendar (it did say there was an update available for that), but there was nothing available on the plugin update list. I have a current license, so I should certainly qualify for any updates, but have gotten -0- messages about any updates available for months now.
I updated the EC plugin, and still get same results – see screenshot attached.Thanks. When I checked the lat/long box, it gave me blanks for the numbers, which I didn’t know, but I updated anyhow and now the map is showing. Weird – but if it works!
Yes, I did get your reply this time. My developer said that he got the message that the key was out of installs as well. I am going to check back with him to see if he followed your directions.
I will try this and get back to you. Oddly, I never got an email notification that you replied to my question, either. This is not normal.
Here’s the results of the query:
SELECT count(*) FROM wp_2_posts WHERE post_type = ‘tribe_events’
24,984 (was ~49,000 five days ago)SELECT count(*) FROM wp_2_postmeta WHERE post_id IN (SELECT ID FROM wp_2_posts WHERE post_type = ‘tribe_events’)
434,231 (was ~914,000 five days ago)SELECT option_value FROM wp_options WHERE option_name LIKE ‘_transient_tribe_63556_status’
returns “complete”These notes from my developer:
So maybe it is still running? I’m not sure what the “complete” status means, but the data set is about halved so maybe in a few more days it’ll be finished running?
Nothing changes if I refresh the page.
The only time it appears to be doing anything is if I go into one of the classes and update. Otherwise, nothing seems to be going on.
I will ask the developer to run the query you requested.If I load any event, it gives me the “updating” message (Recurring event data is still being generated for this event. Don’t worry, you can safely navigate away – the process will resume in a bit in the background.). If I leave the window open, and check back periodically, the timer indicator does move. Often, it will give me a “connection lost because the process is taking too long”.
On the other hand, if I create a new event, it goes faster than it has ever gone before.
It has been approximately 72 hours that all the programs have been updated, and this process still appears to be going on in the background. Is there any way of telling if it is actually doing anything? 72+ hours seems like a LONG time, but not sure what would be expected?Actually, it has been dragging down, slowly over the past few months. I noticed yesterday, when I created a new event, it was so fast, I couldn’t even believe it!
But yet, events that were created previously, are still scheduled out until April 2018. Which, of course, is not necessary. So, I am currently following your direction and updating one of the “offending” events (edit all), hoping that will clear things up.
Otherwise, my only option that I could see available was to sort by date, “select all” on one page and delete all. Then repeat for each page of the extra events. Then do that for each community which we have classes in. This could literally take me DAYS of doing just that. We have 100’s of communities with classes running 3 days per week. If you can imagine the size that this database has grown to because of this issue. I literally have 9-15 PAGES of 20 classes events for each community. And I just checked, we have 199 communities with classes running. I’m no math major, but 12 pages for each of 199 communities gets to be ALOT OF DATA. IF you can imagine why this bug stopped our website dead in its tracks…I still have one question in regards to this particular question as copied below:
“Recurring event data is still being generated for this event. Don’t worry, you can safely navigate away – the process will resume in a bit in the background.” – after which the whole system locks up for about 6 minutes. Even ith the setting set to only one month in advance, this process doesn’t remove the 2year-out repeated events. This may have been there before but I never noticed it.
This was especially helpful to note. It was a great idea to change that setting. It has been part of our plugin for ages, but if you don’t need events 2 years out then modifying it down to a few months is clever. Setting it to 1 month for now does not hurt at all, and will cut down a little on the amount of time your calendar needs to correct things. Once it finishes correcting things those events 2 years out should disappear, but correcting stuff will take a while.This seems to indicate to me that the fix should clean-up all of those recurring events that are beyond 1 month in advance? Is this correct?
