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…

What version were you upgrading from? And, are you running MySQL 8 or MariaDB?

Upgrading from 5.24, running MySQL 8: OS: Ubuntu, v20.04.4 LTS Node Version: v14.19.3 Ghost-CLI Version: 1.21.0

An update: This is almost certainly related to a database migrated from MySQL 5 to 8. I have three installs running on Digital Ocean droplets - the one that’s always been on MySQL 8 updated fine, the two that were migrated from 5 to 8 for Ghost 5 are the ones failing. So, I have a clearer idea of …

I thought it may be database related, as I’ve seen something similar in the forum when migrating from MariaDB to MySQL. If I have a moment later today, I’ll see if I can find something.

[image] Kevin: There’s a related thread here with a potential fix Yes, that worked. Following these instructions resolved the situation easily and simply. Thank you!

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!

Topic		Replies	Views
Ghost won't start after upgrading to MySQL 8 Self-hosting	1	513	February 22, 2022
Ghost update problem Developer help	9	1294	December 1, 2022
Unable to update Ghost from 5.2.3 to 5.4.0 Self-hosting	14	1999	November 12, 2023
Ghost 4.1.0 errored during boot Installation	9	4408	July 7, 2021
Upgrading from MariaDB can't upgrade past 6.26.0 Self-hosting	3	71	May 14, 2026

Problem upgrading to Ghost 5.30 and higher

Related topics