Hikashop Email History Plugin doesn't work

-- HikaShop version -- : 4.3.0

Hi Support,

After a couple of years the email log file is huge (see attachment).
We have set the numbers of days from nothing to to 30 but still the database is not cleaned up with old logs.

The URL is a copy of a old Hikashop website but we delete all the users and orders but stil we have this log in the database.

The URL is registered at my subscriptions and the cron is working.

Only saving the cron configuration is giving a error.

Can you help us with this issue?

Kind regards,
Lumiga


See also the cron log:

Last Triggered Date 1 minutes ago
Last report Connection accepted to the host : ssl://domein.nl : 443
at 15 September 20 21:59:05

---

=> Result of the trigger at 15 September 20 21:59:36
HTTP/1.1 200 OK
Date: Tue, 15 Sep 2020 19:59:05 GMT
Server: Apache
Set-Cookie: a8946c461b77000263562be80ed57cab=79f6878c5e471266ab251be76dc45a6d; path=/; secure; HttpOnly
X-Content-Type-Options: nosniff
Upgrade: h2
Connection: Upgrade, close
Transfer-Encoding: chunked
Content-Type: text/html; charset=UTF-8

88


HikaShop Uitgevoerd op 2020-09-15 21:59
0

Hi,

The plugin doesn't need the cron. It deletes the old entries gradually each time it saves a new entry.

The issue is probably that you have too much entries in the table in the database and because of that, the MySQL to delete the entries crashes before finishing and thus MySQL rollback to the previous state.

I would recommend to empty the table once via your PHPMyAdmin and then it should work fine.

Thanks!