Home Forums Newsletter Plugin Support Forum Database error

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #106255
    yayathewall
    Participant

    Hi all!

    Unfortunately, the subscription conformation email doesn’t work anymore on my site. I cannot tell from what point on it didn’t work anymore because I just realized it yesterday. If I click on “Resend Confirmation Mail” the confirmation email gets send. If I use the regular newsletter subscription form I get the following message: “Database error see the log files (log files path can be found on Newsletter diagnostic panel)”. The store log files show a lot of the following messages:
    05-06-2018 12:46:56 – FATAL – m: 61,4 MB, u: 0 – Unknown column ‘source’ in ‘field list’
    05-06-2018 12:46:56 – FATAL – m: 61,4 MB, u: 0 – INSERT INTO kx_newsletter_user_logs (user_id, source, created, data) VALUES (145, ‘subscribe’, ‘1528202816’, ‘{\”list_1\”:\”0\”,\”status\”:\”S\”}’)

    I suspect, that during the subscription process an exception gets thrown and therefore the subscription confirmation email gets never sent to the subscriber.

    I have also the following messages on the newsletter status page but I’m not sure if they are related to the issue:
    “Check the privileges of the user you use to connect to the database, it seems it cannot create tables.”
    “Check the privileges of the user you use to connect to the database, it seems it cannot change the tables. It’s require to update the plugin.”

    I already tried to deactivate / reactivate the plugin.

    I do not have any access to the database itself and because everything worked smoothly before I updated the plugin (as written above – I’m not sure if the issue is related to me updating the plugin) I wanted to ask for help here.

    Thank you very much and kind regards

    #106279
    Stefano
    Keymaster

    Hi, it seems the database has not been updated. Try to deactivate the plugin are reactivate. Did you installed as new or upgraded from a previous version?

    Stefano.

    #106352
    yayathewall
    Participant

    Hi Stefano

    Thanks a lot for the fast response.
    Yes, I have already tried to deactivate and reactivate the plugin. Unfortunately, it didn’t solve the problem.
    I made an upgrade from a previous version.

    Out of your answer I guess, that the MySQL permission problem shown on the newsletter plugin status page is related to my problem. I will ask my hoster to check the permission for the database. After that I’ll retry to reactivate the plugin.

    I’ll let you know if that fixed the issue.

    Thanks!
    Jan

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