MySQL8 reserved keywords

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?

Version is 5.6, hence using the legacy forum.

Cardona787 replied on at Permalink Reply
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.