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

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

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

1 Like