On 7/4/11 4:13 AM, Ed Leafe wrote:

> 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.

It was a fulltext index that was in use on the live site in the 1990's. No need for

it now, so just drop that key.

Paul

_______________________________________________

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/4E5D30E8.7070004@ulmcnett.com