Re: Fulltext Index with schema console

2009-08-24 Thread miceno
I also has this problem, The issue is that "schema generate" does not create valid MySQL syntax to create the appropriate tables. I know how to generate the right MySQL syntax, but I would like to know how to automatically generate a valid CakePHP file schema. Or is it a bug of "schema generate"

Re: Fulltext Index with schema console

2009-08-19 Thread PaSToReT
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 t

Re: Fulltext Index with schema console

2009-08-18 Thread brian
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 wrote: > > Hi! > > I have this table in mysql: > > CREATE TABLE `search_index` ( >  `id` int(11) NOT NULL auto_increment, >  `associ