WordPress Database Issue

  • Resolved wiscoradio

    (@wiscoradio)


    9 years, 9 months ago

    When we go to the page that our calendar is on, we receive a wordpress datebase error in the header of the page but we can still see the calendar. Any help eliminating this error would be great.

    http://wiscoradio.com/calendar/

    Database error –

    WordPress database error: [Unknown column ‘wp_postmeta.meta_value’ in ‘field list’]
    SELECT DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate 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.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘private’) ORDER BY EventStartDate DESC, wp_posts.post_date DESC LIMIT 0, 1

    https://wordpress.org/plugins/the-events-calendar/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Geoff Graham

    (@geoffgraham)

    9 years, 9 months ago

    Hey there!

    What version of the plugin are you using and what version of WordPress is running? I’d like to see if that same error pops up in my test site because I haven’t seen that notice pop up before.

    At the very least, please update to version 4.2.1 (just released last night) and then follow the steps in this guide to help test for conflicts.

    Cheers!
    Geoff

    Thread Starter wiscoradio

    (@wiscoradio)

    9 years, 9 months ago

    Geoff,

    Thanks for the response. We are using the plugin version 4.2.1, WordPress Version 4.5.3, and the Optimizer PRO theme version 0.4.4. We did the process of elimination with the theme and all of the plugins and narrowed it down to one plugin that is causing the error. That plugin is ‘Page Builder by SiteOrigin’ (2.4.9) and is what we use to help create some page layouts. Is there a way to troubleshoot it so we wouldn’t have to get rid of that plugin or are we sort of out of luck?

    FYI, the page placement moved and the new URL http://wiscoradio.com/schedule/

    Thanks

    Geoff Graham

    (@geoffgraham)

    9 years, 9 months ago

    Nice work finding the conflict!

    I’m afraid that I have not seen any solutions for this in the past but do know there are some general compatibility issues with The Events Calendar and some page builder plugins, like this. When we’ve looked at it in the past, it often requires updates and changes to both plugins in order to make them integrate well together.

    Since that would be a feature more than anything else, it would be cool if you could add that to our feature request forum — we check there often and let people vote on things that we can work on for future releases.

    Thanks,
    Geoff

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

The topic ‘WordPress Database Issue’ is closed to new replies.