SQL-ERR when trying to clear logs
Posted: Wed Jan 06, 2021 8:27 pm
Hi,
Fairly new user of the excellent Zoneminder and first time poster here, so please be gentle...
When I try the 'clear' button in the log viewer window, I immediately get this error and the logs do not clear:
SQL-ERR 'SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DECIMAL value: '2021-01-06 20:14:03'', statement was 'DELETE FROM Logs WHERE TimeKey > ? ORDER BY TimeKey desc LIMIT 100' params:2021-01-06 20:14:03
It appears I have something wrong with the date time formats. I have checked MySQL is set to "SYSTEM", and Ubuntu is set to "GMT (London, UK)". I have tried setting the ZM TIMEZONE option to both "Unset - use value in PHP.ini" and "GMT (Europe, London)" but get the same result.
Any advice as to what is the problem here and how I might fix it?
Thanks!
Fairly new user of the excellent Zoneminder and first time poster here, so please be gentle...
When I try the 'clear' button in the log viewer window, I immediately get this error and the logs do not clear:
SQL-ERR 'SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DECIMAL value: '2021-01-06 20:14:03'', statement was 'DELETE FROM Logs WHERE TimeKey > ? ORDER BY TimeKey desc LIMIT 100' params:2021-01-06 20:14:03
It appears I have something wrong with the date time formats. I have checked MySQL is set to "SYSTEM", and Ubuntu is set to "GMT (London, UK)". I have tried setting the ZM TIMEZONE option to both "Unset - use value in PHP.ini" and "GMT (Europe, London)" but get the same result.
Any advice as to what is the problem here and how I might fix it?
Thanks!