p8cSP20G

1#1170 - BLOB/TEXT column 'bestilling' used in key specification without a key length 
2     
3CREATE TABLE IF NOT EXISTS `bestillinger` (
4  `id` int(11) NOT NULL,
5  `bestilling` TEXT NOT NULL PRIMARY KEY,
6  `accepted` varchar(255) DEFAULT NULL,
7  UNIQUE KEY `id_bestilling` (`id`,`bestilling`)
8) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
9     
10CREATE TABLE IF NOT EXISTS `bestillinger` (
11  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
12  `bestilling` TEXT NOT NULL,
13  `hashcode` CHAR(32) AS (MD5(bestilling)),  
14  `accepted` VARCHAR(255) DEFAULT NULL,
15  UNIQUE KEY `id_bestilling` (hashcode,bestilling(333))
16) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
17     
18CREATE TABLE IF NOT EXISTS `bestillinger` (
19  `id` int(11) NOT NULL,
20  `bestilling` TEXT NOT NULL PRIMARY KEY,
21  `accepted` varchar(255) DEFAULT NULL,
22  UNIQUE KEY `id_bestilling` (`id`,`bestilling`(767))
23) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
24     
25mysql> desc users;
26+-------------+-------------+------+-----+---------+----------------+
27| Field       | Type        | Null | Key | Default | Extra          |
28+-------------+-------------+------+-----+---------+----------------+
29| id          | int(11)     | NO   | PRI | NULL    | auto_increment |
30| fname       | varchar(50) | NO   |     | NULL    |                |
31| lname       | varchar(50) | NO   |     | NULL    |                |
32| uname       | varchar(20) | NO   |     | NULL    |                |
33| email       | text        | NO   |     | NULL    |                |
34| contact     | bigint(12)  | NO   |     | NULL    |                |
35| profile_pic | text        | NO   |     | NULL    |                |
36| password    | varchar(20) | NO   |     | admin   |                |
37+-------------+-------------+------+-----+---------+----------------+
388 rows in set (0.00 sec)
39
40mysql> ALTER TABLE users ADD UNIQUE(email);
41ERROR 1170 (42000): BLOB/TEXT column 'email' used in key specification without a key length
42mysql> 
43mysql> ALTER  TABLE users MODIFY email VARCHAR(254);
44Query OK, 9 rows affected (0.02 sec)
45Records: 9  Duplicates: 0  Warnings: 0
46
47mysql> ALTER TABLE users ADD UNIQUE(email);
48Query OK, 0 rows affected (0.02 sec)
49Records: 0  Duplicates: 0  Warnings: 0
50
51mysql> desc users;
52+-------------+--------------+------+-----+---------+----------------+
53| Field       | Type         | Null | Key | Default | Extra          |
54+-------------+--------------+------+-----+---------+----------------+
55| id          | int(11)      | NO   | PRI | NULL    | auto_increment |
56| fname       | varchar(50)  | NO   |     | NULL    |                |
57| lname       | varchar(50)  | NO   |     | NULL    |                |
58| uname       | varchar(20)  | NO   |     | NULL    |                |
59| email       | varchar(254) | YES  | UNI | NULL    |                |
60| contact     | bigint(12)   | NO   |     | NULL    |                |
61| profile_pic | text         | NO   |     | NULL    |                |
62| password    | varchar(20)  | NO   |     | admin   |                |
63+-------------+--------------+------+-----+---------+----------------+
648 rows in set (0.00 sec)
65
66mysql>