Database error

[****]

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

[Stefano]

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.

[****]

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

[Author]

Posts