SQLSTATE[42000]

[heitu]

SQLSTATE[42000]：语法错误或访问冲突：1071 指定的键太长；最大密钥长度为 767 字节

错误​

SQL查询：

ALTER TABLE chv_ip_bans MODIFY ip_ban_ip varchar(255) NOT NULL


MySQL 返回：
#1071 - 指定的密钥太长；最大密钥长度为 767 字节

 

[Rodolfo]

Dear user,

Kindly review the system requirements for the MySQL database storage engine.

System Requirements | V3 Docs

Documentation for Chevereto image hosting software (V3)

v3-docs.chevereto.com

You need to switch your MyIsam tables to InnoDB.

 

[Rodolfo]

Dear heitu,

Unfortunately, this ticket has more than 14 days without a reply or feedback from you. We will now consider this ticket abandoned and its now closed.

Please, don't hesitate to create a new ticket if this matter is still causing you trouble. If this is already solved you can ignore this message.