MySQL error upgrading from v5.55.0...v5.58.0 - errored during boot with: alter table `donation_payment_events`

I was able to fix it by basically doing this

except i set forgeign key check to 0
then manually do this for each table…

ALTER TABLE subscriptions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;

then set back to 1

then upgrade worked

1 Like