KT Walrus Posted August 16, 2019 Share 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... Link to comment Share on other sites More sharing options...
Martin A. Posted August 16, 2019 Share Posted August 16, 2019 Will be fixed in 4.4.6. Link to comment Share on other sites More sharing options...
Aurélio "Baboo" Posted August 21, 2019 Share 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) Link to comment Share on other sites More sharing options...
Management Matt Posted August 21, 2019 Management Share Posted August 21, 2019 We're aware and making fixes when we find them. Link to comment Share on other sites More sharing options...
Aurélio "Baboo" Posted August 21, 2019 Share Posted August 21, 2019 Great! THX! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.