[dabo-users] BLOB/TEXT column 'subtitle' used in key specification without a key length

I'm just getting started with "Dabo" and I thought it would be

convenient to have a copy of the pycon 2010 database on my localhost

(hope this is not an issue).

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?

Regards

James McCluskey

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: Dabo-users@leafe.com