Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #816431

    Hi,

    I have a conflict with the Easy Events Calendar. The issues is effecting some other plugins on the site, but the error log only shows the following message:

    The error log shows the following:

    [02-Jul-2017 19:27:30 UTC] WordPress database error Unknown column ‘post_parent’ in ‘group statement’ for query
    SELECT
    SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) 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_postmeta.meta_key = ‘_EventStartDate’
    AND
    ( mt1.meta_key = ‘_EventVenueID’ AND CAST(mt1.meta_value AS SIGNED) = ‘11497’ )
    ) AND wp_posts.post_type = ‘tribe_events’ AND ((wp_posts.post_status = ‘publish’)) ORDER BY wp_posts.post_date ASC
    ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 7
    made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, call_user_func, Tribe__Events__REST__V1__Endpoints__Archive_Event->get, Tribe__Events__REST__V1__Endpoints__Archive_Event->has_previous, tribe_get_events, Tribe__Events__Query::getEvents, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [02-Jul-2017 22:50:10 UTC] WordPress database error Unknown column ‘tribe_event_end_date.meta_value’ in ‘field list’ for query
    SELECT
    SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, MIN(tribe_event_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate, IF (wp_posts.post_type = ‘tribe_events’, tribe_event_postmeta.meta_value, wp_posts.post_date) AS EventStartDate FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) LEFT JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_postmeta on wp_posts.ID = tribe_event_postmeta.post_id AND tribe_event_postmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND (
    wp_term_relationships.term_taxonomy_id IN (624,625,628)
    AND
    tt1.term_taxonomy_id IN (624,625,628)
    AND
    tt2.term_taxonomy_id IN (624,625,628)
    ) AND (
    wp_postmeta.meta_key = ‘_EventStartDate’
    ) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘ks_giveaway’, ‘tribe_venue’, ‘tribe_events’, ‘tribe-ea-record’, ‘portfolio’, ‘avia_framework_post’, ‘event’, ‘bar’, ‘restaurants’, ‘saunas’, ‘post’, ‘page’) 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’) AND (tribe_event_postmeta.meta_value >= ‘2017-07-03 00:50:09’ OR (tribe_event_postmeta.meta_value <= ‘2017-07-03 00:50:09’ AND tribe_event_end_date.meta_value >= ‘2017-07-03 00:50:09’ )) ORDER BY EventStartDate ASC, wp_posts.post_date ASC
    ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 30
    made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__iCal->do_ical_template, Tribe__Events__iCal->generate_ical_feed, WP_Query->get_posts
    [03-Jul-2017 09:18:26 UTC] WordPress database error Unknown column ‘tribe_event_end_date.meta_value’ in ‘field list’ for query
    SELECT
    SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, MIN(tribe_event_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate, IF (wp_posts.post_type = ‘tribe_events’, tribe_event_postmeta.meta_value, wp_posts.post_date) AS EventStartDate FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) LEFT JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_postmeta on wp_posts.ID = tribe_event_postmeta.post_id AND tribe_event_postmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND (
    wp_term_relationships.term_taxonomy_id IN (624,625,628)
    AND
    tt1.term_taxonomy_id IN (624,625,628)
    AND
    tt2.term_taxonomy_id IN (624,625,628)
    ) AND (
    wp_postmeta.meta_key = ‘_EventStartDate’
    ) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘ks_giveaway’, ‘tribe_venue’, ‘tribe_events’, ‘tribe-ea-record’, ‘portfolio’, ‘avia_framework_post’, ‘event’, ‘bar’, ‘restaurants’, ‘saunas’, ‘post’, ‘page’) 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’) AND (tribe_event_postmeta.meta_value >= ‘2017-07-03 11:18:25’ OR (tribe_event_postmeta.meta_value <= ‘2017-07-03 11:18:25’ AND tribe_event_end_date.meta_value >= ‘2017-07-03 11:18:25’ )) ORDER BY EventStartDate ASC, wp_posts.post_date ASC
    ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 30
    made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__iCal->do_ical_template, Tribe__Events__iCal->generate_ical_feed, WP_Query->get_posts
    [03-Jul-2017 09:18:29 UTC] WordPress database error Unknown column ‘tribe_event_end_date.meta_value’ in ‘field list’ for query
    SELECT
    SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, MIN(tribe_event_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate, IF (wp_posts.post_type = ‘tribe_events’, tribe_event_postmeta.meta_value, wp_posts.post_date) AS EventStartDate FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) LEFT JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_postmeta on wp_posts.ID = tribe_event_postmeta.post_id AND tribe_event_postmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND (
    wp_term_relationships.term_taxonomy_id IN (624,625,628)
    AND
    tt1.term_taxonomy_id IN (624,625,628)
    AND
    tt2.term_taxonomy_id IN (624,625,628)
    ) AND (
    wp_postmeta.meta_key = ‘_EventStartDate’
    ) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘ks_giveaway’, ‘tribe_venue’, ‘tribe_events’, ‘tribe-ea-record’, ‘portfolio’, ‘avia_framework_post’, ‘event’, ‘bar’, ‘restaurants’, ‘saunas’, ‘post’, ‘page’) 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’) AND (tribe_event_postmeta.meta_value >= ‘2017-07-03 11:18:28’ OR (tribe_event_postmeta.meta_value <= ‘2017-07-03 11:18:28’ AND tribe_event_end_date.meta_value >= ‘2017-07-03 11:18:28’ )) ORDER BY EventStartDate ASC, wp_posts.post_date ASC
    ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 30
    made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__iCal->do_ical_template, Tribe__Events__iCal->generate_ical_feed, WP_Query->get_posts

    • This topic was modified 7 years, 5 months ago by roamingk.
    #816622

    Hey roamingk,

    Please send us a temporary admin login and login URL so that we can have a closer look. You can post the details in the Private Content section of your reply.

    Best regards,
    Rikard

    #817266

    Ok sent in private, thanks.

    #817583

    Hi,

    I got a 404 error on the login page, could you check the URL please?

    Best regards,
    Rikard

    #817779

    Sorry, It cut a little off the end!
    http://www.gaybarcelona4u.com/wp-admin/

    #818654

    Hi roamingk,

    Here is a post on the plugins support forum, there is not a solution there, but you might want to write to them with this issue.
    https://theeventscalendar.com/support/forums/topic/db-error-unknown-column-post_parent/

    Best regards,
    Victoria

Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.