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: [email protected] 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/[email protected]
