Database error when creating a new newsletter

[droomagentur]

It seems that there is something off in the newest release – on a clean install I can update all the settings and select a template for a newsletter but once I want to proceed to the edit screen, I’m greeted with “database error.” (blank page with only this error message)

A look into the logfiles reveals:

[Tue Feb 16 11:40:44 2016] [error] [client XXX.XXX.XXX.XXX] WordPress-Datenbank-Fehler Unknown column 'status' in 'where clause' f\xc3\xbcr Abfrage select * from myprefix_newsletter_emails where status='sending' and send_on<1455619244 order by id asc von do_action_ref_array, call_user_func_array, Newsletter->hook_newsletter

Please advise.

[Stefano]

The columns status in the database could not be missing. Have you deleted the tables or make a fresh installation? Try to deactivate and reactivate the plugin one o more times.
It seems the table has not been created properly.

[droomagentur]

Thanks for the quick reply – it was a fresh install via WordPress’ plugins page, I also tried to remove the plugin (even deleting it via the plugins page) and reinstalling it but to no avail, the error stays.

[Stefano]

Hi, check if the mysql user you’re using can execute alter table or like. Check even the wp-content/logs/newsletter folder, there should be file with error loged there. You can eventually send them to me at stefano@thenewsletterplugin.com for a check.

Stefano.
http://www.satollo.net

[droomagentur]

Thank you for your feedback, the mySQL user from our shared hosting provider didn’t have proper permissions set and therefore the installation of the necessary database tables went wrong. Now everything works out nicely!

[victornebril]

Hi this happen to me too. Where can I find the mySQL user to give it more permissions?

thanks

[Author]

Posts