WordPress database error Unknown column

  • Resolved stevebrett

    (@stevebrett)


    2 years, 4 months ago

    Hi this is appearing in our error log- should it be fixed? How would i go about trouble shooting this?

    Thanks for any pointers

    [18-Jul-2022 14:34:50 UTC] WordPress database error Unknown column ‘wph2_postmeta.meta_value’ in ‘field list’ for query
    SELECT DISTINCT wph2_posts.*, MIN(wph2_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate
    FROM wph2_posts LEFT JOIN wph2_term_relationships ON (wph2_posts.ID = wph2_term_relationships.object_id) LEFT JOIN wph2_postmeta as tribe_event_end_date ON ( wph2_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ )
    WHERE 1=1 AND (
    wph2_term_relationships.term_taxonomy_id IN (785)
    ) AND ((wph2_posts.post_type = ‘tribe_events’ AND (wph2_posts.post_status = ‘publish’ OR wph2_posts.post_status = ‘tribe-ea-success’ OR wph2_posts.post_status = ‘tribe-ea-failed’ OR wph2_posts.post_status = ‘tribe-ea-schedule’ OR wph2_posts.post_status = ‘tribe-ea-pending’ OR wph2_posts.post_status = ‘tribe-ea-draft’))) AND wph2_posts.post_type <> ‘chervinsky-app’ AND wph2_posts.post_type <> ‘juried-show-app’ AND wph2_posts.post_type <> ‘nepr’
    GROUP BY wph2_posts.ID
    ORDER BY EventStartDate DESC, wph2_posts.post_date DESC
    LIMIT 0, 1
    made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Abz

    (@abzlevelup)

    Hi @stevebrett, thanks for reaching out to us. Sorry to hear about this one, let me help you.

    First, I’d like to ask, what was the last action when the issue shows or the trigger of the error here?

    I suspect that the WordPress was not installed properly, or the field was accidentally deleted, as the field that’s missing here is default to WordPress. I would suggest creating a new staging site and trying to reinstall WordPress and install the plugins. See if the issue still persists.

    Looking forward to hearing from you.

    Best,
    Abz

    Thread Starter stevebrett

    (@stevebrett)

    Thanks There are a number of people who wok on this site- But we cant pin point the onset of this issue to anything any of has done.

    Also this is a large and somewhat busy site and unfortunately they don’t have room in their plan to create a staging site.

    Is there a way i could look and see if the field exists and possibly recreate it in another way

    Plugin Support Abz

    (@abzlevelup)

    Hi @stevebrett, thanks for getting back to me here.

    What we recommend is doing the testing for conflicts, since you have devs/users working on your website there might be conflicts or plugins that were not removed properly or causing some issues. https://theeventscalendar.com/knowledgebase/k/testing-for-conflicts/

    Moreover, we still recommend doing the testing on a staging site. One thing to note is that our support team cannot log into the dashboard of customer WordPress sites as per our Support Policy. https://theeventscalendar.com/knowledgebase/k/what-support-is-provided-for-license-holders/

    Is there a way I could look and see if the field exists and possibly recreate it in another way

    You could open your database and check the fields for this one. We can’t recommend another third-party plugin, checking the database → fields and table is the safest thing to do. You could probably ask your devs to check if you know someone who can.

    Let us know how would you like to proceed.

    Best,
    Abz

    Plugin Support Abz

    (@abzlevelup)

    Hey @stevebrett, 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.

    Cheers,
    Abz

    Thread Starter stevebrett

    (@stevebrett)

    Sorry not to get back to you sooner but wanted to thanks you for your help and let you know we did set up staging and figured this out.

    Appreciate your help

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WordPress database error Unknown column’ is closed to new replies.