Home Forums Template Support Install Error

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

  • 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


    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


    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.

    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.

80+ Joomla templates updated for Joomla 5.2.2 and JoomLead particles 2.3.1 Download
Flash Sale. Get Up to 25% Off - Coupon: FLASH25 Shop Now