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

how to solve ?

 

[yuttakarn]

plesae help

• CLI:/var/www/vhosts/img/httpdocs/cli.php
• PHP version: 8.0.7 /var/www/vhosts/system/imgz/etc/php.ini

 

[JakeSully]

Chevereto does not support PHP 8.0 yet, you will have to use 7.4 for now. Also latest version requires Mysql 8.0+ or MariaDB 10+

 

[kissnavel]

Chevereto V3 won't support PHP 8 , you need to downgrade to PHP 7.4.

 

[guzzisti]

Although you should downgrade your PHP installation as well, this alone won't fix the error.

As JakeSully mentions you'll probably need to upgrade your MySQL/MariaDB installation and make sure the tables use the "DYNAMIC" row format: https://dev.mysql.com/doc/refman/8.0/en/innodb-limits.html

 

[Rodolfo]

You are using 18.04, need to use Focal packages (20.04). Also check the storage engine.