Problem updating database in latest version

[yuttakarn]

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

Server type	Host name	Port	Version	Databases	version
		MariaDB	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

 

[Rodolfo]

Chevereto V3.20 doesn't not support PHP 8, only PHP 7.4

The reported issue seems to be related to an older mysql version. What you report is not a behavior present in MariaDB 10.

 

[yuttakarn]

Chevereto V3.20 doesn't not support PHP 8, only PHP 7.4

The reported issue seems to be related to an older mysql version. What you report is not a behavior present in MariaDB 10.

i try use php 7.4 not working and 8.0 not working

 

[yuttakarn]

 

[yuttakarn]

 

[Rodolfo]

Dear, use mariadb 10 Focal. You are using 18.04. I've explicit indicate that Chevereto 3.20 was designed for Focal packaging.