mySQL error

My website URL is: CLinks.cf

What I’m seeing is: #1071 - Specified key was too long; max key length is 1000 bytes

I’m using this software:MySQL

Additional information: whenever i install my script i get this error : #1071 - Specified key was too long; max key length is 1000 bytes

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.

The error means that your website requires the InnoDB storage engine for MySQL, but that’s not available on free hosting.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.