Is there any update on the error.
During upgrade from ghost 3 to ghost 4 I’m facing the same error:
Steps:
(1) Force update
ghost update v4 --force
(2) Restart
ghost is not starting.
So I do:
ghost restart
error:
✖ Starting Ghost
A GhostError occurred.
Message: Ghost was able to start, but errored during boot with: alter table `oauth` add constraint `oauth_user_id_foreign` foreign key (`user_id`) references `users` (`id`) - UNKNOWN_CODE_PLEASE_REPORT: Referencing column 'user_id' and referenced column 'id' in foreign key constraint 'oauth_user_id_foreign' are incompatible.
Help: Error occurred while executing the following migration: 01-add-oauth-user-data.js
Suggestion: journalctl -u ghost_localhost -n 50
Debug Information:
OS: Ubuntu, v20.04.3 LTS
Node Version: v14.17.6
Ghost Version: 4.16.0
Ghost-CLI Version: 1.17.3
Environment: production
Command: 'ghost restart'
(3) Update Collation (despite being ok)
Then I update the table collation by:
again restart results into
(4) Error - Cannot remove permission(Reset all passwords) with role(Administrator) - permission does not exist
Ghost instance is not running! Starting...
+ sudo systemctl start ghost_localhost
+ sudo systemctl stop ghost_localhost
✖ Starting Ghost
A GhostError occurred.
Message: Ghost was able to start, but errored during boot with: Cannot remove permission(Reset all passwords) with role(Administrator) - permission does not exist
Suggestion: journalctl -u ghost_localhost -n 50
Debug Information:
OS: Ubuntu, v20.04.3 LTS
Node Version: v14.17.6
Ghost Version: 4.16.0
Ghost-CLI Version: 1.17.3
Environment: production
Command: 'ghost restart'
P.S. Should I open new post?