MySQL error 1525: Incorrect DATETIME value: ''

[Neal]

@Neal

8.0.31-0ubuntu0.20.04.1

The error belongs to version/config of mysql for sure. However, downgrading is not an option as this is production system and 8.0.31 is most stable security update.

Here release notes of introduced change in 8.0.16:
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-16.html

BTW. there are similar issues reported by others:

Workflow Module: DATETIME comparisons with empty string no longer work with MySQL 8.0.16

Hi to all, At workflow module (Conditions) when you enter a new comparisson with datetime field and select IS NULL, then workflow module convert this to SQL with: for example date_entered = ' '. This is no valid with MySQL 8.x but valid with MySQL 5.x. SuiteCRM 7.12.4 PHP 7.3 MySQL 8.0.28 Thanks for any possible solution Nick