What happened?
Cannot get Craft CMS 5 up and running on my local machine despite using the new DB encoding standard.
Using Mariadb from 11.2.2
CREATE TABLE `Test` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
Dispite doing this, I get the following message when upgrading or creating a fresh DB.
Caused by: Exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb3_unicode_ci' is not valid for CHARACTER SET 'utf8mb4''
Using MariaDB
Craft CMS version
5.0.0 beta 1
PHP version
PHP 8.2.15
Operating system and version
MacOS 14.2 Sanoma
Database type and version
MariaDB 11.2.2
Image driver and version
No response
Installed plugins and versions
What happened?
Cannot get Craft CMS 5 up and running on my local machine despite using the new DB encoding standard.
Using Mariadb from 11.2.2
Dispite doing this, I get the following message when upgrading or creating a fresh DB.
Caused by: Exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb3_unicode_ci' is not valid for CHARACTER SET 'utf8mb4''
Using MariaDB
Craft CMS version
5.0.0 beta 1
PHP version
PHP 8.2.15
Operating system and version
MacOS 14.2 Sanoma
Database type and version
MariaDB 11.2.2
Image driver and version
No response
Installed plugins and versions