Fixing Ghost Blog ER_FK_Incompatible Columns Error on Unraid Docker
After lots of searching and no solutions, I made a video on how to fix the error ER_FK_INCOMPATIBLE_COLUMNS_ERROR in Ghost Blog Docker Containers 5.6.0 and later to :latest on Unraid.
Using Adminer (community Apps) Container to connect to my MYSQL, I had the wrong (old) collation. Updated from utf8mb4_general_ci to utf8mb4_0900_ai_ci using Adminer.
Execute the following SQL Statement:
SELECT CONCAT('ALTER TABLE ', table_name, ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;') AS sql_statement FROM information_schema.tables WHERE table_schema = 'ghost';
(note, change 'ghost' to the name of your db schema)
Using the output from above, execute the following sql statements:
-- Disable foreign key checks
SET foreign_key_checks = 0;
-- Execute the generated ALTER TABLE statements
ALTER TABLE actions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE api_keys CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; -- ... (paste whole output from previous step)
-- Enable foreign key checks
SET foreign_key_checks = 1;