"Database Error" when I try to save, test, or send a newsletter.

[methodsman]

Hi,

I’m on newsletter version 3.8.8 and wordpress version 4.3.1. I have used newsletter successfully for a few months now.

I can create a new newsletter, but when I try to save (or send) it, I get a blank screen that just says “database error”. I have deactivated and reactivated the plugin to no avail.
I could try uninstalling and reinstalling, but if I do that will I lose my subscriber list?

Thanks,
MM

[Stefano]

could you check the store.log inside the folder wp-content/logs/newsletter?

[methodsman]

Sure. The log looks like this:
12-09-2015 00:56:18 – FATAL – 29.3 MB –
12-09-2015 00:58:54 – FATAL – 29.3 MB –
12-09-2015 01:02:34 – FATAL – 29.3 MB –
12-09-2015 01:03:17 – FATAL – 29.3 MB –
12-09-2015 01:05:37 – FATAL – 29.3 MB –
12-09-2015 01:09:54 – FATAL – 29.3 MB –
12-09-2015 01:22:36 – FATAL – 29.3 MB –
12-09-2015 11:42:26 – FATAL – 29.3 MB –
12-09-2015 15:23:32 – FATAL – 29.3 MB –
13-09-2015 18:44:58 – FATAL – 29.3 MB –
13-09-2015 18:50:05 – FATAL – 27.1 MB –
13-09-2015 18:50:43 – FATAL – 29.3 MB –
13-09-2015 19:02:49 – FATAL – 29.3 MB –
13-09-2015 19:09:03 – FATAL – 29.3 MB –
13-09-2015 19:09:45 – FATAL – 29.3 MB –
14-09-2015 13:12:28 – FATAL – 29.5 MB –
15-09-2015 18:17:00 – FATAL – 29.4 MB –

Does that help?

[methodsman]

Just an update. I updated to vesion 3.9.0 today and still get “database error” when trying to save a newsletter.

Should I delete and reinstall the plugin? If so, will I lose my subscribers?

Thanks,
MM

[Stefano]

Hi, nothing will be lost if you reinstall the plugin, anyway try firstly to deactivate and reactivate the plugin.
Check the diagnostic panel as well and try to report me the Database Charset/Collate value. Check even the folder wp-content/logs/newsletter and find a file store-xxxx.log. Can you send it to me? (stefano@thenewsletterplugin.com)

Thank you, Stefano.

[methodsman]

Store-xxx sent via e-mail. I also deactivated / reactivated to no avail.

The database/charset value is UTF8.

My next step will be to uninstall / reinstall but I’ll wait to hear from you first.

Thanks,
MM

[Stefano]

I received your files, but the logs have nothing more to understand the problem. Can you give me an administrative access so I can try to save the email which gave you that error and debug it? If so, stefano@thenewsletterplugin.com.

Thank you.

[methodsman]

Sure, sending e-mail now.

Thanks.

[mnelson]

Hi there – was this ever resolved? I’m getting the same error when I’m attempting a new newsletter and click ‘Proceed to Edit’.

[Stefano]

Hi, try to force an upgrade from the diagnostic panel, for example. Database errors should be reported in the logs (wp-content/logs/newsletter/*.txt).

Stefano.

[Author]

Posts