Error while migrating database

xondak

Upgrading from version beta7 to beta 8.

When I run php flarum migrate I get the following error:

Migrating Flarum...

In Connection.php line 664:
                                                                               
  SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL  
  : alter table `flarumposts` add constraint `flarumposts_user_id_foreign` fo  
  reign key (`user_id`) references `flarumusers` (`id`) on delete set null)    
                                                                               

In PDOStatement.php line 119:
                                                                          
  SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint  
                                                                          

In PDOStatement.php line 117:
                                                                          
  SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint  
                                                                          

migrate

Any ideas on what could be wrong? Googling has done me no good with this issue.

luceos

xondak do you have multiple flarum installations in the same database but with different prefixes?

xondak

luceos I don't believe so. How would I tell?

xondak

So, the issue was that my database's table was using the wrong engine. You need to change your table's engine.

I ran this SQL command on each table:

ALTER TABLE {table_name} ENGINE = InnoDB;