Unescaped Regex Errors

(@bclingan)
I’ve noticed some errors in my logs that appear to be from bots and perhaps regexp parsing issues in the plugin?

Example:
[29-Jul-2026 06:13:26 UTC] WordPress database error Got error 'parentheses not balanced' from regexp for query SELECT  DISTINCT wp_posts.*
					 FROM wp_posts  INNER JOIN wp_postmeta AS a ON ( a.post_id = wp_posts.ID ) LEFT JOIN wp_postmeta AS b ON ( (( b.post_id = a.post_id )) AND (( b.meta_key LIKE CONCAT( '\_', a.meta_key ) )) ) LEFT JOIN wp_posts AS c ON ( ( c.post_name = b.meta_value ) AND ( c.post_type = 'acf-field' ) AND (( c.post_content LIKE '%:"text"%' ) OR ( c.post_content LIKE '%:"textarea"%' ) OR ( c.post_content LIKE '%:"wysiwyg"%' )) ) 
					 WHERE 1=1  AND ( ( ( b.meta_id IS NOT NULL ) AND ( c.ID IS NOT NULL ) AND ( a.meta_value REGEXP '[[:<:]]Feeder[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]taps[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]for[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]non-motor[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]loads[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]](from[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]power[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]distribution[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]block[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]to[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]branch[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]circuit[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]protectiondevice[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]protecting[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]a[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]load)[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]not[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]over[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]7.5[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]m[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]](25[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]ft),[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]size[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]the[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]conductor[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]based[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]on[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]which[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]of[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]thefollowing?[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]](Select[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]all[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]that[[:>:]]' ) AND ( a.meta_value REGEXP '[[:<:]]apply)[[:>:]]' ) ) OR ( ( ( wp_posts.post_title REGEXP '[[:<:]]Feeder[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]Feeder[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]Feeder[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]taps[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]taps[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]taps[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]for[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]for[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]for[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]non-motor[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]non-motor[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]non-motor[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]loads[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]loads[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]loads[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]](from[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]](from[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]](from[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]power[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]power[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]power[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]distribution[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]distribution[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]distribution[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]block[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]block[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]block[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]to[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]to[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]to[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]branch[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]branch[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]branch[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]circuit[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]circuit[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]circuit[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]protectiondevice[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]protectiondevice[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]protectiondevice[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]protecting[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]protecting[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]protecting[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]a[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]a[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]a[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]load)[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]load)[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]load)[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]not[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]not[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]not[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]over[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]over[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]over[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]7.5[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]7.5[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]7.5[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]m[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]m[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]m[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]](25[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]](25[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]](25[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]ft),[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]ft),[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]ft),[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]size[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]size[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]size[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]the[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]the[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]the[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]conductor[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]conductor[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]conductor[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]based[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]based[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]based[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]on[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]on[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]on[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]which[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]which[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]which[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]of[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]of[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]of[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]thefollowing?[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]thefollowing?[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]thefollowing?[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]](Select[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]](Select[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]](Select[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]all[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]all[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]all[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]that[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]that[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]that[[:>:]]' ) ) AND ( ( wp_posts.post_title REGEXP '[[:<:]]apply)[[:>:]]' ) OR ( wp_posts.post_excerpt REGEXP '[[:<:]]apply)[[:>:]]' ) OR ( wp_posts.post_content REGEXP '[[:<:]]apply)[[:>:]]' ) ) ) )  AND ((wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'cold_case' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'community-events' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'deputies' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'event' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'help_us_find' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'job_posting' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'most_wanted' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'most_wanted_ocse' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'news_release' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'policy' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'traffic_tips' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'video' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
					 
					 ORDER BY (CASE WHEN wp_posts.post_title LIKE '%Feeder taps for non-motor loads (from power distribution block to branch circuit protectiondevice protecting a load) not over 7.5 m (25 ft), size the conductor based on which of thefollowing? (Select all that apply)%' THEN 1 WHEN wp_posts.post_title LIKE '%Feeder taps for non-motor loads (from power distribution block to branch circuit protectiondevice protecting a load) not over 7.5 m (25 ft), size the conductor based on which of thefollowing? (Select all that apply)%' THEN 2 WHEN wp_posts.post_excerpt LIKE '%Feeder taps for non-motor loads (from power distribution block to branch circuit protectiondevice protecting a load) not over 7.5 m (25 ft), size the conductor based on which of thefollowing? (Select all that apply)%' THEN 4 WHEN wp_posts.post_content LIKE '%Feeder taps for non-motor loads (from power distribution block to branch circuit protectiondevice protecting a load) not over 7.5 m (25 ft), size the conductor based on which of thefollowing? (Select all that apply)%' THEN 5 ELSE 6 END), wp_posts.post_date DESC
					  made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
This topic was modified 1 month, 3 weeks ago by bclingan.
You must be logged in to reply to this topic.