Unable to upgrade from 3.42.4 to 4.1.2

While trying to upgrade my site from latest version 3 to 4.1, the debug log says :

Debug Information:
OS: Ubuntu, v20.10
Node Version: v12.21.0
Ghost Version: 4.1.2
Ghost-CLI Version: 1.16.3
Environment: production
Command: ‘ghost update’
Message: 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
Suggestion: journalctl -u ghost_www-sayfrance-com -n 50
Stack: Error: 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.
at Server. (/usr/lib/node_modules/ghost-cli/lib/utils/port-polling.js:53:28)
at Object.onceWrapper (events.js:420:28)
at Server.emit (events.js:314:20)
at emitCloseNT (net.js:1657:8)
at processTicksAndRejections (internal/process/task_queues.js:83:21)

I haven’t tried to revert back to 3.42…4 as it failed on one of my other site.
I haven’t found a solution on this forum yet.