Actually, for now - commenting the :order out in User.rb seems to allow me to continue without issue. :-)
thanks for the advice - it made me look in the right direction. On 29 Nov, 18:06, RubyonRails_newbie <[email protected]> wrote: > makes sense i think, but how would i specify it? > > On 29 Nov, 18:04, pharrington <[email protected]> wrote: > > > > > On Nov 29, 12:37 pm, 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 > > > Either in your User has_many :friendships declaration or the User.find > > that joins :friendships in the controller you have :order => > > "created_at". The RDBMS can't know which table to use for created_at > > column, as both have one. You need to specify that. -- 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.
