This is a MySQL issue. Did you search first? http://www.google.ca/search?q=used+in+key+specification+without+a+key+length
On Tue, Aug 18, 2009 at 12:05 PM, PaSToReT<[email protected]> wrote: > > Hi! > > I have this table in mysql: > > CREATE TABLE `search_index` ( > `id` int(11) NOT NULL auto_increment, > `association_key` varchar(36) collate utf8_unicode_ci NOT NULL, > `model` varchar(128) collate utf8_unicode_ci NOT NULL, > `data` longtext collate utf8_unicode_ci NOT NULL, > `created` datetime NOT NULL, > `modified` datetime NOT NULL, > PRIMARY KEY (`id`), > KEY `association_key` (`association_key`,`model`), > FULLTEXT KEY `data` (`data`) > ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 > COLLATE=utf8_unicode_ci; > > I have generated a schema.php with 'cake schema generate'. > When I try to execute it ('cake schema run create') i get this error. > > search_index: 1170: BLOB/TEXT column 'data' used in key specification > without a key length > > I know that it is because of the key length is not specified in the > schema.php, but I don't know how to do it. > > Could anyone help me? > > Thanks a lot! > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
