I hate to have to post another ticket, but I thought maybe you guys have a quick answer you could provide.
Siteground simply updated the PHP version, but that doesn't seem to work. character set is utf8mb4 and collation is utf8mb4_unicode_ci, but all hte tables are a mixed bag of utf8_unicode_ci, utf8mb4_unicode_ci and utf8mb4_unicode_ci. Running the database check and upgrade tools in MAMP indicates everything is OK. When transferring to host I get what seems like an erorr from long ago after reading the other tickets on akeebabackup,com for error #1071
Database restoration
An error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.
Database error processing line 240
Database server error reply:
ErrNo #1071
Specified key was too long; max key length is 767 bytes
SQL=CREATE TABLE `xxxxx_akeeba_common` ( `key` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL, `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Raw query text:
CREATE TABLE `#__akeeba_common` ( `key` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL, `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Siteground simply updated the PHP version, but that doesn't seem to work. character set is utf8mb4 and collation is utf8mb4_unicode_ci, but all hte tables are a mixed bag of utf8_unicode_ci, utf8mb4_unicode_ci and utf8mb4_unicode_ci. Running the database check and upgrade tools in MAMP indicates everything is OK. When transferring to host I get what seems like an erorr from long ago after reading the other tickets on akeebabackup,com for error #1071
