Rails with mysql cannot create json type column

Question

I have created Rails(3.2) application with mysql(5.7.16) backend. I can't add json type column when creating table but I can able to add json column by new migration. I have used following code in create table migration, What was wrong here ?

class CreateShoppingCartItemSpecialInfos < ActiveRecord::Migration
  def change
    create_table :shopping_cart_item_special_infos do |t|
      t.integer :shopping_cart_checkout_option_id
      t.json :special_info

      t.timestamps
    end
  end
end

Does your code return any error message? If yes, pls share it with us. — Shadow
– Shadow, Commented Dec 28, 2016 at 13:59

Blackcoat77 · Accepted Answer · 2016-12-28 14:22:20Z

3

You should be able to create JSON column type. Probably you run in couple of errors. In case there is a error after migration try first reverting it:

rake db:migrate:down VERSION=<version>

Than you can try like this:

class CreateShoppingCartItemSpecialInfos < ActiveRecord::Migration
  def change
    create_table :shopping_cart_item_special_infos do |t|
      t.integer :shopping_cart_checkout_option_id
      t.column :special_info, :json

      t.timestamps
    end
  end
end

edited Dec 28, 2016 at 14:22

answered Dec 28, 2016 at 14:03

Blackcoat77

1,6351 gold badge22 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Rails with mysql cannot create json type column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related