Query error

  • Resolved luisfbmelo

    (@luisfbmelo)


    4 years, 7 months ago

    At the month view, I am getting an SQL error from the plugin:
    Unknown column 'EventStartDate' in 'order clause'

    SELECT wp_posts.ID
FROM wp_posts
WHERE 1=1
AND wp_posts.post_type = 'tribe_events'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'acf-disabled'
OR wp_posts.post_status = 'tribe-ea-success'
OR wp_posts.post_status = 'tribe-ea-failed'
OR wp_posts.post_status = 'tribe-ea-schedule'
OR wp_posts.post_status = 'tribe-ea-pending'
OR wp_posts.post_status = 'tribe-ea-draft'
OR wp_posts.post_status = 'private')
ORDER BY EventStartDate DESC, wp_posts.post_date DESC
LIMIT 0, 1
Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi @luisfbmelo,
    Thanks for reaching out.

    Our team has already spoted this issue and we are working on a fix that will be released soon.

    I will link this thread to the internal ticket to make sure you get a notification as soon as the fix is available.

    Thanks for your patience.
    Santiago

    Plugin Support Jaime

    (@jaimemarchwinski)

    Hi @luisfbmelo

    Just wanted to let you know that a new maintenance release is out, including a fix for the issue that you were experiencing.

    Find out more about this release → https://theeventscalendar.com/release-notes/the-events-calendar-5-1-6/

    Please try updating and let us know if you are experiencing any further issues. As always, we recommend running updates on your staging site before doing so on your live site, just to be on the safe side.

    Thanks again for your patience while we worked on getting this fixed!

    Plugin Support Jaime

    (@jaimemarchwinski)

    Hey there! This thread has been inactive for a while so we’re going to go ahead and mark it Resolved. Please feel free to open a new thread if any other questions come up and we’d be happy to help.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Query error’ is closed to new replies.