This is an error in the SQL statement being generated. The created_at column exists in both the Users and Friendships tables. You need to indicate the table of the column you want to order by.
Example: ".... ORDER BY users.created_at LIMIT 1" On Nov 29, 9:37 am, RubyonRails_newbie <[email protected]> wrote: > Hi there, I am working through a tutorial and I'm at the point of > accepting or declining a friend request. > > However, whenever I click accept of decline, I get the following > error: > > Mysql::Error: Column 'created_at' in order clause is ambiguous: SELECT > `users`.id FROM `users` INNER JOIN `friendships` ON `users`.id = > `friendships`.friend_id WHERE (`users`.`id` = 115) AND > ((`friendships`.user_id = 114) AND ((status = 'requested'))) ORDER BY > created_at LIMIT 1 > > I've looked through the controller for these 2 actions, but nothing > stands out. > > Please can anyone suggest how to fix this? > > Many Thanks -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
