MySQL: Can't create table

When starting Cascade CMS for the first time or after importing a new MySQL database, administrators may see an error message in the log file similar to the following:

ERROR [StartupTasks] : *** Startup task: DatabaseIndexAndKeyManager
failed to execute successfully: java.sql.SQLException: Can't create table
'.\cascade\#sql-1648_8.frm' (errno:150)

This means that the collation for the tables is incorrect. To fix this problem, take the following steps:

  1. Drop the database.
  2. Create the database and alter it to use the proper collation as mentioned in the MySQL Database Configuration section.
  3. Re-import the database dump from before the last startup was attempted.
  4. Start Cascade CMS.