Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Installing a site profile with utf8mb4 formatting fails #1914

Open
jploch opened this issue May 2, 2024 · 0 comments
Open

Installing a site profile with utf8mb4 formatting fails #1914

jploch opened this issue May 2, 2024 · 0 comments

Comments

@jploch
Copy link

jploch commented May 2, 2024

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:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants