Herokuにデプロイした後にDBに保存されない

Question

実現したいこと

本番環境で情報を保存した際にDBに保存されるようにしたい

現状

            %ul.sub
              %li
                = link_to "①HTML", card_category_path(:card_id ,1)
              %li
                = link_to "②CSS", card_category_path(:card_id, 2)
              %li
                = link_to "③Javascript", card_category_path(:card_id, 3)
          %li
            バックエンド
            %ul.sub
              %li
                = link_to "④Java", card_category_path(:card_id, 4)
              %li
                = link_to "⑤PHP", card_category_path(:card_id, 5)
              %li
                = link_to "⑥Python", card_category_path(:card_id, 6)
              %li
                = link_to "⑦Ruby", card_category_path(:card_id, 7)

こちらのリンクのところをクリックするとエラーが起きてしまいます。
開発環境だとDBに保存されブラウザに表示されるようになっているのですが、
本番環境だとDBに保存されなくてブラウザに表示されない状態です

仮説

MySQLと繋がっていないのか？

原因だと思われるコード

  create_table "cards", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
    t.string "language"
    t.text "title"
    t.integer "price"
    t.string "releasedate"
    t.text "author"
    t.text "memo"
    t.datetime "created_at", precision: 6, null: false
    t.datetime "updated_at", precision: 6, null: false
    t.integer "category_id"
  end

  create_table "categories", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
    t.string "name"
    t.datetime "created_at", precision: 6, null: false
    t.datetime "updated_at", precision: 6, null: false
    t.integer "card_id"
  end

  create_table "users", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
    t.string "email", default: "", null: false
    t.string "encrypted_password", default: "", null: false
    t.string "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
    t.datetime "created_at", precision: 6, null: false
    t.datetime "updated_at", precision: 6, null: false
    t.string "nickname"
    t.index ["email"], name: "index_users_on_email", unique: true
    t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
  end

# MySQL. Versions 5.5.8 and up are supported.
#
# Install the MySQL driver
#   gem install mysql2
#
# Ensure the MySQL gem is defined in your Gemfile
#   gem 'mysql2'
#
# And be sure to use new-style password hashing:
#   https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
#
default: &default
 adapter: mysql2
 encoding: utf8
 pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
 username: root
 password:
 socket: /tmp/mysql.sock

development:
 <<: *default
 database: portfolio_development

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
 <<: *default
 database: portfolio_test

# As with config/credentials.yml, you never want to store sensitive information,
# like your database password, in your source code. If your source code is
# ever seen by anyone, they now have access to your database.
#
# Instead, provide the password as a unix environment variable when you boot
# the app. Read https://guides.rubyonrails.org/configuring.html#configuring-a-database
# for a full rundown on how to provide these environment variables in a
# production deployment.
#
# On Heroku and other platform providers, you may have a full connection URL
# available as an environment variable. For example:
#
#   DATABASE_URL="mysql2://myuser:mypass@localhost/somedatabase"
#
# You can use this database configuration with:
#
#   production:
#     url: <%= ENV['DATABASE_URL'] %>
#
production:
 <<: *default
 database: portfolio_production
 username: portfolio
 password: <%= ENV['PORTFOLIO_DATABASE_PASSWORD'] %>

class CardsController < ApplicationController
  before_action :set_card, only: [:edit, :show]
  #before_action :goback, only: [:update, :destroy]
  def index
    @cards = Card.all.page(params[:page]).per(6)
  end

  def new
    @card = Card.new
  end

  def create
    Card.create(cards_params)
    redirect_to root_path
  end

  def edit
    #@card = Card.find(params[:id])
  end

  def update
    card = Card.find(params[:id])
    card.update(cards_params)
    redirect_to root_path
  end

  def destroy
    card = Card.find(params[:id])
    card.destroy
    redirect_to root_path
  end

  def show
    #@card = Card.find(params[:id])
  end

  def search
    @cards = Card.search(params[:keyword])
    @keyword = params[:keyword]
  end

  private

  def cards_params
    params.require(:card).permit(:language, :title, :releasedate, :price, :author, :memo, :category_id)
  end

  def set_card
    @card = Card.find(params[:id])
  end

  # def goback
  #   redirect_to root_path
  # end

end

追加

ターミナルで

heroku run rails db:migrate

を実行すると

Caused by:
Mysql2::Error: Duplicate column name 'card_id'
このようなエラーが起きてしまいます。

追加2

clearDBは用意できています。

ターミナルで　heroku config　を行うと CLEARDB_DATABASE_URL:　の後にmysql~~~と表示されます。

どなたか手助けしてくれますと嬉しく思います。

Comments

[maisumakun]

ClearDBは用意しましたか？

[退会済みユーザー]

お返事ありがとうござます！
% heroku addons:add cleardb
Creating cleardb on ⬢ engineerbook-keitaro... free
Created cleardb-cylindrical-46141 as CLEARDB_TEAL_URL
Use heroku addons:docs cleardb to view documentation
調べてみて、こちらのコマンドを実行しました。

[退会済みユーザー]

ターミナルで　heroku config　を行うと
CLEARDB_DATABASE_URL:　の後にmysql~~~と表示されます。

[退会済みユーザー]

heroku run rails db:migrateをすると
このようなエラーが起きてしまいます・

Caused by:
Mysql2::Error: Duplicate column name 'card_id'