Last night at 10:30, our charity’s website started logging SQL syntax errors. No changes have been made to the code or the database. Upon researching this, I have found that the following SQL statement is in error:
SELECT groups.id FROM groups;
- SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘groups’ at line 1 */
The table ‘groups’ exists, and ‘id’ is the primary key. This code and table haven’t changed in years. How is this a syntax error and what could have changed?
This is on shared server running Free BSD 13.3 and MySQLI 8.2.20