jchawkins725
Forum Replies Created
Viewing 6 replies - 1 through 6 (of 6 total)
-
Hi Alin,
I converted my local site to use the default Twenty Twenty-Three theme and had every plugin deactivated except ACF, CPTUI, Search & Filter Pro, and WP Job Manager. I still encountered delays, so the Google Search plugin doesn’t seem to be impacting it at all.
After putting it in debug mode, I was able to capture some errors that led me to a possible solution. Here are the results:
[22-May-2023 14:40:40 UTC] PHP Warning: mysqli_query(): (08S01/1053): Server shutdown in progress in /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wpdb.php on line 2431 [22-May-2023 14:40:40 UTC] PHP Warning: mysqli_query(): (08S01/1053): Server shutdown in progress in /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wpdb.php on line 2431 [22-May-2023 14:40:40 UTC] PHP Stack trace: [22-May-2023 14:40:40 UTC] PHP Stack trace: [22-May-2023 14:40:40 UTC] PHP 1. {main}() /Users/jhawkins/Local Sites/antioch/app/public/index.php:0 [22-May-2023 14:40:40 UTC] PHP 1. {main}() /Users/jhawkins/Local Sites/antioch/app/public/index.php:0 [22-May-2023 14:40:40 UTC] PHP 2. require() /Users/jhawkins/Local Sites/antioch/app/public/index.php:17 [22-May-2023 14:40:40 UTC] PHP 3. wp($query_vars = *uninitialized*) /Users/jhawkins/Local Sites/antioch/app/public/wp-blog-header.php:16 [22-May-2023 14:40:40 UTC] PHP 4. WP->main($query_args = '') /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/functions.php:1334 [22-May-2023 14:40:40 UTC] PHP 5. WP->query_posts() /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wp.php:783 [22-May-2023 14:40:40 UTC] PHP 6. WP_Query->query($query = ['s' => 'academics']) /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wp.php:663 [22-May-2023 14:40:40 UTC] PHP 7. WP_Query->get_posts() /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wp-query.php:3787 [22-May-2023 14:40:40 UTC] PHP 8. wpdb->get_col($query = '\n\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS wp_posts.ID\n\t\t\t\t\tFROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = \'_filled\' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id AND mt3.meta_key = \'_job_expires\' )\n\t\t\t\t\tWHERE 1=1 AND (((wp_posts.post_title LIKE \'{d7cf9e3ca1d63008bc186ba83dd518781ad808e8d7377c074c01bfcf0f9abd7e}academics{d7cf9e'..., $x = *uninitialized*) /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wp-query.php:3301 [22-May-2023 14:40:40 UTC] PHP 9. wpdb->query($query = '\n\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS wp_posts.ID\n\t\t\t\t\tFROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = \'_filled\' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id AND mt3.meta_key = \'_job_expires\' )\n\t\t\t\t\tWHERE 1=1 AND (((wp_posts.post_title LIKE \'{d7cf9e3ca1d63008bc186ba83dd518781ad808e8d7377c074c01bfcf0f9abd7e}academics{d7cf9e'...) /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wpdb.php:3060 [22-May-2023 14:40:40 UTC] PHP 10. wpdb->_do_query($query = '\n\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS wp_posts.ID\n\t\t\t\t\tFROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = \'_filled\' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id AND mt3.meta_key = \'_job_expires\' )\n\t\t\t\t\tWHERE 1=1 AND (((wp_posts.post_title LIKE \'%academics%\') OR (wp_posts.post_excerpt LIKE \'%academics%\') OR (wp_posts.post_cont'...) /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wpdb.php:2320 [22-May-2023 14:40:40 UTC] PHP 11. mysqli_query($link = class mysqli { public $affected_rows = -1; public $client_info = 'mysqlnd 7.4.30'; public $client_version = 70430; public $connect_errno = 0; public $connect_error = NULL; public $errno = 1053; public $error = 'Server shutdown in progress'; public $error_list = [0 => [...]]; public $field_count = 1; public $host_info = 'Localhost via UNIX socket'; public $info = NULL; public $insert_id = 0; public $server_info = '8.0.16'; public $server_version = 80016; public $sqlstate = '08S01'; public $protocol_version = 10; public $thread_id = 71; public $warning_count = 0 }, $query = '\n\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS wp_posts.ID\n\t\t\t\t\tFROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = \'_filled\' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id AND mt3.meta_key = \'_job_expires\' )\n\t\t\t\t\tWHERE 1=1 AND (((wp_posts.post_title LIKE \'%academics%\') OR (wp_posts.post_excerpt LIKE \'%academics%\') OR (wp_posts.post_cont'...) /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wpdb.php:2431 [22-May-2023 14:40:40 UTC] PHP 2. require() /Users/jhawkins/Local Sites/antioch/app/public/index.php:17 [22-May-2023 14:40:40 UTC] PHP 3. wp($query_vars = *uninitialized*) /Users/jhawkins/Local Sites/antioch/app/public/wp-blog-header.php:16 [22-May-2023 14:40:40 UTC] PHP 4. WP->main($query_args = '') /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/functions.php:1334 [22-May-2023 14:40:40 UTC] PHP 5. WP->query_posts() /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wp.php:783 [22-May-2023 14:40:40 UTC] PHP 6. WP_Query->query($query = ['s' => 'faculty']) /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wp.php:663 [22-May-2023 14:40:40 UTC] PHP 7. WP_Query->get_posts() /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wp-query.php:3787 [22-May-2023 14:40:40 UTC] PHP 8. wpdb->get_col($query = '\n\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS wp_posts.ID\n\t\t\t\t\tFROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = \'_filled\' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id AND mt3.meta_key = \'_job_expires\' )\n\t\t\t\t\tWHERE 1=1 AND (((wp_posts.post_title LIKE \'{2d2232bdf376eae09ab7ea9747f0a8f5a198cfcda5287aac02ee4337bcee07c4}faculty{2d2232bd'..., $x = *uninitialized*) /Users/jhawkins/Local Sites/antioch/app/public/wp-includes/class-wp-query.php:3301 [22-May-2023 14:40:40 UTC] WordPress database error Server shutdown in progress for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = '_filled' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id AND mt3.meta_key = '_job_expires' ) WHERE 1=1 AND (((wp_posts.post_title LIKE '%academics%') OR (wp_posts.post_excerpt LIKE '%academics%') OR (wp_posts.post_content LIKE '%academics%'))) AND ( ( ( wp_postmeta.meta_key = '_filled' AND wp_postmeta.meta_value = '0' ) OR mt1.post_id IS NULL ) AND ( ( mt2.meta_key = '_job_expires' AND CAST(mt2.meta_value AS DATE) >= '2023-05-22' ) OR mt3.post_id IS NULL ) ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'private')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'private')) OR (wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'private')) OR (wp_posts.post_type = 'faculty' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'private')) OR (wp_posts.post_type = 'resource' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'private')) OR (wp_posts.post_type = 'grants-scholarships' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'private')) OR (wp_posts.post_type = 'academic' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'private'))) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title LIKE '%academics%' DESC, wp_posts.post_date DESC LIMIT 0, 3 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_postsAfter seeing the ‘expired’ status and ‘_filled’ status show up in the logs, I discovered that unchecking these boxes fixed the issue. We had them all checked before.
We definitely would like the filled and expired positions to not display. As of now, it seems to fix the search issue across our site, but I would appreciate any help you could provide on a possible plugin fix or something we need to do on our site to use these settings without issue.
Thank you for your help.
Viewing 6 replies - 1 through 6 (of 6 total)