Tagged: 

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • April 8, 2025 at 4:36 pm #1481006
    welswebmaster

    Hello Enfold team,

    We are experiencing KILLED QUERY errors particularly for magazine element (see end of this post for sample error). When contacting WP Engine they also report that our autoload data is very high and point to Enfold. They provided a way to set autoload off but I’d need to know which Enfold autoload entries you’d suggest to change to no. Your help is appreciated.

    Error sample

    KILLED QUERY (22544 characters long generated in /nas/content/live/wels/wp-content/themes/enfold/config-templatebuilder/avia-shortcodes/magazine/magazine.php:1135): SELECT SQL_CALC_FOUND_ROWS wp_posts.ID#012#011#011#011#011#011 FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)#012#011#011#011#011#011 WHERE 1=1 AND ( #012 wp_term_relationships.term_taxonomy_id IN (250)#012) AND ((wp_posts.post_type = ‘alb_custom_layout’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘ame_ac_changeset’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘attachment’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘avia_framework_post’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘bible3’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘custom_css’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘customize_changeset’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘deleted_event’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘dev-daily’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘dev-military’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘dev-women’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘ecme-dev’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘ep-pointer’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR (wp_posts.post_author = 41 AND wp_posts.post_status = ‘private’) #012OR (wp_posts.post_author = 41 AND wp_posts.post_status = ‘sent’))) OR (wp_posts.post_type = ‘ep-synonym’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR (wp_posts.post_author = 41 AND wp_posts.post_status = ‘private’) #012OR (wp_posts.post_author = 41 AND wp_posts.post_status = ‘sent’))) OR (wp_posts.post_type = ‘family-devotion’ 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_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘faq’ 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_stat

    April 9, 2025 at 3:33 pm #1481081
    welswebmaster

    FYI the log is filling up for magazine and post slider. Here’s the post slider example:

    KILLED QUERY (16570 characters long generated in /nas/content/live/wels/wp-content/themes/enfold/config-templatebuilder/avia-shortcodes/postslider/postslider.php:1542): SELECT SQL_CALC_FOUND_ROWS wp_posts.ID#012#011#011#011#011#011 FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)#012#011#011#011#011#011 WHERE 1=1 AND ( #012 wp_term_relationships.term_taxonomy_id IN (94)#012) AND ((wp_posts.post_type = ‘alb_custom_layout’ 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’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘ame_ac_changeset’ 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’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘attachment’ 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’ #012OR wp_posts.post_status = ‘private’ #012OR wp_posts.post_status = ‘sent’)) OR (wp_posts.post_type = ‘avia_framework_post’ 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_p

    April 13, 2025 at 2:47 pm #1481270
    Mike

    Hi,
    I’m not familiar with KILLED QUERY errors, and I don’t see these on my test site, but in the interest of trying to help, I researched this and note that your errors above are pointing to “tribe” which is The Events Calendar plugin, so I assume that you are using the magazine element to display The Events Calendar posts.
    I find that:

    WordPress plugins like The Events Calendar or Search & Filter, KILLED QUERY errors often occur when querying large numbers of events or custom posts, leading to very long query strings. KILLED QUERY errors typically occur when a server kills a query due to it being too long or resource-intensive.

    So I don’t believe that this is due to the magazine or post slider elements, but the long query strings of the The Events Calendar.
    In this The Events Calendar thread: https://theeventscalendar.com/support/forums/topic/getting-killed-query-errors/
    The Events Calendar team recommends ignoring these warnings and specifically says this occurs on WP Engine, that you said you are using.
    I don’t use WP Engine nor have a lot of tribe posts, which is probably why I can’t reproduce, but since this is a known issue it makes sense.
    Hopefully this points you in the right direction.

    Best regards,
    Mike

    April 14, 2025 at 2:03 pm #1481306
    welswebmaster

    Hi Mike,

    Thanks for the info. What about:
    KILLED QUERY (22544 characters long generated in /nas/content/live/wels/wp-content/themes/enfold/config-templatebuilder/avia-shortcodes/magazine/magazine.php:1135):

    And the autoload options for Enfold.

    Thanks

    April 14, 2025 at 9:27 pm #1481333
    Mike

    Hi,
    This is a tribe entry, see the full error line:
    Screen Shot 2025 04 14 at 3.20.34 PM
    I would not recommend disabling any autoload options, see this thread from the Dev Team: https://kriesi.at/support/topic/thousands-of-rows-in-wp_options-with-autoload-yes/#post-966662

    Best regards,
    Mike

    April 15, 2025 at 3:21 pm #1481382
    welswebmaster
    This reply has been marked as private.
    April 15, 2025 at 11:00 pm #1481404
    Mike

    Hi,
    Please note that your screenshot is for Enfold settings, the error is from The Events Calendar as posted above this is a known The Events Calendar on WP Engine according the thread.

    Best regards,
    Mike

    April 16, 2025 at 12:59 pm #1481441
    welswebmaster

    Hi Mike,
    Two separate issues ;-) Sorry for confusing you.

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