I was able to create another migration to drop that database and create it again with no indexes on these text fields. Once I did this all appears to be well.
Thanks Will On Mar 9, 5:52 pm, bill walton <[email protected]> wrote: > Hi Will, > > On Mon, 2009-03-09 at 15:42 -0700, Will wrote: > > When I run a rake db:prepare. I see this message "Mysql::Error: > > #42000BLOB/TEXT column 'short_description' used in key specification > > without a key length: CREATE INDEX 'short_description' on cached_cars > > ('short_description') > > MySQL requires an indexed field have a length and blobs don't support > it. I can't recall right off the top of my head what the max length is, > but we fought this same issue at my last on-site gig. > > Good luck, > Bill --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
