yuttakarn
Chevereto Member
i use php 8.0 issue error
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 has said:
#1071 - Key declaration too long. Maximum key length is 767
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 has said:
#1071 - Key declaration too long. Maximum key length is 767
Server type | Host name
| Port | Version | Databases | version |
---|---|---|---|---|---|
localhost (default for MariaDB) | 3306 | 10.1.48 |
- CLI:/var/www/vhosts/img/httpdocs/cli.php
- PHP version: 8.0.7 /var/www/vhosts/system/imgz/etc/php.ini