My Ghost blogs fail to migrate and all have no members/subscribers. When migrating to ghost v4 via the latest cli, they fail to migrate and are left in an unusable state, forcing me to reinstall.
- Have a ghost blog with no members on the latest Ubuntu, Node, etc.
- Upgrade from Ghost v3.42.4
Ghost was able to start, but errored during boot with: alter table `members_subscribe_events` add constraint `members_subscribe_events_member_id_foreign` foreign key (`member_id`) references `members` (`id`) on delete CASCADE - UNKNOWN_CODE_PLEASE_REPORT: Referencing column 'member_id' and referenced column 'id' in foreign key constraint 'members_subscribe_events_member_id_foreign' are incompatible. Help: Error occurred while executing the following migration: 05-add-members-subscribe-events-table.js
Any other info e.g. Why do you consider this to be a bug? What did you expect to happen instead?
OS: Ubuntu, v20.04.2 LTS Node Version: v14.16.0 Ghost Version: 4.1.2 Ghost-CLI Version: 1.16.3 Environment: production Command: 'ghost upgrade' ```v