Project

General

Profile

Actions

Bug #101719

closed

Environment Status reports: MySQL database character set check failed

Added by Timo Gurr over 1 year ago. Updated 5 months ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
AdminPanel
Target version:
-
Start date:
2023-08-21
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
11
PHP Version:
8.1
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

After upgrading MariaDB of an existing installation currently at TYPO3 LTS 11.5.30 from MariaDB 10.5.21 to MariaDB 10.11.4 the TYPO3 Environment Status now reports:

MySQL database character set check failed
Checking database character set failed, got key "utf8mb3" instead of "utf8 or utf8mb4" 

https://get.typo3.org/version/11#system-requirements lists MariaDB >= 10.2.7 <= 10.11.99

According to

https://mariadb.com/kb/en/unicode/
https://stackoverflow.com/questions/63414060/is-utf8-in-mariadb-still-utf8mb3

utf8 is an alias for utf8mb3 on MariaDB >= 10.6 and until MariaDB 10.5 utf8mb3 was an alias for utf8. From MariaDB 10.6, utf8 is by default an alias for utf8mb3 - if I got things right.

So for example phpMyAdmin shows the following collation for the TYPO3 database:

before upgrade: MariaDB 10.5.21 - utf8_general_ci
after upgrade: MariaDB 10.11.4 - utf8mb3_general_ci

TYPO3 11.5.30 currently probably only checks for the strings "utf8" and "utf8mb4" and thus complains about "utf8mb3" not knowing it's actually still plain "utf8" on MariaDB 10.11.4(?).


Files

typo3_11530_mariadb_1011.png (32.2 KB) typo3_11530_mariadb_1011.png screenshot_environment_status_error_message Timo Gurr, 2023-08-21 09:22
Actions #1

Updated by Timo Gurr over 1 year ago

  • Subject changed from MySQL database character set check failed to Environment Status reports: MySQL database character set check failed
Actions #2

Updated by Gerrit Code Review over 1 year ago

  • Status changed from New to Under Review

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/80632

Actions #3

Updated by Gerrit Code Review over 1 year ago

Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/80632

Actions #4

Updated by Gerrit Code Review over 1 year ago

Patch set 1 for branch 12.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/80615

Actions #5

Updated by Gerrit Code Review over 1 year ago

Patch set 1 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/80616

Actions #6

Updated by Timo Gurr over 1 year ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #7

Updated by Benni Mack 5 months ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF