If you read my post, I said:
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.
Of course, I have searched before. I know how to solve this problem in
mysql (adding the key length when you define the index), but I would
like to have a good executable schema.php for my migrations, and i
don't know how to add this parameter to it.
May be I'm not explaining so well... sorry... :(
Thank you anyway!
On Aug 18, 8:17 pm, brian <[email protected]> wrote:
> This is a MySQL issue. Did you search
> first?http://www.google.ca/search?q=used+in+key+specification+without+a+key...
>
> 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
-~----------~----~----~----~------~----~------~--~---
