• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • 😌 This community is user driven. Be polite with other users.
    • 👉 Is required to purchase a Chevereto license to participate in this community (doesn't apply to Pre-sales).
    • 💸 Purchase a Pro Subscription to get access to active software support and faster ticket response times.
  • Chevereto Support CLST

    Support response

    Support checklist

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

Logan

Chevereto Member
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


Code:
[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
 
 
Back
Top