processwire-issues
processwire-issues copied to clipboard
Installing a site profile with utf8mb4 formatting fails
Short description of the issue
Installing a site profile that has uft8mb4 database formatting fails, when also choosing uft8mb4 formatting on install.
Expected behavior
Installing a profile with uft8mb4 formatting works.
Actual behavior
The installer shows many errors and installation fails. The errors show a weird utf8mb4mb4 message like this:
SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: 'utf8mb4mb4'
If I keep default utf8 settings, I can install the utf8mb4 formatted site, but the fields containing emoticons are empty.
Steps to reproduce the issue
- Install ProcessWire with the blank site profile and choose utf8mb4 formatting
- Install ProcessExportProfile module and export the site profile
- Install the new site profile and choose utf8mb4 formatting
Setup/Environment
- ProcessWire 3.0.229
- Export Site Profile 5.0.1
- PHP 8.2: