Why getting active record error when trying to work on arrays?
- by keruilin
I have the following association in my User model:
has_and_belongs_to_many :friends, :class_name => 'User', :foreign_key => 'friend_id'
I have the following uniqueness constraint in my user_users table:
UNIQUE KEY `no_duplicate_friends` (`user_id`,`friend_id`)
In my code, I am retrieving a user's friends -- friends = user.friends. friends is an array.
I have a scenario where I want add the user with all those friends to the friends array. Ex:
friends << user_with_all_those_homies
However, I get the following error:
ActiveRecord::StatementInvalid: Mysql::Error: Duplicate entry '18-18' for key 'no_duplicate_friends': INSERT INTO `users_users` (`friend_id`, `user_id`) VALUES (18, 18)
What gives?