Hello,
I am receiving the following error from EPESI once a day around 00:30 - 01:00 at night.
who=1
type=256
message=mysqli error: [1064: You have an error in your SQL syntax; check
the manual that corresponds to your MariaDB server version for the right
syntax to use near 'AS uwe WHERE id < (SELECT MIN(last_seen_event) FROM
utils_watchdog_subscription ' at line 1] in EXECUTE("DELETE FROM
utils_watchdog_event AS uwe WHERE id < (SELECT MIN(last_seen_event) FROM
utils_watchdog_subscription AS uws WHERE uws.internal_id = uwe.internal_id
AND uws.category_id = uwe.category_id)")
error file=/var/www/html/epesi_new/libs/adodb/adodb-errorhandler.inc.php
error line=79
/var/www/html/epesi_new/data/Base_Error/c7194ba1688b1194a4536823892f01a6.txt
I am using EPESI 1.8.0
PHP 5.6.27
MariaDB 10.1.18
How can I fix this?
Thanks in advance