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