Fork me on GitHub
Subscribe 2

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: quy
  • Milestone: 1.6
  • 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.

quy 2021-03-05 17:26:42

  • Milestone set to 1.6.
  • Owner set to quy.