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
Ghost won't start after upgrading to MySQL 8 Self-hosting	1	502	February 22, 2022
Ghost update problem Developer help	9	1253	December 1, 2022
Unable to update Ghost from 5.2.3 to 5.4.0 Self-hosting	14	1927	November 12, 2023
Ghost 4.1.0 errored during boot Installation	9	4341	July 7, 2021
Upgrading from 5.23.0 to 5.25.0 breaks ghost with SQL error Self-hosting	5	762	May 6, 2023

Problem upgrading to Ghost 5.30 and higher

Related topics