Rails db:migrate fails with SQL error

Question

rake db:migrate is failing on my production server, the error is:

Mysql2::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' at line 1: 'ALTER TABLE looks' ADD 'code' String

My migration code is:

class AddCodeToLook < ActiveRecord::Migration
  def self.up
    add_column :looks, :code, :String #failing line
  end

  def self.down
    remove_column :looks, :code
  end
end

twilson · Accepted Answer · 2011-09-22 21:25:53Z

3

Try :string and not :String

answered Sep 22, 2011 at 21:25

twilson

2,06214 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Marcel M. Over a year ago

Oh, man I didn't even noticed, strangely it worked on sqlite. Thank you so much, I'm really grateful!

twilson Over a year ago

Sometimes you can bang your head against these tiny little mistakes for ages and you either figure it out eventually, or someone else spots it instantly :P

Peter Brown · Accepted Answer · 2011-09-22 21:26:07Z

0

Not sure if that's just a typo, but :String should be :string in your add_column line.

When you add a column like this, you can use the built-in rails generator to handle the grunt work:

rails g migration AddCodeToLook code:string

answered Sep 22, 2011 at 21:26

Peter Brown

51.8k18 gold badges116 silver badges147 bronze badges

Comments

Platinum Azure · Accepted Answer · 2011-09-22 21:26:19Z

0

Per this official Rails documentation, it looks like the issue is that you're not using the right casing for the data type. You should be using :string.

class AddCodeToLook < ActiveRecord::Migration
  def self.up
    add_column :looks, :code, :string
  end

  def self.down
    remove_column :looks, :code
  end
end

answered Sep 22, 2011 at 21:26

Platinum Azure

46.4k13 gold badges112 silver badges136 bronze badges

Collectives™ on Stack Overflow

Rails db:migrate fails with SQL error

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related