Ticket #1148 (open bug)
Fails to work with MySQL 8+ because of "groups" becoming reserved word
- Created: 2020-04-30 12:40:37
- Reported by: Fluxxer
- Assigned to: None
- Milestone: None
- Component: database
- Priority: highest
In newer MySQL versions "groups" is a reserved word, resulting in a lot of SQL errors when trying to use fluxbb.
The groups table should either be renamed, or you should add backticks (`groups`) to all queries.
Visman 2020-04-30 12:55:51
Use a prefix for table names without fail.
If you already have data in the database, then manually rename the tables and then write the prefix to the config.php file.