SQL ERROR [ mysql ]

BLOB column 'ban_email' used in key specification without a key length [1170]

SQL

CREATE TABLE area51_banlist( ban_id mediumint(8) unsigned NOT NULL auto_increment, ban_userid mediumint(8) unsigned DEFAULT '0' NOT NULL, ban_ip varchar(40) DEFAULT '' NOT NULL, ban_email text DEFAULT '' NOT NULL, ban_start int(11) unsigned DEFAULT '0' NOT NULL, ban_end int(11) unsigned DEFAULT '0' NOT NULL, ban_exclude tinyint(1) unsigned DEFAULT '0' NOT NULL, ban_reason text DEFAULT '' NOT NULL, ban_give_reason text DEFAULT '' NOT NULL, PRIMARY KEY (ban_id), KEY ban_end (ban_end), KEY ban_user (ban_userid, ban_exclude), KEY ban_email (ban_email, ban_exclude), KEY ban_ip (ban_ip, ban_exclude) )

BACKTRACE

FILE: includes/db/mysql.php

LINE: 130

CALL: dbal->sql_error()

FILE: includes/acp/acp_database.php

LINE: 1272

CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php

LINE: 361

CALL: acp_database->main()

FILE: adm/index.php

LINE: 83

CALL: p_master->load_active()