Help identify issues with MySQL 8.0

[bpamiri]

Looking to get the framework working on MySQL 8.0. If you have are are using MySQL 8.0 I'd love to hear what you ran into. Right now I've got the test suite passing on Lucee with MySQL 8.0 but ACF 2016 and ACF 2018 are failing.

[zainforbjs]

@bpamiri I tried using MySQL 8 with cfwheels in a simple CRUD operation app for users.
The issue is occurring when I go to index of users. This is working correctly for Lucee but gives error when I tried with CF 2016.
CF 2016 is adding some columns that are not present in the table.

This is the issue occurring.

The model for Users which is causing findAll() function.

System Info:

[zainforbjs]

@bpamiri I also encountered another issue while using MySQL 8 with Lucee. It renders the view correctly for users but when I try to dump the users' query, it shows a blank screen and does not output the dump.
I have also enabled the Lucee debugging the admin.

This is what I am trying to dump.

If I remove the dump, the index is correctly rendered.

Don't know if there is some setting needed to be enabled or it is a MySQL 8 issue. Will try with downgrading MySQL and try again

[neokoenig]

Not sure how progress is on this but MySQL 5.7 is now EOL, and AWS are dropping RDS support in February.

[bpamiri]

@neokoenig we've actually been testing against MySQL latest for a while now. I just finished some work on the test suites and got Adobe 2021 and Adobe 2023 integrated. The current test suite is definitely using MySQL latest so its some flavor of 8.x. You can check out the latest dev built using:
box install cfwheels-base-template@2.5.0-dev