koznov
commented
1 week ago mysql> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME='ghost';
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| utf8mb4 | utf8mb4_0900_ai_ci |
+----------------------------+------------------------+
1 row in set (0.00 sec)
Issue Summary
Hello! I'm facing issue with upgrading to latest version from 5.60 after migrating to MySQL 8 with upgrading OS to Ubuntu 20.04. I've applied recommendations from article about ER_FK_INCOMPATIBLE_COLUMNS and that doesn't help. I'm
SHOW TABLE STATUS giving me collation utf8mb4_0900_ai_ci at all tables.
mysql> show create database ghost\G 1. row Database: ghost Create Database: CREATE DATABASE
ghost/!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci / /!80016 DEFAULT ENCRYPTION='N' / 1 row in set (0.00 sec)mysql> show variables like '%collation_connection%'; +----------------------+--------------------+ | Variable_name | Value | +----------------------+--------------------+ | collation_connection | utf8mb4_0900_ai_ci | +----------------------+--------------------+ 1 row in set (0.01 sec)
mysql>
mysql> SELECT @@GLOBAL.sql_mode; +-----------------------------------------------------------------------------------------------------------------------+ | @@GLOBAL.sql_mode | +-----------------------------------------------------------------------------------------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | +-----------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
mysql>
MySQL Server version: 8.0.37-0ubuntu0.20.04.3 (Ubuntu)
Steps to Reproduce
Installation should be updated from MySQL 5.7 to 8 and upgrade from 5.x to 5.60.0 and then to 5.86.2. Database collation is updated to utf8mb4_0900_ai_ci. Update to latest version.
Ghost Version
5.60.0
Node.js Version
v18.20.3
How did you install Ghost?
Ubuntu 18.04 upgraded to 20.04, manual installation
Database type
MySQL 8
Browser & OS version
Version 126.0.6478.115 (Official Build) / Windows 11
Relevant log / error output
Code of Conduct