ActiveRecord::StatementInvalid in PicController#favorite

Question

当我尝试从使用Twitter API的推文列表中收藏一张图片时，我的Rails应用程序中出现了一个错误。

这是pic_controller.rb

class PicController < ApplicationController
    def favorite
        if current_user.present?
          pic = Pic.find(params[:url])
          FavPic.create pic: pic, user: current_user
          # user and pic automaically have this `FavPic` assigned
        end
    end
end

这是user.rb

class User < ActiveRecord::Base
  def self.from_omniauth(auth)
    user = where(provider: auth.provider, uid: auth.uid).first || create_from_omniauth(auth)
    user.oauth_token = auth["credentials"]["token"]
    user.oauth_secret = auth["credentials"]["secret"]
    user.save!
    user
  end

  def self.create_from_omniauth(auth)
    create! do |user|
      user.provider = auth["provider"]
      user.uid = auth["uid"]
      user.name = auth["info"]["nickname"]
    end
  end

  def twitter
    if provider == "twitter"
      @twitter ||= Twitter::Client.new(oauth_token: oauth_token, oauth_token_secret: oauth_secret)
    end
  end

  has_many :fav_pics
  has_many :pics_favorited,
    class_name: 'Pic',
    through: :fav_pics

end

class FavPic < ActiveRecord::Base
  belongs_to :user
  belongs_to :pic
end

class Pic < ActiveRecord::Base
  has_many :fav_pics
  has_many :fav_users,
    class_name: 'User',
    through: :fav_pics
end

不知道我在哪里出错了，也不知道如何解决问题，但这就是我得到的错误。PG::UndefinedTable: ERROR: relation "pics" does not exist LINE 5: WHERE a.attrelid = '"pics"'::regclass ^ : SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = '"pics"'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum

Answer 1

我认为您应该首先为这个运行"rails g migration create_(表的名称)“创建一个迁移表。然后在执行之后，在终端"rake db:migrate“中运行。