Hi team, I’m getting this error when i’m updating my ghost image from 5.2.4 to 5.34.0 - ERROR alter table subscriptions modify tier_id varchar(24) not null - Cannot change column ‘tier_id’: used in a foreign key constraint ‘subscriptions_tier_id_foreign’ alter table subscriptions modify tier_i…

Ghost version update in k8s

markstos February 16, 2023, 5:52pm 4

I searched in the Ghost Forum here for “‘subscriptions_tier_id_foreign” and found this related post from someone else who ran into this RDS and found a solution. Is it helpful to you?

Topic		Replies	Views
Migration failed update from 5.19.3 to 5.22.1 with ER_FK_COLUMN_CANNOT_CHANGE Migrations	4	923	December 23, 2022
Unable to update from v4.2.1 to 4.3.1 or 4.3.2 Developer help	6	1202	April 23, 2021
Unable to update Ghost from 5.2.3 to 5.4.0 Self-hosting	14	1804	November 12, 2023
Unable to update from 5.24.2 to 5.25.0 (Referencing column 'email_id' and referenced column 'id' ... are incompatible) Self-hosting	3	894	December 6, 2022
Upgrading v4.10.2 to v4.11.0 error Developer help	8	965	September 20, 2021

Ghost version update in k8s

Related topics