SQL Error

  • Resolved seanweidemann

    (@seanweidemann)


    9 years, 7 months ago

    Hi

    I am using the latest wordpress and latest Events calendar 4.3.2 nd I get this SQL error when Debug mode is on.

    WordPress database error: [Unknown column ‘EventStartDate’ in ‘order clause’]
    SELECT DISTINCT wp_posts.ID FROM wp_posts 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’ ) WHERE 1=1 AND wp_posts.ID NOT IN (11865,11874) AND wp_posts.ID NOT IN (11938,11920,11907) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ 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_author = 3 AND 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)
  • Thread Starter seanweidemann

    (@seanweidemann)

    9 years, 7 months ago

    On the list view and day view I also get this
    Notice: Undefined index: name in /home/l1f3styl3d1r3ct/public_html/wp-content/themes/Avada/tribe-events/list/meta.php on line 32

    shelbelliott

    (@shelbelliott)

    9 years, 7 months ago

    Hey Sean,

    I think a couple of these are being fixed in the next release. You can look into that here.

    It also sounds like there may be some theme conflicts or plugin conflicts happening. Can you try testing for conflicts and let me know what happens?

    Thanks,

    Shelby

    shelbelliott

    (@shelbelliott)

    9 years, 6 months ago

    Hi there,

    Looks like it’s been a week or more since we’ve seen activity on this thread! I’m going to go ahead and mark this resolved, but should you still need assistance, please don’t hesitate to open a new thread!

    You may also find the following documentation helpful to search in the future:

    TEC Knowledgebase
    TEC Technical Documentation

    Cheers,

    Shelby 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘SQL Error’ is closed to new replies.