- Posts
Hi BoldGrid. I’m with Dreamhost investigating a connectivity issue and the Dreamhost tech support tells me:
The logs indicate that the plugin Boldgrid Inspirations Purchase for
Publish is generating repeated WordPress database errors due to an
invalid regular expression. Specifically, the error message states:
“WordPress database error: The regular expression contains an unclosed
bracket expression.” This issue stems from a malformed SQL REGEXP query
within the plugin’s logic, likely triggered by code running in the admin
toolbar or associated background processes.Can you please investigate and correct? Feel free to reach out to Dreamhost directly if you need to see the actual logs of the error being thrown.
Hello Andrew,
Thank you for reaching out to our support team.
Could you share the full stack trace or the complete error message from the file output? Also, please let me know which version of WordPress you are using, along with your PHP version.
Thanks,
ElanaHi Elana. You’ll have to reach out to Dreamhost for the stack traces showing the error. You can reference their support ticket 252996629 for more information. I copied Dreamhost’s communication below.
I’m on WordPress 6.8.1 and PHP 8.2.26
—
Re: [ajpierce 252996629] google bot can’t connect
DreamHost Customer Support Team <support@dreamhost.com> 9 June 2025 at 13:28
Hello Andrew,Thank you for contacting Dream Host support, my name is Kym. I’d be glad
to help!Following up on the previous update, I’ve reviewed the server logs for
niade.com and identified a few important details that could be
contributing to the issue with Google accessing your robots.txt file.The logs indicate that the plugin Boldgrid Inspirations Purchase for
Publish is generating repeated WordPress database errors due to an
invalid regular expression. Specifically, the error message states:
“WordPress database error: The regular expression contains an unclosed
bracket expression.” This issue stems from a malformed SQL REGEXP query
within the plugin’s logic, likely triggered by code running in the admin
toolbar or associated background processes.To help rule this out, we recommend temporarily disabling the Boldgrid
plugin and then re-testing access to robots.txt either through Google
Search Console or directly in a browser. Additionally, if you are using
any custom .htaccess rules that could affect robots.txt, please review
them or feel free to share them with us so we can assist.Hello Andrew,
Thank you for reaching out to our support team.
Could you please try disabling the Inspirations plugin, run your test, and then re-enable the plugin to see if that resolves the issue?
Thanks,
ElanaMySQL’s parser is confused by bracket ambiguity. The regex uses [\\[] and [\\]] as character classes to match literal brackets, but MySQL can’t distinguish these bracket-matching constructs from the middle character class [‘\\”, ]. The parser gets lost trying to figure out which brackets are character class delimiters versus which are literal characters to match, resulting in “unclosed bracket expression” errors.
Problematic regex: [\\[][^\\]]+[‘\\”, ]31[^0-9]+.*[\\]]
Suggested MySQL fix: \\[\\\\\\[\\][^\\\\]+[‘\\”, ]31[^0-9]+.*\\[\\\\\\]Dreamhost error logs:
Thanks again for sharing the update. I checked the error.log for
niade.com and do see a single entry related to the boldgrid mysql query
error:[Tue Jun 17 05:24:48 2025] [niade.com] [warn] [client
46.208.151.117:60981] [pid 946339] fcgid_bucket.c(153): mod_fcgid:
stderr: WordPress database error The regular expression contains an
unclosed bracket expression. for query
[Tue Jun 17 05:24:48 2025] [niade.com] [warn] [client
46.208.151.117:60981] [pid 946339] fcgid_bucket.c(153): mod_fcgid:
stderr: \t\t\tSELECTID
[Tue Jun 17 05:24:48 2025] [niade.com] [warn] [client
46.208.151.117:60981] [pid 946339] fcgid_bucket.c(153): mod_fcgid:
stderr: \t\t\tFROM wp_vtkvbc_posts
[Tue Jun 17 05:24:48 2025] [niade.com] [warn] [client
46.208.151.117:60981] [pid 946339] fcgid_bucket.c(153): mod_fcgid:
stderr: \t\t\tWHERE\tpost_statusIN ( “draft”, “publish” ) AND
[Tue Jun 17 05:24:48 2025] [niade.com] [warn] [client
46.208.151.117:60981] [pid 946339] fcgid_bucket.c(153): mod_fcgid:
stderr: \t\t\t\t\tpost_typeIN (“page”,”post”) AND
[Tue Jun 17 05:24:48 2025] [niade.com] [warn] [client
46.208.151.117:60981] [pid 946339] fcgid_bucket.c(153): mod_fcgid:
stderr: \t\t\t\t\tpost_contentREGEXP “[\\[][^\\]]+[‘\\”,
]31[^0-9]+.*[\\]]”
[Tue Jun 17 05:24:48 2025] [niade.com] [warn] [client
46.208.151.117:60981] [pid 946339] fcgid_bucket.c(153): mod_fcgid:
stderr: \t\t made by require_once(‘wp-admin/admin-header.php’),
do_action(‘in_admin_header’), WP_Hook->do_action, WP_Hook->apply_filters,
wp_admin_bar_render, do_action_ref_array(‘admin_bar_menu’),
WP_Hook->do_action, WP_Hook->apply_filters,
Boldgrid_Inspirations_Purchase_For_Publish->toolbar_link_to_mypage,
Boldgrid_Inspirations_Purchase_For_Publish->get_total_cost_to_purchase_for_publishing,
Boldgrid_Inspirations_Purchase_For_Publish->create_array_assets_needing_purchase,
Boldgrid_Inspirations_Purchase_For_Publish->asset_needs_purchase[Wed Jun 18 03:08:26 2025] [niade.com] [warn] [client
46.208.151.117:54289] [pid 792985] fcgid_bucket.c(153): mod_fcgid:
stderr: WordPress database error The regular expression contains an
unclosed bracket expression. for query
[Wed Jun 18 03:08:26 2025] [niade.com] [warn] [client
46.208.151.117:54289] [pid 792985] fcgid_bucket.c(153): mod_fcgid:
stderr: \t\t\tSELECTID
[Wed Jun 18 03:08:26 2025] [niade.com] [warn] [client
46.208.151.117:54289] [pid 792985] fcgid_bucket.c(153): mod_fcgid:
stderr: \t\t\tFROM wp_vtkvbc_posts
[Wed Jun 18 03:08:26 2025] [niade.com] [warn] [client
46.208.151.117:54289] [pid 792985] fcgid_bucket.c(153): mod_fcgid:
stderr: \t\t\tWHERE\tpost_statusIN ( “draft”, “publish” ) AND
[Wed Jun 18 03:08:26 2025] [niade.com] [warn] [client
46.208.151.117:54289] [pid 792985] fcgid_bucket.c(153): mod_fcgid:
stderr: \t\t\t\t\tpost_typeIN (“page”,”post”) AND
[Wed Jun 18 03:08:26 2025] [niade.com] [warn] [client
46.208.151.117:54289] [pid 792985] fcgid_bucket.c(153): mod_fcgid:
stderr: \t\t\t\t\tpost_contentREGEXP “[\\[][^\\]]+[‘\\”,
]31[^0-9]+.*[\\]]”
[Wed Jun 18 03:08:26 2025] [niade.com] [warn] [client
46.208.151.117:54289] [pid 792985] fcgid_bucket.c(153): mod_fcgid:
stderr: \t\t made by require_once(‘wp-admin/admin-header.php’),
do_action(‘in_admin_header’), WP_Hook->do_action, WP_Hook->apply_filters,
wp_admin_bar_render, do_action_ref_array(‘admin_bar_menu’),
WP_Hook->do_action, WP_Hook->apply_filters,
Boldgrid_Inspirations_Purchase_For_Publish->toolbar_link_to_mypage,
Boldgrid_Inspirations_Purchase_For_Publish->get_total_cost_to_purchase_for_publishing,
Boldgrid_Inspirations_Purchase_For_Publish->create_array_assets_needing_purchase,
Boldgrid_Inspirations_Purchase_For_Publish->asset_needs_purchaseThe most recent appears to be an hour ago. Did Boldgrid support provide
details on what they fixed? From what I gathered in the entry above, the
error is specifically due to the following regular expression:REGEXP “[\\[][^\\]]+[‘\\”, ]31[^0-9]+.*[\\]]”
It contains an unescaped or mismatched bracket expression: [\\[] and
[\\]] are supposed to match literal square brackets, but it gets confused
with other character classes like [‘\\”, ].Hello Andrew,
Thank you for reaching out to our support team.
I created a GitHub / bug ticket for us to look into this further you can monitor the GitHub issue here.
Thanks
Elana.
- The topic ‘error thrown by BoldGrid plug in’ is closed to new replies.
