Urgent: Events disappeared after update

[madskjeldgaard]

Hi guys

I just bought the PRO add-on after having added some events to my calendar. Only problem is – I can get them to show now. When I click ‘events’ in the backend of WP it says, I’ve got 19 drafts and 20 private events (which is all correct), but no matter what I click it says ‘no events found’? I tried deactivating the pro addon which made the events reappear but when I activate the add on again they all disappear. Only if I make the events public before reactivating the addon will it work. But when I make them drafts and private again I can’t get them to display. Thanks!

[Neill]

Hi madskjeldgaard –
Sorry for the bumpy ride – it should be and usually is a lot smoother transition then what your are experiencing.

Can you do us a favor and give us an idea of what the URL is of your site? And maybe what version of the Pro Plugin you are running?

Neill

[madskjeldgaard]

Hi Neill

Thanks for getting back to me. Here’s a link: http://kbhlaeser.dk/program/
I use the latest version of both plugins – and as you can see, the events show up frontend, but they’re gone backend. They were created by another user than me, but I have admin rights and should be able to see them. Do you think that’s the problem? User permissions?

[Neill]

Do you by any chance have any debugging tools working on the site. This sounds like an issue we may have had in a previous release – but it was fixed and should still be fixed in recent updates. If you have a way of installing a debug tool and see if there’s any reports for the back end this might help us get to the root of the issue. – This is a fairly well used one: http://wordpress.org/plugins/debug-bar/ – let us know if this digs anything up.

Neill

[madskjeldgaard]

Hi Neill. I activated the above-mentioned debug bar and got this error:

SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, wp_postmeta.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(wp_postmeta.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id AND (wp_postmeta.meta_key = ‘_EventStartDate’ or wp_postmeta.meta_key is null) LEFT JOIN wp_postmeta as eventDuration ON( wp_posts.ID = eventDuration.post_id AND eventDuration.meta_key = ‘_EventDuration’) LEFT JOIN wp_postmeta as eventEnd ON( wp_posts.ID = eventEnd.post_id AND eventEnd.meta_key = ‘_EventEndDate’) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) LEFT JOIN wp_postmeta as tribe_event_duration ON ( wp_posts.ID = tribe_event_duration.post_id AND tribe_event_duration.meta_key = ‘_EventDuration’ ) WHERE 1=1 AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘private’) ORDER BY DATE(wp_postmeta.meta_value) DESC, TIME(wp_postmeta.meta_value) DESC LIMIT 0, 40
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

[Neill]

Hi madskjeldgaard,

Thanks for doing that – that is what I thought the issue might be – and figured it would kick up an error like that if it was indeed the issue I thought it was.

We have a little work around for this issue, which is related to some hosting providers. If you add the following code to your functions.php file you should see this work for you: https://gist.github.com/jazbek/6585714

Please let me know if this works, or if you need any further pointers?

[madskjeldgaard]

Hi Neill.
I did as you said and it seems to work perfectly. Nice, easy fix. Thanks 🙂

[Neill]

Great to hear madskjeldgaard!

I’ll close this one out, but feel free to open any new issues if you come across anything else.

Neill

[Author]

Posts