CODEWITHSUNDEEP
ruby-on-railspostgresql
user2351234
user2351234

Reputation: 975

Why Do i keep getting an error when I try to delete a single record from a database? Rails

I am having trouble deleting a record from a databse. I keep getting this error.

PG::Error: ERROR: zero-length delimited identifier at or near """" LINE 1: ...ctive_items" WHERE "users_items"."" = $1 ^ : DELETE FROM "users_items" WHERE "users_items"."" = $1

Here is the method.

def delete_items
    @destroyer = UsersItems.find_by_item_id(params[:items_id])
    @destroyer.destroy
    flash[:notice] = "Item deleted"
    redirect_to itemsearch_path

end

<a><%= link_to "Delete Item",{:controller => "items", :action => "delete_items",:method => :delete,:item_id => item.id}%></a>

Upvotes: 0

Views: 55

Answers (1)

Aguardientico
Aguardientico

Reputation: 7779

Change this:

<a><%= link_to "Delete Item",{:controller => "items", :action => "delete_items",:method => :delete,:item_id => item.id}%></a>

For this:

<%= link_to "Delete Item",{:controller => "items", :action => "delete_items", :item_id => item.id}, :method => :delete%>

Upvotes: 1

Related Questions