Home Forums Template Support Install Error

Viewing 4 posts - 1 through 4 (of 4 total)
  • Avatar
    Javier Comba
    Subscriber

    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 ef7om_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

    Avatar
    Tony
    Moderator

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

    Avatar
    Antonino Parisi
    Subscriber
    This reply has been marked as private, meaning that only the original poster and forum moderators can see the content of the reply.
    Avatar
    Tony
    Moderator

    Glad your problem is solved

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

You must be logged in to reply to this topic.