Jump to content

MEMBER now reserved word in MySQL 8.0.17

KT Walrus

Recommended Posts

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


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

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...