I''ve searched all over the web and mailing lists and can''t find any info on this problem. I have a site built with Rails 1.1.6 I ran rake rails:freeze:edge TAG=rel_1-2-3 I ran db:migrate (on a fresh database) rake db:migrate VERSION=1 --trace (in /home/nola/projects/tardis/website/trunk) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate == AddContact: migrating =====================================================-- create_table(:contacts) rake aborted! Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''string DEFAULT NULL, `city` string DEFAULT NULL) ENGINE=InnoDB'' at line 1: CREATE TABLE contacts (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY DEFAULT NULL, `name` string DEFAULT NULL, `city` string DEFAULT NULL) ENGINE=InnoDB /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:243:in `execute'' /home/nola/projects/tardis/website/trunk/config/../vendor/plugins/mysql_bigint/lib/mysql_bigint.rb:32:in `create_table'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:353:in `create_table'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/migration.rb:275:in `method_missing'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/migration.rb:259:in `say_with_time'' /usr/lib/ruby/1.8/benchmark.rb:293:in `measure'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/migration.rb:259:in `say_with_time'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/migration.rb:273:in `method_missing'' ./db/migrate//001_add_contact.rb:3:in `real_up'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/migration.rb:212:in `migrate'' /usr/lib/ruby/1.8/benchmark.rb:293:in `measure'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/migration.rb:212:in `migrate'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/migration.rb:335:in `migrate'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/migration.rb:330:in `migrate'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/migration.rb:297:in `up'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/activerecord/lib/active_record/migration.rb:288:in `migrate'' /home/nola/projects/tardis/website/trunk/config/../vendor/rails/railties/lib/tasks/databases.rake:4 /usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke'' /usr/lib/ruby/1.8/thread.rb:135:in `synchronize'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top_level'' /usr/lib/ruby/gems/1.8/gems/rake- 0.7.3/lib/rake.rb:1739:in `top_level'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in `standard_exception_handling'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1733:in `top_level'' /usr/lib/ruby/gems/1.8/gems/rake- 0.7.3/lib/rake.rb:1711:in `run'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in `standard_exception_handling'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in `run'' /usr/lib/ruby/gems/1.8/gems/rake- 0.7.3/bin/rake:7 /usr/bin/rake:1 ---------------------------- SO Basically, its trying to put in a sql create statement like this: CREATE TABLE contacts ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY DEFAULT NULL, `name` string DEFAULT NULL, `city` string DEFAULT NULL ) ENGINE=InnoDB string? when it should put in VARCHAR(255) .. weird huh? Here''s the migration: class AddContact < ActiveRecord::Migration def self.up create_table :contacts do |t| t.column :name, :string t.column :city, :string end end def self.down drop_table :contacts end Any ideas? I''ve also tried with rel_1-2-0 too... and get the same result. I can create a table with ints or no fields just fine. When I remove vendor/rails then its fine. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---