search

processwire / processwire-issues

ProcessWire issue reports.
44 stars 2 forks source link

Installing a site profile with utf8mb4 formatting fails #1914

Open jploch opened 2 months ago

jploch commented 2 months ago

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

jjozsi commented 4 weeks ago

I confirm that this error can be replicated, I thought it was only me. Selecting ut8mb4 when installing with a profile that's been previously exported using the site profile exporter results in the error 1115 Unknown character set: 'utf8mb4mb4' It happens every time. UT8 is also not an option because of another error message: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes which can only be solved by manually changing every table to innoDB in the database dump before installing.