[Andy]

We are good for now, more of a monitoring game. You’ve been a huge help, thank you! I will make a new reply if we need further support but so far so good — thanks for following up!

[Andy]

This appears to be the missing link I’ve been mentioning! We’re back to 1048 – will leave the plugin active and see how we look in the AM.

Thank you!

[Andy]

This reply is private.

[Andy]

I restored to the back up of those tables; but never ran SELECT * FROM wp_posts WHERE post_type = 'tribe_events' before running the SQL examples provided.

I think my concern is, if we do not have caching (something affecting what is returned from wp_count_posts()), and there is to be a 1 to 1 correlation between that query and All Events counts, where is this disconnect?

Also, I only see “Trash Series” when hovering over events in that listing. I do see “Edit Single” which warns me I am “about to break this event out of it’s series” – does that give any additional insight/leads to the issue?

I’ve also noticed 2-3 updates since this thread has began. I ran those today.

After disabling the plugin, I used the following code to register a post type of the same name:

add_action( 'init','szbl_events_register');
function szbl_events_register()
{
  register_post_type( 'tribe_events', array(
          'labels' => array( 'name' => 'Tribe Test' ),
          'public' => true,
          'name' => 'Events',
          'show_ui' => true
  ));
}

It shows the 1:1 count match to the count in the database:
https://www.dropbox.com/s/n24bid2x00k0w2i/Screenshot%202016-01-18%2014.33.54.png?dl=0

[Andy]

Barry,

This effectively takes us back to square one. What I’m seeing:

• Either the plugin is incorrectly reporting the events, or they are stored some where other than a post WHERE post_type = 'tribe_events' – the plugin reports 21,000+ and the database says ~1,100.
• Given the database response, the queries provided won’t work as the posts don’t actually exists
• The CRON script is not running and does not remove events older than 2 months or later than 2 months as it still reports 21,000 even when the CRON tasks (2 of them for Tribe/Events) have been explicitly run multiple times and it’s been over a week.

What is the next step? We effectively have upgraded the plugin to have our site go down or eliminate all of that content from the site.

Everytime I have to turn on the plugin to test / run commands, I have a short amount of time before the MySQL server stops responding due to the queries.

Let me know, please.

[Andy]

Do, how do I know if I’m deleting the entire recurring event or an instance?

[Andy]

Barry, I got the “real” count from:

SELECT * FROM wp_posts WHERE post_type = ‘tribe_events’;

It’s about 1,095 or so; but I even creating / deleting a new event (“Mine (1)” displayed while it was created) – “Trash (1)” displayed after trashing;

More interesting: When viewing the trash for Tribe Events, it says there are “no events found in trash”

Thoughts?

[Andy]

Barry – clear what cache? Browser cache? We do not have a caching plugin or caching installed on the server. I am unaware of internal cache’s running within WordPress by default that we have a UI to clear? Please clarify.

[Andy]

So, I played with this and just restored our tables and re-ran “SELECT * FROM wp_posts WHERE post_type=’tribe_events'”

It returns 1053 total posts.. but our Event’s listing in the admin still says 21,753 – any thoughts?

The query kind of wiped out all posts, so I had to revert.

[Andy]

I ran the CRON job immediately upon re-activation via WP Crontrol with no luck. Still have over 21,000 events.

Can you please give me information about the $wpdb->posts and $wpdb->postmeta post types and key/value pairs to look for to find (and subsequently remove) the expired events?

I take full responsibility for my database actions and can write the SQL myself, just need a short narrative of what fields hold what (specifically the event instance date/time) so I can delete anything before today.

[Andy]

This reply is private.

[Andy]

As another note, I will leave the plugin on as long as I can today (3pm EST latest) to see if the site performance is ok now.

[Andy]

The Events Calendar is at 4.0.4
The Events Calendar Pro is at 4.0.3
WordPress is 4.4.1

That is the correct URL but we toggle the plugin off because it takes the entire site down and we have tons of marketing/campaigns running, not to mention the site helps power a lot of in-club displays.

I have updated the settings to 1 month for keeping events; creating events is set to 2 months. Hopefully this will clean A LOT up.

Let me know if saving the settings will purge the old events or if there is another method of purging?

[Andy]

This reply is private.

[Andy]

This reply is private.

[Author]

Posts