Jump to content

MEMBER now reserved word in MySQL 8.0.17

Featured Replies

Posted

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...

Will be fixed in 4.4.6.

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)

  • Community Expert
  • Management

We're aware and making fixes when we find them.

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.