MySQL imposes a limitation on index lenghts, that varies a bit depending what character encoding is used. Basically the statements are telling MySQL to index a character field that is bigger than the limit on a table, either by adding a new field on a table and trying to index it or by creating a new table with that index. To fix it, the field being indexed needs to have a specified size below the limit. For example if the field is used for a status name like ‘created’, ‘updated’ or whatever, you can limit the varchar to 32 and index it. If it’s for a hash you can determine what sizes the hashes will be and limit to 128 or 256, and so on.
Hope it helps.
(not an admin or anything by the way)
Maybe your script has some key that is too long than 1000 bytes, and doesn’t install. Try other alternatives to your script, or if it’s a cracked script, please uninstall it immediately. The scripts that are not compatible with this hosting (examples: image hosting softwares and video hosting softwares) are removed from their installation of Softaculous on their cPanel.