Unable to start Ghost after update: Error occurred while executing the following migration: 2023-07-27-11-47-49-create-donation-events.js

Developer help Installation
1

I updated Ghost to version 5.63.0, however, after the update I cannot start Ghost.

Debug Information:
OS: Ubuntu, v22.04.3 LTS
Node Version: v16.20.2
Ghost Version: 5.63.0
Ghost-CLI Version: 1.24.2
Environment: production
Command: ‘ghost start’
Message: Ghost was able to start, but errored during boot with: alter table donation_payment_events add constraint donation_payment_events_member_id_foreign foreig>Help: Error occurred while executing the following migration: 2023-07-27-11-47-49-create-donation-events.js
Suggestion: journalctl -u ghost_euaggelion-blog-br -n 50
Stack: Error: Ghost was able to start, but errored during boot with: alter table ‘donation_payment_events’ add constraint ‘donation_payment_events_member_id_foreign’ f> at Server. (/usr/lib/node_modules/ghost-cli/lib/utils/port-polling.js:73:28)
at Object.onceWrapper (node:events:627:28)
at Server.emit (node:events:513:28)
at emitCloseNT (node:net:1857:8)
at processTicksAndRejections (node:internal/process/task_queues:82:21)

Any idea for solving the problem?

2

If you are using a database version older than MySQL 8, that could be the problem.

It’s failing on a database “ALTER TABLE” statement.

3

Currently, I already use the MySQL 8 version. But I ended up finding this issue on Github that helped solve my problem (Migration failed in latest version · Issue #288 · docker-library/ghost · GitHub)

1 Like