Search throws PHP error

Wordpress 5.8.2, PHP 7.4.27, Ivory Search 5.2.

When we do a search on the homepage of our site, no results are returned.

This was working (at some point in the past, but we just noticed it is now broken and not working today.).

When I look at the PHP error logs, this is what is present:

[23-Dec-2021 00:23:47 UTC] **************************** Trace start ****************************
  [0]file: Z:\breckproducts.com\www\wp-content\plugins\add-search-to-menu-premium\includes\class-is-debug.php; line: 98; function: debug_trace; class: IS_Debug
  [1]function: process_error_backtrace; class: IS_Debug
  [2]file: Z:\breckproducts.com\www\wp-includes\wp-db.php; line: 2056; function: mysqli_query
  [3]file: ZE:\breckproducts.com\www\wp-includes\wp-db.php; line: 1945; function: _do_query; class: wpdb
  [4]file: Z:\breckproducts.com\www\wp-includes\wp-db.php; line: 2657; function: query; class: wpdb
  [5]file: Z:\breckproducts.com\www\wp-includes\class-wp-query.php; line: 3024; function: get_col; class: wpdb
  [6]file: Z:\breckproducts.com\www\wp-includes\class-wp-query.php; line: 3465; function: get_posts; class: WP_Query
  [7]file: Z:\breckproducts.com\www\wp-includes\class-wp.php; line: 629; function: query; class: WP_Query
  [8]file: Z:\breckproducts.com\www\wp-includes\class-wp.php; line: 752; function: query_posts; class: WP
  [9]file: Z:\breckproducts.com\www\wp-includes\functions.php; line: 1291; function: main; class: WP
  [10]file: Z:\breckproducts.com\www\wp-blog-header.php; line: 16; function: wp
  [11]file: Z:\breckproducts.com\www\index.php; line: 17; function: require
[23-Dec-2021 00:23:47 UTC] WordPress database error Illegal argument to a regular expression. for query SELECT SQL_CALC_FOUND_ROWS DISTINCT bp_posts.ID FROM bp_posts  LEFT JOIN bp_postmeta pm ON (bp_posts.ID = pm.post_id)  WHERE 1=1  AND (  ((bp_posts.post_title REGEXP '([[:<:]])paper|paper([[:>:]])') OR (bp_posts.post_content REGEXP '([[:<:]])paper|paper([[:>:]])') OR (bp_posts.post_excerpt REGEXP '([[:<:]])paper|paper([[:>:]])') OR (pm.meta_key = '_sku' AND pm.meta_value REGEXP '([[:<:]])paper|paper([[:>:]])'))) AND bp_posts.post_type IN ('post', 'page', 'attachment', 'e-landing-page', 'viwec_template', 'product', 'product_variation') AND ((bp_posts.post_status = 'publish' OR bp_posts.post_status = 'inherit'))  ORDER BY bp_posts.post_title LIKE '%paper%' DESC, bp_posts.post_date DESC LIMIT 0, 10 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

The page I need help with: [log in to see the link]

Viewing 10 replies - 1 through 10 (of 10 total)

Plugin Author

(@vinod-dalvi)

Sorry to hear about the problem you are having.

I have tested it on my test site and it’s working fine for me using the latest version of the plugin.

Could you please tell me which version of MySQL you are using?

Best regards,

Thread Starter

RollingRocker

(@rollingrocker)

8.0.25-commercial – MySQL Enterprise Server – Commercial

Plugin Author

(@vinod-dalvi)

Thank you for the information.

I am troubleshooting the issue.

Plugin Author

(@vinod-dalvi)

https://drive.google.com/file/d/17D8ApNXDK9NWtlPYrS7XK6u8fG039wks/view?usp=sharing

Could you please try using the below latest unreleased plugin version that contains a fix for the issue?

Thread Starter

RollingRocker

(@rollingrocker)

@vinod-dalvi this works! We have the PREMIUM plugin, can you please update the premium one and advise how to download that one. I have the site on the free one now which fixes the issue but I would like to switch to the premium one.
THANK YOU VERY MUCH!

Plugin Author

(@vinod-dalvi)

I am going to release a plugin update shortly.

In the meantime could you please contact us using this contact form https://ivorysearch.com/contact/ to get a premium plugin?

lavenderstreak

(@lavenderstreak)

Hi – this didn’t resolve it for me. I installed the update above and then there was a new update to 5.3 (which is higher than the one you provided). I’m still getting the errors. The errors changed a little bit after 16:17 when I installed the update.

[03-Jan-2022 16:11:54 UTC] **************************** Trace start ****************************
  [0]file: /home/seatt112/public_html/wp-content/plugins/add-search-to-menu/includes/class-is-debug.php; line: 98; function: debug_trace; class: IS_Debug
  [1]file: /home/seatt112/public_html/wp-content/plugins/code-snippets/php/snippet-ops.php(469) : eval()'d code; line: 27; function: process_error_backtrace; class: IS_Debug
  [2]file: /home/seatt112/public_html/wp-includes/shortcodes.php; line: 356; function: {closure}
  [3]function: do_shortcode_tag
  [4]file: /home/seatt112/public_html/wp-includes/shortcodes.php; line: 228; function: preg_replace_callback
  [5]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 303; function: do_shortcode
  [6]file: /home/seatt112/public_html/wp-includes/plugin.php; line: 189; function: apply_filters; class: WP_Hook
  [7]file: /home/seatt112/public_html/wp-includes/feed.php; line: 194; function: apply_filters
  [8]file: /home/seatt112/public_html/wp-includes/feed-rss2.php; line: 104; function: get_the_content_feed
  [9]file: /home/seatt112/public_html/wp-includes/template.php; line: 770; function: require_once
  [10]file: /home/seatt112/public_html/wp-includes/functions.php; line: 1623; function: load_template
  [11]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 305; function: do_feed_rss2
  [12]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 327; function: apply_filters; class: WP_Hook
  [13]file: /home/seatt112/public_html/wp-includes/plugin.php; line: 470; function: do_action; class: WP_Hook
  [14]file: /home/seatt112/public_html/wp-includes/functions.php; line: 1585; function: do_action
  [15]file: /home/seatt112/public_html/wp-includes/template-loader.php; line: 48; function: do_feed
  [16]file: /home/seatt112/public_html/wp-blog-header.php; line: 19; function: require_once
  [17]file: /home/seatt112/public_html/index.php; line: 17; function: require
[03-Jan-2022 16:17:51 UTC] [warning]: 'Undefined index: action' file: /home/seatt112/public_html/wp-content/plugins/revisionary/rvy_init.php, line: 203
[03-Jan-2022 16:17:51 UTC] **************************** Trace start ****************************
  [0]file: /home/seatt112/public_html/wp-content/plugins/add-search-to-menu/includes/class-is-debug.php; line: 98; function: debug_trace; class: IS_Debug
  [1]file: /home/seatt112/public_html/wp-content/plugins/revisionary/rvy_init.php; line: 203; function: process_error_backtrace; class: IS_Debug
  [2]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 303; function: rvy_ajax_handler
  [3]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 327; function: apply_filters; class: WP_Hook
  [4]file: /home/seatt112/public_html/wp-includes/plugin.php; line: 470; function: do_action; class: WP_Hook
  [5]file: /home/seatt112/public_html/wp-settings.php; line: 600; function: do_action
  [6]file: /home/seatt112/public_html/wp-config.php; line: 103; function: require_once
  [7]file: /home/seatt112/public_html/wp-load.php; line: 50; function: require_once
  [8]file: /home/seatt112/public_html/wp-blog-header.php; line: 13; function: require_once
  [9]file: /home/seatt112/public_html/index.php; line: 17; function: require
[03-Jan-2022 16:18:32 UTC] [warning]: 'Undefined property: WP_Post_Type::$taxonomy' file: /home/seatt112/public_html/wp-content/plugins/seriously-simple-podcasting/php/classes/controllers/class-frontend-controller.php, line: 117
[03-Jan-2022 16:18:32 UTC] **************************** Trace start ****************************
  [0]file: /home/seatt112/public_html/wp-content/plugins/add-search-to-menu/includes/class-is-debug.php; line: 98; function: debug_trace; class: IS_Debug
  [1]file: /home/seatt112/public_html/wp-content/plugins/seriously-simple-podcasting/php/classes/controllers/class-frontend-controller.php; line: 117; function: process_error_backtrace; class: IS_Debug
  [2]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 303; function: fix_template_hierarchy; class: SeriouslySimplePodcasting\Controllers\Frontend_Controller
  [3]file: /home/seatt112/public_html/wp-includes/plugin.php; line: 189; function: apply_filters; class: WP_Hook
  [4]file: /home/seatt112/public_html/wp-includes/template.php; line: 62; function: apply_filters
  [5]file: /home/seatt112/public_html/wp-includes/template.php; line: 161; function: get_query_template
  [6]file: /home/seatt112/public_html/wp-includes/template.php; line: 187; function: get_archive_template
  [7]file: /home/seatt112/public_html/wp-includes/template-loader.php; line: 81; function: get_post_type_archive_template
  [8]file: /home/seatt112/public_html/wp-blog-header.php; line: 19; function: require_once
  [9]file: /home/seatt112/public_html/index.php; line: 17; function: require

lavenderstreak

(@lavenderstreak)

This continues to be a problem. My log file has double in size to over 200MB in 1 day. Here are the repeated errors. I have the latest version of Ivory Search installed (5.3). Since the problem seemed to be stemming from Ivory search, I deactivated it, but the errors continued. I deleted it and the errors have thankfully stopped. I am going to be installing a different search plugin now.

[04-Jan-2022 17:45:34 UTC] **************************** Trace start ****************************
  [0]file: /home/seatt112/public_html/wp-content/plugins/add-search-to-menu/includes/class-is-debug.php; line: 98; function: debug_trace; class: IS_Debug
  [1]file: /home/seatt112/public_html/wp-includes/class-wp-list-util.php; line: 164; function: process_error_backtrace; class: IS_Debug
  [2]file: /home/seatt112/public_html/wp-includes/functions.php; line: 5024; function: pluck; class: WP_List_Util
  [3]file: /home/seatt112/public_html/wp-content/plugins/add-to-cart-direct-checkout-for-woocommerce-pro/public/class-pi-dcw-pro-public.php; line: 212; function: wp_list_pluck
  [4]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 303; function: enqueue_scripts; class: Pi_Dcw_Pro_Public
  [5]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 327; function: apply_filters; class: WP_Hook
  [6]file: /home/seatt112/public_html/wp-includes/plugin.php; line: 470; function: do_action; class: WP_Hook
  [7]file: /home/seatt112/public_html/wp-includes/script-loader.php; line: 2083; function: do_action
  [8]file: /home/seatt112/public_html/wp-content/plugins/give/src/DonorDashboards/RequestHandler.php; line: 98; function: wp_enqueue_scripts
  [9]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 303; function: handleEnqueueScripts; class: Give\DonorDashboards\RequestHandler
  [10]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 327; function: apply_filters; class: WP_Hook
  [11]file: /home/seatt112/public_html/wp-includes/plugin.php; line: 470; function: do_action; class: WP_Hook
  [12]file: /home/seatt112/public_html/wp-content/plugins/give/src/Views/IframeContentView.php; line: 114; function: do_action
  [13]file: /home/seatt112/public_html/wp-content/plugins/give/src/DonorDashboards/resources/views/donordashboard.php; line: 15; function: render; class: Give\Views\IframeContentView
  [14]file: /home/seatt112/public_html/wp-content/plugins/give/src/DonorDashboards/App.php; line: 103; function: require
  [15]file: /home/seatt112/public_html/wp-content/plugins/give/src/DonorDashboards/RequestHandler.php; line: 58; function: getIframeContent; class: Give\DonorDashboards\App
  [16]function: parseRequest; class: Give\DonorDashboards\RequestHandler
  [17]file: /home/seatt112/public_html/wp-content/plugins/give/src/Helpers/Hooks.php; line: 42; function: call_user_func_array
  [18]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 303; function: Give\Helpers\{closure}; class: Give\Helpers\Hooks
  [19]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 327; function: apply_filters; class: WP_Hook
  [20]file: /home/seatt112/public_html/wp-includes/plugin.php; line: 518; function: do_action; class: WP_Hook
  [21]file: /home/seatt112/public_html/wp-includes/class-wp.php; line: 388; function: do_action_ref_array
  [22]file: /home/seatt112/public_html/wp-includes/class-wp.php; line: 750; function: parse_request; class: WP
  [23]file: /home/seatt112/public_html/wp-includes/functions.php; line: 1291; function: main; class: WP
  [24]file: /home/seatt112/public_html/wp-blog-header.php; line: 16; function: wp
  [25]file: /home/seatt112/public_html/index.php; line: 17; function: require
[04-Jan-2022 17:46:54 UTC] [warning]: 'Undefined property: WP_Post_Type::$taxonomy' file: /home/seatt112/public_html/wp-content/plugins/seriously-simple-podcasting/php/classes/controllers/class-frontend-controller.php, line: 117
[04-Jan-2022 17:46:54 UTC] **************************** Trace start ****************************
  [0]file: /home/seatt112/public_html/wp-content/plugins/add-search-to-menu/includes/class-is-debug.php; line: 98; function: debug_trace; class: IS_Debug
  [1]file: /home/seatt112/public_html/wp-content/plugins/seriously-simple-podcasting/php/classes/controllers/class-frontend-controller.php; line: 117; function: process_error_backtrace; class: IS_Debug
  [2]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 303; function: fix_template_hierarchy; class: SeriouslySimplePodcasting\Controllers\Frontend_Controller
  [3]file: /home/seatt112/public_html/wp-includes/plugin.php; line: 189; function: apply_filters; class: WP_Hook
  [4]file: /home/seatt112/public_html/wp-includes/template.php; line: 62; function: apply_filters
  [5]file: /home/seatt112/public_html/wp-includes/template.php; line: 161; function: get_query_template
  [6]file: /home/seatt112/public_html/wp-includes/template.php; line: 187; function: get_archive_template
  [7]file: /home/seatt112/public_html/wp-includes/template-loader.php; line: 81; function: get_post_type_archive_template
  [8]file: /home/seatt112/public_html/wp-blog-header.php; line: 19; function: require_once
  [9]file: /home/seatt112/public_html/index.php; line: 17; function: require
[04-Jan-2022 17:47:30 UTC] [warning]: 'Undefined index: action' file: /home/seatt112/public_html/wp-content/plugins/revisionary/rvy_init.php, line: 203
[04-Jan-2022 17:47:30 UTC] **************************** Trace start ****************************
  [0]file: /home/seatt112/public_html/wp-content/plugins/add-search-to-menu/includes/class-is-debug.php; line: 98; function: debug_trace; class: IS_Debug
  [1]file: /home/seatt112/public_html/wp-content/plugins/revisionary/rvy_init.php; line: 203; function: process_error_backtrace; class: IS_Debug
  [2]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 303; function: rvy_ajax_handler
  [3]file: /home/seatt112/public_html/wp-includes/class-wp-hook.php; line: 327; function: apply_filters; class: WP_Hook
  [4]file: /home/seatt112/public_html/wp-includes/plugin.php; line: 470; function: do_action; class: WP_Hook
  [5]file: /home/seatt112/public_html/wp-settings.php; line: 600; function: do_action
  [6]file: /home/seatt112/public_html/wp-config.php; line: 103; function: require_once
  [7]file: /home/seatt112/public_html/wp-load.php; line: 50; function: require_once
  [8]file: /home/seatt112/public_html/wp-blog-header.php; line: 13; function: require_once
  [9]file: /home/seatt112/public_html/index.php; line: 17; function: require

Plugin Author

(@vinod-dalvi)

@lavenderstreak I am working on the plugin update to resolve this debug log issue that I will release today.

Thank you for your patience and cooperation.

Plugin Author

(@vinod-dalvi)