Rails, uploading multiple images with carrierwave, but json not supported by my database

Question

I am trying to use Carrierwave with multiple image uploads. After following the carrierwave guide on github I do:

rails g migration add_images_to_areas images:json
rake db:migrate

But seeing on my schema, my areas table does not show up, instead I get:

# Could not dump table "areas" because of following StandardError
#   Unknown type 'json' for column 'images'

What should I do now? Should I use another type instead of json, but what?

Sorry if this is an amateur question.

Ruben Barbosa · Accepted Answer · 2016-05-30 09:26:32Z

2

Databases by default don't support arrays, hashes and so on.

In order to do it, you can serialize it adding this code to your model:

class Name_class < ActiveRecord::Base
  serialize :column_name, JSON
end

And change the migration field :

add_column :user_preferences, :text

This will insert the info as Text into the database and, when you retrieve it , it will be JSON.

More info about serialization here RailsGuides#Serialize

edited May 30, 2016 at 9:26

answered May 30, 2016 at 9:16

Ruben Barbosa

1511 silver badge12 bronze badges

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

11 Comments

Roman Kiselenko Over a year ago

Databases support arrays or json, with some extensions.

Ruben Barbosa Over a year ago

I didn't know that . I always use serialize when i need a json or array field in the database. Thank you for the info though,

Tasos Anesiadis Over a year ago

@RubenBarbosa thank for the tip, I will try it and get right back at you.

Roman Kiselenko Over a year ago

Hollywar detected, choise by yourself. dev.mysql.com/doc/refman/5.7/en/json.html

Ruben Barbosa Over a year ago

Can you put the code of your controller?, the action when you save it in the database. I think the problem is there.

|

Community · Accepted Answer · 2017-05-23 12:02:05Z

1

I am not sure as to what was going wrong here, The github tutorial of Carrierwave was suggesting :json, but you don't have to do so.

Everything went fine after I just followed the guide for multiple image upload with Carrierwave here: Rails 4 multiple image or file upload using carrierwave

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Jun 1, 2016 at 12:50

Tasos Anesiadis

1,1701 gold badge13 silver badges38 bronze badges

Collectives™ on Stack Overflow

Rails, uploading multiple images with carrierwave, but json not supported by my database

2 Answers 2

11 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related