SQL-ERR when trying to clear logs

[markymarkn]

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!

[markymarkn]

I'd be very grateful for any advice...