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

1 Like