Score:0

Message: Specified key was too long; max key length is 1000 bytes Code: 1071

be flag

am getting the this error when i try run a installer on my forum:

Message: Specified key was too long; max key length is 1000 bytes Code: 1071

any helps appreciated

edit:

Server type: MySQL Server version: 8.0.26-0ubuntu0.20.04.3 - (Ubuntu) Server charset: UTF-8 Unicode (utf8mb4)

Apache/2.4.41 (Ubuntu) PHP version: 7.4.3 phpmyadmin 4.9.5deb2

i get the error after running a installer for a module for nuke evolution extreme 2.0.9f

be flag
ive tried to run it in SQL instead of the installer: QL query: CREATE TABLE IF NOT EXISTS `nuke_clanmanager_games` ( `gid` int(11) NOT NULL AUTO_INCREMENT, `appid` VARCHAR(255) NOT NULL DEFAULT '', `default` tinyint(2) NOT NULL DEFAULT '0', `icon` VARCHAR(255) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `abbr` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`gid`), KEY `title` (`title`) ) ENGINE=MyISAM MySQL said: Documentation #1071 - Specified key was too long; max key length is 1000 bytes
ru flag
What forum software? What are you trying to install? What server is this running on? What application/scripting language is at play? Are you using Ubuntu as your base server OS? We need a lot more information to even begin to help you here.
be flag
the team at evo extreme suggest removing KEY `title` (`title`), it installed after that. thanks
be flag
Server type: MySQL Server version: 8.0.26-0ubuntu0.20.04.3 - (Ubuntu) Server charset: UTF-8 Unicode (utf8mb4) Apache/2.4.41 (Ubuntu) PHP version: 7.4.3 phpmyadmin 4.9.5deb2 i get the error after running a installer for a module for nuke evolution extreme 2.0.9f
Will avatar
id flag
Please edit your question with the details requested in the comments.
ru flag
@Joe83 add that into your question as an edit. You also didn't indicate what 'forum' software you're using, is this installer to install the entire forum or just a single module? It sounds like this is a forum-level problem with that module, unless you can provide a screenshot or details of the **entire exact error message** and how you got there I'm not sure we're going to be able to help much.
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.