Database Error Inova Template (Joomla)

Home › Forums › Support › Database Error Inova Template (Joomla)

Tagged: , ,

Robert Khaemba
Posted 6 years ago

Hi,

I am getting the attached error when trying to use Inova quickstart.


Database server error reply:

ErrNo #1071

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

Kindly assist

Thank you

Brian
Posted 6 years ago

Hi Robert,
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

You must be logged in to reply to this topic.