I just had a trial run of moving to using Mysql 8 (all linux, lucee 5.2.x). All appears to work OK but in the COAPI Overview / Conflicts it lists every Type & Rule with every field needing to be repaired. Needless to say the repair doesn’t work and throws no error.
Just wanting to know if anyone is using Mysql 8 and if there is a fix/trick I haven’t spotted in a later version of FC.
I may have run into the same issue with new versions of MariaDB.
The issue may be that the default of string columns according to FarCry are without quotes, but the default from the database is reported with quotes. As such, the COAPI thinks the column needs repairing
I’m going to submit a PR for p740 but it could be backported to 7.2.12