Specified key was too long

Viewing 4 posts - 1 through 4 (of 4 total)

Konstantin Timofeev
Subscriber

Posted 6 years ago

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
Moderator

Posted 6 years ago

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
Subscriber

Posted 6 years ago

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
Moderator

Posted 6 years ago

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

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.