# 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: DatabaseIndexAndKeyManagerfailed to execute successfully: java.sql.SQLException: Can't crea

URL: https://www.hannonhill.com/cascadecms/latest/articles/cascade-administration/installation-and-upgrades/database/mysql-cant-create-table.html
category: Cascade Administration
article-type: reference
content-kind: faq
release-availability: all
tags: errors, installation, database
updated: 2026-10-06

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:

```xml
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.
1. Create the database and alter it to use the proper collation as mentioned in the [MySQL Database Configuration](https://www.hannonhill.com/cascadecms/latest/articles/cascade-administration/installation-and-upgrades/database/mysql.html) section.
1. Re-import the database dump from before the last startup was attempted.
1. Start Cascade CMS.