processwire-issues icon indicating copy to clipboard operation
processwire-issues copied to clipboard

Installing a site profile with utf8mb4 formatting fails

Open jploch opened this issue 1 month ago • 0 comments

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

  1. Install ProcessWire with the blank site profile and choose utf8mb4 formatting
  2. Install ProcessExportProfile module and export the site profile
  3. Install the new site profile and choose utf8mb4 formatting

Setup/Environment

  • ProcessWire 3.0.229
  • Export Site Profile 5.0.1
  • PHP 8.2:

jploch avatar May 02 '24 08:05 jploch