error establishing a database connection

Hi there @gesundegeschenke ????!

Thank you for reaching out to MailPoet Support!

since installing it I have had constant problems with the connection to the database.

I have had a look at the system report that you shared and I see that the PHP and DB settings are a bit on the lower end:

WP info: WP_MEMORY_LIMIT: 40M - WP_MAX_MEMORY_LIMIT: 512M - WP_DEBUG: - WordPress language: de_DEPHP info: PHP max_execution_time: 140 - PHP memory_limit: 512M - PHP upload_max_filesize: 150M - PHP post_max_size: 150

Can you work with your hosting company to increase those settings?

Once you have done it, if you still see the same issue, please share the complete error that you see with us.

Cheers!

Hello,

thanks for the reply. I still have the following message from the host:

Cmd: sleep

“Your installation is making too many database connections and is not closing correctly.”

Hi @gesundegeschenke,

Do you still see this message after increasing the PHP settings? Could you share the updated system info so we can take a look?

The host repeats that it is not due to capacity, but rather due to incorrect plugin settings. Database connections are created and then not closed correctly. Is this perhaps due to the settings in mailpoet or my configuration?

I found this message in the Mailpoet log:

[2024-08-11T03:51:15.376469+00:00] mss.ERROR: key-validation.failed {“http_code”:403,”home_url”:”https://www.gesunde-geschenke.com”,”key_type”:”premiu…

In addition, Mailpoet causes a conflict in Woocommerce when editing products: no product categories and tags are displayed in the sidebar.

I personalized the editor with the following code:

// Disable new WooCommerce product template (from Version 7.7.0)
function bp_reset_product_template($post_type_args) {
if (array_key_exists('template', $post_type_args)) {
unset($post_type_args['template']);
}
return $post_type_args;
}
add_filter('woocommerce_register_post_type_product', 'bp_reset_product_template');

// Enable Gutenberg editor for WooCommerce
function bp_activate_gutenberg_product($can_edit, $post_type) {
if ($post_type == 'product') {
$can_edit = true;
}
return $can_edit;
}
add_filter('use_block_editor_for_post_type', 'bp_activate_gutenberg_product', 10, 2);

// Enable taxonomy fields for woocommerce with gutenberg on
function bp_enable_taxonomy_rest($args) {
$args['show_in_rest'] = true;
return $args;
}
add_filter('woocommerce_taxonomy_args_product_cat', 'bp_enable_taxonomy_rest');
add_filter('woocommerce_taxonomy_args_product_tag', 'bp_enable_taxonomy_rest');

can you adapt this code so that it works with mailpoet?

Hi there,

Thanks for getting back to us with more details.

I’m afraid that assistance with custom code is outside of our scope of support.

However, I’m pretty positive that both issues you are describing are not an issue with MailPoet itself or the MailPoet configuration as if that was the case we’d be receiving several reports. This seems to be an issue specifically with your website and it could be due to:

• A conflict with another plugin
• A server configuration issue

As your host discarded the second hypothesis for now, I’d recommend doing the following:

1. Create a staging site. If your host doesn’t offer this facility, you can quickly spin up a copy of your website with WP Staging plugin.
2. On the staging site, follow these instructions to?re-install the plugin via FTP. This will ensure no plugin files are missing or corrupted.
3. If the issue persists, please deactivate all plugins on your website except MailPoet and switch to a default theme like Storefront. At this point, the issue should be sorted. Then, you can proceed with the next step – reactivate one plugin at a time checking if the issue is back after each until your find which plugin is conflicting. .

Let us know how that goes!

Hi,

thanks for the suggestions. I did the test with the plugins and actually found one that I had to delete.

After the last update, some errors no longer seem to occur. However, I also cleaned the database during this time. the categories and tags are visible again. I can now work quite well with mailpoet, except for minor delays.

The error with the database connection appears less often.

“MailPoet Error: No connection to database (The database cannot open a file or folder), the connection is probably not configured correctly. Please read our knowledge base post for the steps to resolve this.”

If I reinstall the plugin will I have to recreate all templates? Or can I save these somewhere?

• This reply was modified 3 months, 1 week ago by gesundegeschenke.

Hi there,

It’s great to hear that most issues seem to have been resolved.

If I reinstall the plugin will I have to recreate all templates? Or can I save these somewhere?

Don’t worry,?you won’t lose any data from the plugin?since it’s saved in your database, not the plugin files. However, whenever making any changes like this, we recommend making sure you have a full backup of the site just in case. ??

Let us know if you keep seeing the error message after re-installing it.