Hi Stefano,
I’m having the exact same problem.
We’re using premium license of the plugin.
E-mails from the Diagnostics are reaching the mail box,
but real newsletters are not even reaching the spam folder.
We’ve tried different email layouts. The plugin says newsletter has been sent (5/5),
in reports they appear as sent, delivered and not opened.
Settings are all ok (same settings I’ve used in a succesfull instalation).
We are using SSL smtp.
Any ideia on what could be the problem in such a cenario?
Here are some of the info on the logs:
– USERS LOG
04-10-2017 05:27:52 – INFO – m: 63,1 MB, u: 2 – upgrade_query> Executing alter table wp_newsletter convert to character set
DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
04-10-2017 05:27:52 – DEBUG – m: 63,1 MB, u: 2 – You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ‘CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci’ at line 1
– EMAIL LOG
04-10-2017 05:27:52 – INFO – m: 63,1 MB, u: 2 – upgrade_query> Executing alter table wp_newsletter_emails change column type
type
varchar(50) not null default ”
04-10-2017 05:27:52 – INFO – m: 63,1 MB, u: 2 – upgrade_query> Executing alter table wp_newsletter_emails add column token
varchar(10) not null default ”
04-10-2017 05:27:52 – DEBUG – m: 63,1 MB, u: 2 – Duplicate column name ‘token’
04-10-2017 05:27:52 – INFO – m: 63,1 MB, u: 2 – upgrade_query> Executing alter table wp_newsletter_emails drop column visibility
04-10-2017 05:27:52 – DEBUG – m: 63,1 MB, u: 2 – Can’t DROP ‘visibility’; check that column/key exists
04-10-2017 05:27:52 – INFO – m: 63,1 MB, u: 2 – upgrade_query> Executing alter table wp_newsletter_emails add column private
tinyint(1) not null default 0
04-10-2017 05:27:52 – DEBUG – m: 63,1 MB, u: 2 – Duplicate column name ‘private’
STATISTICS LOG
04-10-2017 05:27:52 – INFO – m: 63,1 MB, u: 2 – upgrade_query> Executing ALTER TABLE wp_newsletter_emails
ADD COLUMN open_count
int UNSIGNED NOT NULL DEFAULT 0
04-10-2017 05:27:52 – DEBUG – m: 63,1 MB, u: 2 – Duplicate column name ‘open_count’
04-10-2017 05:27:52 – INFO – m: 63,1 MB, u: 2 – upgrade_query> Executing ALTER TABLE wp_newsletter_emails
ADD COLUMN click_count
int UNSIGNED NOT NULL DEFAULT 0
04-10-2017 05:27:52 – DEBUG – m: 63,1 MB, u: 2 – Duplicate column name ‘click_count’
04-10-2017 05:27:52 – INFO – m: 63,1 MB, u: 2 – upgrade_query> Executing alter table wp_newsletter_emails change column read_count open_count int not null default 0
04-10-2017 05:27:52 – DEBUG – m: 63,1 MB, u: 2 – Unknown column ‘read_count’ in ‘wp_newsletter_emails’
04-10-2017 05:31:42 – DEBUG – m: 63,2 MB, u: 2 – Relink with token:
04-10-2017 05:31:42 – DEBUG – m: 64,0 MB, u: 2 – Relink with token:
04-10-2017 05:31:42 – DEBUG – m: 64,0 MB, u: 2 – Relink with token:
04-10-2017 05:35:54 – DEBUG – m: 63,0 MB, u: 2 – Relink with token:
04-10-2017 05:35:54 – DEBUG – m: 63,8 MB, u: 2 – Relink with token:
04-10-2017 05:35:55 – DEBUG – m: 63,8 MB, u: 2 – Relink with token:
04-10-2017 11:42:21 – DEBUG – m: 49,1 MB, u: 0 – Open tracking: MzsxMzg7ODZiMjA3MTZmYmQ1YjI1M2QyN2NlYzQzMTI3MDg5YmM=
04-10-2017 11:42:21 – INFO – m: 49,2 MB, u: 0 – Email with no token hence not signature to check
SUBSCRIPTION LOG
04-10-2017 05:27:52 – INFO – m: 63,2 MB, u: 2 – upgrade_query> Executing update wp_options set autoload=’yes’ where option_name=’newsletter_subscription_profile’ limit 1
04-10-2017 05:27:52 – INFO – m: 63,1 MB, u: 2 – upgrade_query> Executing update wp_options set autoload=’yes’ where option_name=’newsletter_subscription_lists’ limit 1
04-10-2017 05:27:52 – INFO – m: 63,1 MB, u: 2 – upgrade_query> Executing update wp_options set autoload=’no’ where option_name=’newsletter_subscription_template’ limit 1