php - 错误; #1071 - 指定的 key 太长；最大 key 长度为 1000 字节

Question

我尝试直接从 phpMyAdmin 导入，但不断收到如下错误响应:

Error

SQL query:

-- -- Indexes for table configurations -- ALTER TABLE configurations ADD KEY admin_password_2 ( admin_password , admin_username , captcha , censored_words , chat ) , ADD KEY comment_character_limit_2 ( comment_character_limit , email , email_verification , friends , language , message_character_limit ) , ADD KEY reg_req_about_2 ( reg_req_about , reg_req_birthday , reg_req_currentcity , reg_req_hometown , site_name , site_title , smooth_links , story_character_limit , theme ) ;

MySQL said: Documentation

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

查看下表

表配置的表结构

CREATE TABLE IF NOT EXISTS `configurations` (
  `ad_place_hashtag` text NOT NULL,
  `ad_place_home` text NOT NULL,
  `ad_place_messages` text NOT NULL,
  `ad_place_search` text NOT NULL,
  `ad_place_timeline` text NOT NULL,
  `admin_password` varchar(255) NOT NULL DEFAULT 'xxxx',
  `admin_username` varchar(255) NOT NULL DEFAULT 'xxxx',
  `captcha` int(1) NOT NULL DEFAULT '0',
  `censored_words` varchar(255) NOT NULL DEFAULT 'racist,retard',
  `chat` int(1) NOT NULL DEFAULT '0',
  `comment_character_limit` int(10) NOT NULL DEFAULT '0',
  `email` varchar(150) NOT NULL DEFAULT 'no-reply@website.com',
  `email_verification` int(1) NOT NULL DEFAULT '0',
  `friends` int(1) NOT NULL DEFAULT '0',
  `language` varchar(50) NOT NULL DEFAULT 'english',
  `message_character_limit` int(10) NOT NULL DEFAULT '0',
  `reg_req_about` int(1) NOT NULL DEFAULT '0',
  `reg_req_birthday` int(1) NOT NULL DEFAULT '0',
  `reg_req_currentcity` int(1) NOT NULL DEFAULT '0',
  `reg_req_hometown` int(1) NOT NULL DEFAULT '0',
  `reset_time` int(12) NOT NULL,
  `site_name` varchar(150) NOT NULL DEFAULT 'Site Name',
  `site_title` varchar(150) NOT NULL DEFAULT 'Site Title',
  `smooth_links` int(1) NOT NULL DEFAULT '0',
  `story_character_limit` int(10) NOT NULL DEFAULT '0',
  `theme` varchar(100) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--

--转储表配置的数据

INSERT INTO `configurations` (`ad_place_hashtag`, `ad_place_home`, `ad_place_messages`, `ad_place_search`, `ad_place_timeline`, `admin_password`, `admin_username`, `captcha`, `censored_words`, `chat`, `comment_character_limit`, `email`, `email_verification`, `friends`, `language`, `message_character_limit`, `reg_req_about`, `reg_req_birthday`, `reg_req_currentcity`, `reg_req_hometown`, `reset_time`, `site_name`, `site_title`, `smooth_links`, `story_character_limit`, `theme`) VALUES
('', '', '', '', '', 'xxxx', 'xxxx', 1, 'racist,retard', 0, 0, 'no-reply@website.com', 0, 0, 'english', 0, 0, 0, 0, 0, 0, 'Site Name', 'Site Title', 0, 0, 'lemon');

有人可以帮助我吗？我需要绕过这个障碍。

Answer 1

这个问题有答案，会发表评论，但还没有要点呵呵。

这只是一个引擎问题，但他有一个索引部分解决方案

Mysql::Error: Specified key was too long; max key length is 1000 bytes