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

[liomj]

Unable to install suico. Error(s):

Installing Social Network

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

Latest from github suico

XOOPS Version	XOOPS 2.5.11-Beta2
PHP Version	7.4.29
MySQL Version	5.5.5-10.4.24-MariaDB

[mambax7]

Which one was it?
When you get this kind of a message, please look at the "Queries" and it will show you in red which exactly table caused that issue.

[liomj]

0.000222 - CREATE TABLE suico_profile_regstep ( step_id SMALLINT(3) UNSIGNED NOT NULL AUTO_INCREMENT, step_name VARCHAR(255) NOT NULL DEFAULT '', step_desc TEXT, step_order SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0', step_save TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (step_id), KEY sort (step_order, step_name) ) ENGINE = MyISAM
Error number: 1071
Error message: Specified key was too long; max key length is 1000 bytes

error when installing

[mambax7]

Fixed in 7fc67ed