Tagged: 

Viewing 12 posts - 1 through 12 (of 12 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.

    April 19, 2025 at 1:39 pm #1481638
    Mike

    Hi,
    Sorry, it is confusing when a thread has multiple issues, typically it is best to have a single issue per thread.
    Nonetheless, please explain further so we can try to help with your second issue.

    Best regards,
    Mike

    April 22, 2025 at 4:25 pm #1481842
    welswebmaster

    Thanks, Mike. I searched more on your support and found this helpful. “Enfold 4.7.4 has an option to disable the unique timestamp generation for the css and JavaScript merged files and so there will not be as many entries it the wp_options table.”

    April 22, 2025 at 6:26 pm #1481859
    welswebmaster
    This reply has been marked as private.
    April 23, 2025 at 2:46 pm #1481957
    welswebmaster

    SOLUTION: I was able to get rid of the KILLED QUERY errors for using Enfold’s magazine and post slider elements for displaying calendar posts by instead using the Avia Layout Builder (ALB) tab entitled: “Plugin Additions” – UPCOMING EVENTS element. Using that removed all errors from the log.

    As for the autoload issue: I’ve installed plugin https://wordpress.org/plugins/aaa-option-optimizer/ to see what is causing the slow performance.

    Close this ticket please.

  • Author
    Posts
Viewing 12 posts - 1 through 12 (of 12 total)
  • The topic ‘KILL QUERY and Enfold Autoload data very high’ is closed to new replies.