search for: 42000blob

I have a test environment running rails 1.2.3. I am just starting to introduce testing into this project. 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'') The initial migration from the product displays this: []#rake db:test:prepare --trace (in /v...

For those of you out there using export/collect (which we really need to come up with a better name for...), can you test the current SVN code? I''m mostly wondering if the performance is any better. To use it, you''ll have to remove your current database, since the database schema is significantly changed. I''m getting what looks like an additional 25% reduction

.... Here is the table definition from my migration file. create_table "strings", :force => true do |t| t.column "string", :text, :null => false end However, when I try to run the Rake target to run my unit tests, I get the following error. Mysql::Error: #42000BLOB/TEXT column ''string'' can''t have a default value: CREATE TABLE strings (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `string` text DEFAULT '''' NOT NULL) ENGINE=InnoDB Can anone tell me what''s going on here? I can figure out ho...