phantom trash entries

[Jen Russo]

I have deleted any events that were in the trash, however the number of posts next to the word trash still reads over 1900

I cant figure out what this is referring to or how to get these posts to delete them

[Geoff]

Hey mauitime! Nice to see you and hope all is well. 🙂

That is certainly odd. It does appear that there is built-in caching for those post queries on the back end–so, it is possible that there is some kind of caching happening there that has simply not updated yet and needs more time.

You could also double check to see if these events exist in the database. For example, you could run this MySQL query to calculate how many total events there are. If this number is less than the number next to All on your screen there, then it’s likely caching. If the number is the same, then those trashed events do in fact exist.

[php]
SELECT post_status,
Count(*) AS num_posts
FROM wp_posts
WHERE post_type = ‘tribe_events’
[/php]

Here’s another possible query to try that will check which posts are actually marked as being trashed. If this returns no results, great! If it returns 1,900, then there is definitely something weird going on.

[php]
SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.*
FROM wp_posts
WHERE wp_posts.post_type = ‘tribe_events’
AND wp_posts.post_status = ‘trash’
LIMIT 0, 999
[/php]

Let’s start there and see what we find.

Cheers!
Geoff

[Geoff]

Hi mauitime! Just want to follow-up to see if you were able to give those queries a test and, if so, what the results were. I’m definitely interested in knowing!

Geoff

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts