CODEWITHSUNDEEP
ruby-on-railsruby-on-rails-3postgresqltwitter
user2849654
user2849654

Reputation:

Can't unfollow user because of Postgres

Rails 3.2, Twitter App

UPDATE: Sovled but any idea why it might work once, then when i try it again, I get Unknown key: #<User:0x007f9a5a946708> On line 16 users_controller.rb for @user. If i update a status or re-login its fine.

SOLUTION: After adding a notice: "Added", redirect_to_path under each if/else it worked fine. I haven't been able to produce an error for "user not found" tho.

I got a form_for, I type in :username, it follows or unfollows. Unfollow don't work. Looks like this.

Error

PG::UndefinedTable: ERROR: missing FROM-clause entry for table "id" LINE 1: DELETE FROM "relationships" WHERE "id"."follower_id" = 1 AND... ^ : DELETE FROM "relationships" WHERE "id"."follower_id" = 1 AND "id"."followed_id" = 2

id is missing? So I think the problem is in relationship_controller.rb

/users/buddies.html.erb

<%= form_for :username, :url => {:action => :buddies} do |f| %>
<%= f.text_field @user, placeholder: "username" %>
<%= f.submit "Add/Subtract" %>
<% end %>

users_controller.rb

@user = User.find_by_username(params[:username])

            if @user
                unless @user.blank?
                if current_user.following? @user
                    current_user.unfollow @user
                  else
                    current_user.follow @user
                end
              else
                flash[:error] = "stupid error";
                end
            end

user.rb

  def following? user
   self.followeds.include? user
  end

  def follow user
    Relationship.create follower_id: self.id, followed_id: user.id
  end

 def unfollow user
   Relationship.delete follower_id: self.id, followed_id: user.id
 end

relationships_controller.rb

def create

    @relationship = Relationship.new(params[:relationship]) 
    #@relationship.followed_id = params[:followed_id]
    @relationship.follower_id = current_user.id

    if @relationship.save
        redirect_to buddies_path, notice: "Phriend added"
        else
        flash[:error] = "Phriend not added";
        redirect_to buddies_path
    end
end

def delete
    @relationship = Relationship.find(params[:id])
    @relationship.delete
    redirect_to buddies_path, notice: "Phriend subtracted"
end

So that's a lot of words, but look in Relationship.delete.. what needs to change there?

Upvotes: 0

Views: 187

Answers (1)

nbrew
nbrew

Reputation: 781

Relationship.delete is expecting an id. Try something like:

# app/models/user.rb
def unfollow user
  Relationship.where(:follower_id => self.id, :followed_id => user.id).first.delete
end

Or, perhaps a bit clearer, if followeds are relationships:

def unfollow user
  self.followeds.where(:followed_id => user.id).first.delete
end
#didn't work for @ladiesman217

Upvotes: 0

Related Questions