# Installing rails in vendor messes up migrations

**URL:** <https://www.ruby-forum.com/t/installing-rails-in-vendor-messes-up-migrations/110409>\
**Category:** Rails\
**Created:** [July 26, 2007, 2:41am UTC](https://www.ruby-forum.com/t/installing-rails-in-vendor-messes-up-migrations/110409 "2007-07-26T02:41:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![nola](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/eb9ed0/32.png) [@nola](https://www.ruby-forum.com/u/nola)\
**Post date:** [July 26, 2007, 2:41am UTC](https://www.ruby-forum.com/t/installing-rails-in-vendor-messes-up-migrations/110409/1 "2007-07-26T02:41:38Z")

</div>

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.