doxicology

Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • in reply to: Events don’t appear in admin listing #80359
    doxicology
    Participant

    Hey guys, so my issue turned out to be pretty simple. For whatever reason, Events Calendar was updated to the latest version, while Events Calendar Pro was still hanging out at version 2-something. An oversight on my part. Everything is now updated and working fine. It might be worth checking on your end, too.

    in reply to: Events don’t appear in admin listing #80126
    doxicology
    Participant

    Hey MT, I’m having somerthing similar, too. The events are visible on the frontend, but have disappeared from the admin listing. Here’s my debug info:
    – – – – – – – – –
    SAVEQUERIES must be defined to show the query log.
    – –
    TOTAL QUERIES:
    36
    – –
    TOTAL DB ERRORS:
    1
    Database Errors
    – –
    SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_9_posts.*, wp_9_postmeta.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(wp_9_postmeta.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) as EventEndDate FROM wp_9_posts LEFT JOIN wp_9_postmeta ON wp_9_posts.ID = wp_9_postmeta.post_id AND (wp_9_postmeta.meta_key = ‘_EventStartDate’ or wp_9_postmeta.meta_key is null) LEFT JOIN wp_9_postmeta as eventDuration ON( wp_9_posts.ID = eventDuration.post_id AND eventDuration.meta_key = ‘_EventDuration’) LEFT JOIN wp_9_postmeta as eventEnd ON( wp_9_posts.ID = eventEnd.post_id AND eventEnd.meta_key = ‘_EventEndDate’) WHERE 1=1 AND wp_9_posts.post_type = ‘tribe_events’ AND (wp_9_posts.post_status = ‘publish’ OR wp_9_posts.post_status = ‘future’ OR wp_9_posts.post_status = ‘draft’ OR wp_9_posts.post_status = ‘pending’ OR wp_9_posts.post_status = ‘private’) ORDER BY eventStart.meta_value DESC, IFNULL(DATE_ADD(CAST(eventStart.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) DESC LIMIT 0, 999 /* From [www.ghbc.org/wp-admin/edit.php?post_type=tribe_events] in [N/A] */
    – –
    Unknown column ‘eventStart.meta_value’ in ‘order clause’

Viewing 2 posts - 1 through 2 (of 2 total)