Php7.4 mysql 8.0 SuitCRM doesn't install

[pgr]

I don’t know. It hasn’t been announced.

For MySQL 8 you can follow this

SQL "rank" is a reserved word, can't be used as a field name in MySQL 8.0.2 and later

and you can even use the fix linked there, it should be easy to get it working.

I think you can try PHP 7.4 in a test environment, maybe it works ok, maybe not. You can evaluate, and perhaps open Github issues if you find anything breaking.