Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted August 16, 20195 yr 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...
August 21, 20195 yr 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)
Archived
This topic is now archived and is closed to further replies.