Specified key was too long; max key length is 767 bytes

[Logan]

Hi
I have updated my chevereto to version 3.20.1.
My server has MySQL 5.6.44 and PHP 7.3.24 with NGINX.
After the upgrade, it shows me some errors and to update SQL query to MySQL.
all queries had applied, even to Trunch table chv_assets.
But after that, i am unable to run CRERE TABLE chv_assets on SQL Query

CREATE TABLE chv_assets (
asset_id bigint(32) NOT NULL AUTO_INCREMENT,
asset_key varchar(255) NOT NULL,
asset_md5 varchar(32) NOT NULL,
asset_filename varchar(255) NOT NULL,
asset_file_path varchar(255) NOT NULL,
asset_blob blob,
PRIMARY KEY (asset_id),
UNIQUE KEY key (asset_key) USING BTREE,
KEY md5 (asset_md5),
KEY filename (asset_filename),
KEY file_path (asset_file_path)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

I am seeing this error

[HEADING=2]Error[/HEADING]
SQL query: Copy

CREATE TABLE `chv_assets` (
 `asset_id` bigint(32) NOT NULL AUTO_INCREMENT,
 `asset_key` varchar(255) NOT NULL,
 `asset_md5` varchar(32) NOT NULL,
 `asset_filename` varchar(255) NOT NULL,
 `asset_file_path` varchar(255) NOT NULL,
 `asset_blob` blob,
 PRIMARY KEY (`asset_id`),
 UNIQUE KEY `key` (`asset_key`) USING BTREE,
 KEY `md5` (`asset_md5`),
 KEY `filename` (`asset_filename`),
 KEY `file_path` (`asset_file_path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

MySQL said:

#1071 - Specified key was too long; max key length is 767 bytes

Please Help..
Thanks

 

[siddharth]

Please read the document, https://v3-docs.chevereto.com/setup/system/requirements.html#database

You need to have MySQL 8 or MariDB 10 +

 

[Logan]

Please read the document, https://v3-docs.chevereto.com/setup/system/requirements.html#database

You need to have MySQL 8 or MariDB 10 +

but why?
I can't update DB at the moment due to some restriction,
@Rodolfo Please help me out

 

[Rodolfo]

but why?

Because of emoji support 😅 older versions doesn't handle well indexes with utf8mb4 chars.

 

[Rodolfo]

Must read - Re: MySQL issues V3.20

Hey there, If you have one of these: Error SQL query: Copy CREATE TABLE `chv_assets` ( `asset_id` bigint(32) NOT NULL AUTO_INCREMENT, `asset_key` varchar(255) NOT NULL, `asset_md5` varchar(32) NOT NULL, `asset_filename` varchar(255) NOT NULL, `asset_file_path` varchar(255) NOT NULL...

chevereto.com