Are you using a multi-site install of WordPress?
maybe you can check your wp_em_events table for unknown events and/or wp_posts tables?
Thread Starter
catyco
(@catyco)
What do you mean by “known”. I gone through both tables and it appears that data looks good.
When you look at the dates in the database, do they look ok?
Thread Starter
catyco
(@catyco)
Yes, the data looks good. I found a support topic that had the same issue
http://wordpress.org/support/topic/another-place-to-look-for-ghost-events-with-datejan-1-1970-besides-em_events?replies=11
I removed and added back the widget which “resolved” it. However, the pages are still displaying 1970
have you checked wp_posts ?
Thread Starter
catyco
(@catyco)
@angelo – I did some further investigation and I found something interesting. With the events that are displaying 1970, I saw the following:
1. The event created date is null
2. There is a post ID. However, when I go to the wp_post table and search by the post ID, the results came back zero.
I deleted the event and then recreated it and now it displays the event created date and when I go to the wp_post table, the post is listed.
Currently, I am querying the em_events and wp_post tables to see how events that do not have a related post.
Thread Starter
catyco
(@catyco)
The query showed that I had 2062 events that did not have a post associated with it.
See attached link
http://members.blackgirlsrun.com/wp-content/uploads/2013/06/Events-with-No-Post-ID.xlsx
This is the query I used
SELECT event_id, post_id, id, event_name,event_date_created FROM wp_em_events
LEFT JOIN
wp_posts
on wp_em_events
.post_id=wp_posts
.id
Thread Starter
catyco
(@catyco)
If you look at the data, it goes back to April 2013. This issue showed up last week.
We have over 7400 events and 720 locations.
Have you modified the database table in any way? It sounds like it might be out of sync.
Thread Starter
catyco
(@catyco)
We have not made any changes to the table.
I see, thanks for the additional detail; however, I can’t seems to replicate this and if you have additional info. on how can we can replicate this would be great.
Thread Starter
catyco
(@catyco)
@angelo….that is the issue. I have not been able to replicate it. If you look at the data I provided it is intermittent
the problem is because somewhere down the line, events got deleted from wp_posts, but not wp_em_events, and so you’re displaying events that don’t have the corresponding post.
If I remember correctly, a recent update should address this, so that info is grabbed from the wp_em_events table directly rather than blanking out. have you tried updating?
the other solution is to delete those events that have no post id associated with it.
as to why they didn’t get deleted automatically, we can never reproduce this, we suspect another plugin is doing this but it’s hard to tell since it’s not consistently reproduced. e.g. if you delete an event, do you get the problem with new events?