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
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