Fork me on GitHub
Subscribe 1

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.

History

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.