processwire
Cant install the latest DEV (nearly MASTER) with a profile exported from ProcessExportProfile
It seems with the latest changes to install.php I cannot install a profile which was exported using ProcessExportProfile. After entering the database details I get this message:
SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8mb3'
Server connection collation: utf8mb4_unicode_ci
Database collation: utf8mb4_general_ci
Upon some digging, the site-blank profile contains this in install.sql for all tables:
ENGINE=MyISAM DEFAULT CHARSET=utf8;
My profile exported from ProcessExportProfile contains this in install.sql for all tables:
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8mb4_general_ci;
Doing a find and replace on the COLLATE=utf8mb4_general_ci; and changing it to blank, I was able to install using my profile. The weird thing is, the error from the installer mentions utf8mb3 which doesn't make sense.
