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: [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]
