Can’t save my newsletter

It sounds like or an incompatibility with another plugin or a block by your provider while the content of the newsletter is sent to be saved.

If you can try to deactivate other plugins and od some test we can then investigate further. We have no reports right now about a general bug, but I’ll ask devs to do some checks.

I performed the requested test: deactivated all plugins (with the exception of ‘Newsletter’, ‘Newsletter – Addons Manager’ and ‘Newsletter – WP Users Integration’).

Unfortunately the problem persists.

I would like to hear how to handle this further.

Thank you in advance!

Hi, leave a message in the contact form at https://www.thenewsletterplugin.com, I’ll take it up and we find a way to debug that problem. Please ask t the provider if they has mod_security active and if they can disable it at least to make a test.

Dear @satollo,

The mod_security now is disabled.

Further, I discovered that the add-on ‘WP Users Integration’ also causes problems. See screenshot for this:

[video src="https://hijis.nl/wp-content/uploads/2023/12/WP-Users-Integration-?-hij-is-—-WordPress-Google-Chrome-2023-12-11-09-56-02.mp4" /]

Last week, as requested, I raised the issue via the contact form. I haven’t received a response to this yet. I would like to know when this can be resolved.

If you have the log level to error on Newsletter’s main settings (or higher level) after the error you could have more information on System/Logs probably in the “store” log.

To ensure that two issues are not mixed up, here is a summary of what is happening now:

1. The first thing that happens is not being able to save new newsletters to be sent (see also the messages above). When saving, a new concept is started, but the already created concept is not saved. On your advice, I submitted this via the contact form on the website. However, I have not received any response to this yet.
2. The second thing is not being able to save new subscribers via the ‘WP Users Integration’ add-on. You have been requested to view the logbook. Below you will find an elaboration of this:

09-12-2023 16:36:34 - FATAL - 8.0.6 - 25,7 MB/384 MB -  > Duplicate entry '0' for key 'PRIMARY'
09-12-2023 16:36:34 - FATAL - 8.0.6 - 25,7 MB/384 MB -  > INSERT INTO wpop_newsletter (ip, email, name, surname, referrer, token, status, updated) VALUES ('31.201.237.184', '[email protected]', 'John', 'Johnson', 'registration', '4044e6e081', 'C', '1702139794')
11-12-2023 08:45:31 - FATAL - 8.0.6 - 35,0 MB/384 MB - [email protected] > Duplicate entry '0' for key 'PRIMARY'
11-12-2023 08:45:31 - FATAL - 8.0.6 - 35,0 MB/384 MB - [email protected] > INSERT INTO wpop_newsletter (email, name, surname, status, wp_user_id, referrer, token) VALUES ('[email protected]', 'John', 'Johnson', 'C', '282', 'wordpress', '12bad94b3d')
11-12-2023 08:53:52 - FATAL - 8.0.6 - 35,0 MB/384 MB - [email protected] > Duplicate entry '0' for key 'PRIMARY'
11-12-2023 08:53:52 - FATAL - 8.0.6 - 35,0 MB/384 MB - [email protected] > INSERT INTO wpop_newsletter (email, name, surname, status, wp_user_id, referrer, token) VALUES ('[email protected]', 'John', 'Johnson', 'C', '282', 'wordpress', '3806bd6e51')
11-12-2023 08:56:13 - FATAL - 8.0.6 - 35,0 MB/384 MB - [email protected] > Duplicate entry '0' for key 'PRIMARY'
11-12-2023 08:56:13 - FATAL - 8.0.6 - 35,0 MB/384 MB - [email protected] > INSERT INTO wpop_newsletter (email, name, surname, status, wp_user_id, referrer, token) VALUES ('[email protected]', 'John', 'Johnson', 'C', '282', 'wordpress', '0808c82f97')
11-12-2023 15:37:58 - FATAL - 8.0.6 - 35,0 MB/384 MB - [email protected] > Duplicate entry '0' for key 'PRIMARY'
11-12-2023 15:37:58 - FATAL - 8.0.6 - 35,0 MB/384 MB - [email protected] > INSERT INTO wpop_newsletter (email, name, surname, status, wp_user_id, referrer, token) VALUES ('[email protected]', 'John', 'Johnson', 'C', '282', 'wordpress', 'a27ff21b60')

I have anonymized the log with fictitious users. However, the notifications are the same. You can see that the user logged in on December 9 and the automatic creation of a subscriber was not successful. Every time after that I tried to start the integration myself, without success.

Hopefully we can resolve these two issues. I like to hear it!

Hi, your wpop_newsletter tables is not correct, it seems missing the autoincrement option on the id column, probably is missing the primary key as well. Have you migrated the database? You can try to deactivate the plugin and reactivate, hoping that can fix the table.

Dear @satollo,

I tried deactivating the plugin and then reactivating it (including the add-ons). Unfortunately, the same problems persist.

I recently moved my website to a new hosting provider. So yes, the database has been migrated recently. Could that be the problem? And how can this be solved?

Hi, they missed something migrating the database. Ask the to ensure the wp_newsletter and wp_newsletter_emails tables has an id column set as primary key and auto-incrementing. All wp_newsletter* tables should be checked (in your case the “wp_” prefix seems “wpop_”).

As requested, I have forwarded your message to the web hosting. They have made a number of adjustments, see their message below:

“Thank you for your message and forwarding their comment. All tables were present but auto increment did not seem to be enabled in those tables. We have now enabled this for you and the problem should now be solved.”

The issue with saving drafts is now resolved. However, the ‘WP User Integration’ add-on still does not work. I also deactivated the plugin again and then activated it. This didn’t work either.

I then receive the following message:

“Database error. If you were saving a newsletter try a table upgrade from the status panel.”

I also tried the table upgrade and it didn’t work…

Any ideas?

You should delete all the logs in System/Logs, reproduce the error and then look for a store-xxx.txt log file. Since that addon uses a join, probably you have different charsets on the wp_users and wp_newsletter tables.

• This reply was modified 11 months, 2 weeks ago by Stefano Lissa.

Thanks for your quick respons (again), @satollo!

I’m not quite sure what you mean by “Since that addon uses a join” and what kind of action this requires.

I did delete the logs and ran the add-on again. The log now shows the following (anonymized again):

12-12-2023 17:58:16 - FATAL - 8.0.6 - 35,0 MB/384 MB - [email protected] > Duplicate entry '0' for key 'PRIMARY'
12-12-2023 17:58:16 - FATAL - 8.0.6 - 35,0 MB/384 MB - [email protected] > INSERT INTO wpop_newsletter (email, name, surname, status, wp_user_id, referrer, token) VALUES ('[email protected]', 'John', 'Johnson', 'C', '282', 'wordpress', '7b6ccdacd6')

Can you see what’s going wrong?

Hi, that log shows again the primary key problem with the missing autoincrement option… I really don’t know, is the provider sure it fixed the problem? They can try the insert in your log to verify everything is working.

Dear @satollo,

Ultimately, it turned out that when my website was moved to a new hosting party, the tables were incompletely migrated. This has now been corrected by them. Everything now works again as it should.

Thank you for all your effort!

Thank you very much for sharing, for sure it will be of help to others!