错误SQL 查询:CREATE TABLE zen_configuration(
configuration_id int( 11 ) NOT NULL AUTO_INCREMENT ,
configuration_title text NOT NULL ,
configuration_key varchar( 255 ) NOT NULL ,
configuration_value text NOT NULL ,
configuration_description text NOT NULL ,
configuration_group_id int( 11 ) NOT NULL ,
sort_order int( 5 ) ,
last_modified datetime,
date_added datetime DEFAULT '0001-01-01 00:00:00' NOT NULL ,
use_function text,
set_function text,
PRIMARY KEY ( configuration_id ) ,
KEY unq_config_key_zen( configuration_key ) ,
KEY idx_key_value_zen( configuration_key, configuration_value ) ,
KEY idx_cfg_grp_id_zen( configuration_group_id )
);MySQL 返回:文档
#1170 - BLOB/TEXT column 'configuration_value' used in key specification without a key length
我重另外一台服务器 备份下来 utf8编码这些都没错 但是为什么我导入新的服务器里面就出现这样的情况 在线求解
configuration_id int( 11 ) NOT NULL AUTO_INCREMENT ,
configuration_title text NOT NULL ,
configuration_key varchar( 255 ) NOT NULL ,
configuration_value text NOT NULL ,
configuration_description text NOT NULL ,
configuration_group_id int( 11 ) NOT NULL ,
sort_order int( 5 ) ,
last_modified datetime,
date_added datetime DEFAULT '0001-01-01 00:00:00' NOT NULL ,
use_function text,
set_function text,
PRIMARY KEY ( configuration_id ) ,
KEY unq_config_key_zen( configuration_key ) ,
KEY idx_key_value_zen( configuration_key, configuration_value ) ,
KEY idx_cfg_grp_id_zen( configuration_group_id )
);MySQL 返回:文档
#1170 - BLOB/TEXT column 'configuration_value' used in key specification without a key length
我重另外一台服务器 备份下来 utf8编码这些都没错 但是为什么我导入新的服务器里面就出现这样的情况 在线求解
-> configuration_id int( 11 ) NOT NULL AUTO_INCREMENT ,
-> configuration_title text NOT NULL ,
-> configuration_key varchar( 255 ) NOT NULL ,
-> configuration_value text NOT NULL ,
-> configuration_description text NOT NULL ,
-> configuration_group_id int( 11 ) NOT NULL ,
-> sort_order int( 5 ) ,
-> last_modified datetime,
-> date_added datetime DEFAULT '0001-01-01 00:00:00' NOT NULL ,
-> use_function text,
-> set_function text,
-> PRIMARY KEY ( configuration_id ) ,
-> KEY unq_config_key_zen( configuration_key ) ,
-> KEY idx_key_value_zen( configuration_key, configuration_value(100) ) ,
-> KEY idx_cfg_grp_id_zen( configuration_group_id )
-> );
Query OK, 0 rows affected (0.30 sec)