On Jul 4, 2011, at 4:27 AM, James McCluskey wrote:

> When setting up the recipes table I got the following MySql error.

>

> #

>

> CREATE TABLE `recipes` (

> `id` int(11) not null auto_increment,

> `title` varchar(240) not null,

> `subtitle` longtext not null,

> `ingred` longtext not null,

> `proced` longtext not null,

> `date` date not null default '0000-00-00',

> `image` varchar(240) not null,

> PRIMARY KEY (`id`),

> KEY `ctitle` (`title`),

> KEY `ddate` (`date`),

> KEY `ft` (`title`,`subtitle`,`ingred`,`proced`)

> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2685;

>

> The following errors were reported:BLOB/TEXT column 'subtitle' used in

> key specification without a key length

>

> #

>

> Can anybody suggest a solution?

I'm not sure why the `ft` key is defined that way; I can't see any benefit to indexing on ingredients or procedure text. I would change subtitle to varchar(240) to match title, and drop the last two columns from the `ft` index.

-- Ed Leafe

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/2DD56B52-F44F-48CF-87B5-133AC59A721F@leafe.com