Home Forums Newsletter Plugin Support Database error when creating a new newsletter

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #20893
    droomagentur
    Participant

    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.

    #20894
    Stefano
    Keymaster

    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.

    #20896
    droomagentur
    Participant

    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.

    #20898
    Stefano
    Keymaster

    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

    #20924
    droomagentur
    Participant

    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!

    #26554
    victornebril
    Participant

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

    thanks

Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.