Specified key was too long

[Konstantin Timofeev]

Hello, help me please!
I bought the pattern when you install
JL-Kidsacademy-Joomla3x-QuickStart-1.0.1
an error appeared:

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 40
Database server error reply:

ErrNo #1071
Specified key was too long; max key length is 767 bytes
SQL=CREATE TABLE tanc_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

[Tony]

Hi there,
Which Mysql version are you using ? Same issue related to this case https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes
Could you please provide the site info via ticket system https://joomlead.com/ticket-support/ so I can take a look ?

[Hector R Altamirano A]

HI
I have the same problem too, with diferents themes, spirit, ifolio, lucian and kickoff. I try to install in local offline with xampp 7.2 php

[Tony]

Hi Hector,
It seems your server does not support the modern UTF8MB4 encoding. For this case, please check two options “Force UTF8” while restoring the package, like so https://imgur.com/a/dRURofp