Home Forums Template Support Specified key was too long

Viewing 4 posts - 1 through 4 (of 4 total)
  • 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

    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 ?

    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

    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.