KT Walrus Posted August 16, 2019 Posted August 16, 2019 Anyone thinking of using the latest MySQL 8.0 release, should wait until IPS fixes problems caused by the word "member" being a reserved word. Invision Community contains a number of columns called "member" in various tables. In order to use this column, the reserved word has to be surrounded by back ticks (i.e., "`member`"). I use docker containers to run Invision Community and I use the latest MySQL 8.0 image from the docker hub. So, I'm hitting SQL syntax errors whenever Invision Community uses "member" without back ticks. I've run into many instances where I needed to edit the PHP files to add the missing back ticks. So, just a warning to not upgrade to MySQL 8.0.17 until IPS fixes this issue...
Aurélio "Baboo" Posted August 21, 2019 Posted August 21, 2019 I'm using MySQL 8.0.17 and IPB 4.4.6 still have some compatibility issues with e-mail validation and manual approval for new users, as they don't work anymore. (I replaced 8.0.17 with 8.0.15 but couldn't boot server version 80015 on data directory built by version 80017 because downgrade is not supported)
Management Matt Posted August 21, 2019 Management Posted August 21, 2019 We're aware and making fixes when we find them.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.