When trying to update to 5.30, 5.31 or 5.4, I get the same error, causing the upgrade to fail: Message: Ghost was able to start, but errored during boot with: alter table comments add constraint comments_post_id_foreign foreign key (post_id) references posts (id) on delete CASCADE - Referencing col…

It’s most likely collation related, where the original posts table has ended up with a different collation than new tables are configured to use. There’s a related thread here with a potential fix, although I haven’t tried it myself Unable to upgrade Ghost from v4.2.0 to v4.3.0 (CASCADE - UNKNOWN_C…

Problem upgrading to Ghost 5.30 and higher

Developer help Self-hosting

Adders July 19, 2022, 6:14pm 7

Yes, that worked. Following these instructions resolved the situation easily and simply.

Thank you!

1 Like

Topic		Replies	Views
Unable to update Ghost from 5.2.3 to 5.4.0 Self-hosting	14	1562	November 12, 2023
Ghost update problem Developer help	9	1023	December 1, 2022
Ghost won't start after upgrading to MySQL 8 Self-hosting	1	415	February 22, 2022
Ghost 4.1.0 errored during boot Installation	9	3933	July 7, 2021
Unable to upgrade Ghost from v4.2.0 to v4.3.0 (CASCADE - UNKNOWN_CODE_PLEASE_REPORT) Developer help	68	6362	October 13, 2022

Problem upgrading to Ghost 5.30 and higher

Related Topics