My client's host has just upgraded to MySQL8 and, of course, we now have a 1064 error around the word 'groups'. I've read some stuff online about reserved keywords and adding backticks, but I can't find anything in the forums about which files need to be changed.
Are there any C5 devs out there who could give me a comprehensive guide? Pretty please?
In MySQL, certain words like SELECT, INSERT, DELETE etc. are reserved words. Since they have a special meaning, MySQL treats it as a syntax error whenever you use them as a table name, column name, or other kind of identifier - unless you surround the identifier with backticks.
You are allowed to delete your post for 5 minutes after it's posted.