Migration issue on Beta 11 update

tlalok

I have a problem with cmd php flarum migrate any idea?

SQLSTATE[HY000]: General error: 1005 Can't create table `flarum`.`posts` (errno: 121 "Duplicate key on write or update") (SQL: alter table `posts` add constraint `posts_discussion_id_foreign` foreign key (`discussion_id`) references `discussions` (`id`) on delete cascade)

luceos

tlalok seems odd that it tries to create the table posts, which should have existed way before beta 11; can you confirm your database has that table before upgrading?

tlalok

I find this https://stackoverflow.com/questions/12994919/errno-121-duplicate-key-on-write-or-update

I think this commit is the cause of my trouble
flarum/core8b9f03e (diff)

tlalok

luceos yes I confirm.

tlalok

Problem solved. I drop all the table and use a backup.
I tried again and everything is ok. 👌