[madskjeldgaard]

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

[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

[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?

[Author]

Posts