Support » Plugin: Nested Pages » Database call error

  • When opening The Events Calendar events main view on the WordPress backend (/wp-admin/edit.php?post_type=tribe_events), we get the following error logged using the Query Monitor plugin:

    Caller: WP_Query-> get_posts()
    Component: Plugin: wp-nested-pages
    Query:

    SELECT SQL_CALC_FOUND_ROWS DISTINCT posts.ID
    FROM posts
    LEFT JOIN postmeta as tribe_event_end_date
    ON ( posts.ID = tribe_event_end_date.post_id
    AND tribe_event_end_date.meta_key = '_EventEndDateUTC' )
    WHERE 1=1
    AND posts.post_type = 'tribe_events'
    AND (posts.post_status = 'publish'
    OR posts.post_status = 'acf-disabled'
    OR posts.post_status = 'tribe-ea-success'
    OR posts.post_status = 'tribe-ea-failed'
    OR posts.post_status = 'tribe-ea-schedule'
    OR posts.post_status = 'tribe-ea-pending'
    OR posts.post_status = 'tribe-ea-draft'
    OR posts.post_status = 'future'
    OR posts.post_status = 'draft'
    OR posts.post_status = 'pending'
    OR posts.post_status = 'private')
    ORDER BY EventStartDate DESC, posts.post_date DESC
    LIMIT 0, 10 /* From [/wp-admin/edit.php?trashed=1&post_type=page&ids=15033&page=nestedpages] in [/wp-content/plugins/wp-nested-pages/app/Entities/Listing/ListingRepository.php:74] */

    Error Message: Unknown column ‘EventStartDate’ in ‘order clause’

    The events post type is not selected in Settings > Nested Pages > Post Types.

    Not sure what the issue is, but we thought there wouldn’t be any queries related to Nested Pages when going to that section of WordPress if the event post type isn’t selected. We’ve tried to reliably reproduce the issue, but it seems to be hit and miss. Thought we’d report it in case there’s a possible bug where Nested Pages is still querying the database for post types it’s not configured to manage.

    Thanks for any info you can pass along.

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Database call error’ is closed to new replies.