Hi @bredaportoni,
Thanks for reaching out! Please head over to the following page within your WordPress backend (your.site/wp-admin/options.php).
1) On that page, please search for, wp_mail_smtp_migration_version, and update its value to 1.
2) Within the same page, search for the wp_mail_smtp_debug_events_db_version and update its value to 0.
Make sure to save the changes and reload your WP Mail SMTP -> Settings page to recreate those tables.
Let us know how it goes.
Thanks!
Hi,
Even if I save it, the “wp_mail_smtp_migration_version” value is still “5”…
Hi @bredaportoni,
Could you please check your WordPress debug log to see whether you can find any issues related to your Database?
If you don’t have a debug log, here’s how you can enable it on your WordPress site.
Once you enable the debug log, you can deactivate. then reactivate the WP Mail SMTP plugin and check your error log.
You can report those issues to your hosting support and they should be able to fix it for you.
I hope this helps. Thanks! 🙂
Here the errors:
[12-Jul-2023 07:40:17 UTC] WordPress database error Unknown collation: ‘utf8mb4’ for query CREATE TABLE IF NOT EXISTS br_wpmailsmtp_debug_events (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
content TEXT DEFAULT NULL,
initiator TEXT DEFAULT NULL,
event_type TINYINT UNSIGNED NOT NULL DEFAULT ‘0’,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
)
ENGINE=’InnoDB’
DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4; made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, WPMailSMTP\Core->init_migrations, WPMailSMTP\MigrationAbstract->init, WPMailSMTP\MigrationAbstract->validate_db, WPMailSMTP\MigrationAbstract->run, WPMailSMTP\Admin\DebugEvents\Migration->migrate_to_1
Hi @bredaportoni,
The error denotes that your Database version does not support the required collation type (InnoDB).
Please get in touch with your hosting support with the above error and they should be able to fix it for you.
I hope this helps. Thanks!
