# Mysql Error

**URL:** <https://www.ruby-forum.com/t/mysql-error/141143>\
**Category:** Rails\
**Created:** [June 22, 2008, 5:48pm UTC](https://www.ruby-forum.com/t/mysql-error/141143 "2008-06-22T17:48:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![frozzare](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/45deac/32.png) [@frozzare](https://www.ruby-forum.com/u/frozzare)\
**Post date:** [June 22, 2008, 5:48pm UTC](https://www.ruby-forum.com/t/mysql-error/141143/1 "2008-06-22T17:48:28Z")

</div>

Hello. I was working on a add friend function. Buts i get an mysql  
error.

Mysql::Error: #23000Column ‘created\_at’ in order clause is ambiguous:  
SELECT `users`.id FROM `users` INNER JOIN friendships ON users.id =  
friendships.friend\_id WHERE (`users`.`id` = 2) AND  
((`friendships`.user\_id = 1) AND ((status = ‘requested’))) ORDER BY  
created\_at LIMIT 1

Extracted source (around line #9):

6: form\_tag “/#{controller.controller\_name}/#{logged\_user ?  
‘logout’ : ‘login’}” do %\>  
7:  
8: \<% if logged\_user %\>  
9: \<% unless @user == current\_user ||  
current\_user.requested\_friends.include?(@user) ||  
current\_user.friends.include?(@user) ||  
current\_user.pending\_friends.include?(@user) %\>  
10: \<% form\_for(:friendship, :url =\> user\_friends\_path(:user\_id =\>  
current\_user.id, :friend\_id =\> @user.id)) do |f| %\>  
11: \<%= submit\_tag “Lägg till som vän” %\>  
12:

---

<div class="post-metadata">

**Author:** ![frozzare](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/45deac/32.png) [@frozzare](https://www.ruby-forum.com/u/frozzare)\
**Post date:** [June 22, 2008, 6:22pm UTC](https://www.ruby-forum.com/t/mysql-error/141143/2 "2008-06-22T18:22:54Z")

</div>

On 22 Jun 2008, at 16:48, Fredrik F. wrote:

> Hello. I was working on a add friend function. Buts i get an mysql  
> error.
> 
> Mysql::Error: #23000Column ‘created\_at’ in order clause is ambiguous:  
> SELECT `users`.id FROM `users` INNER JOIN friendships ON users.id =  
> friendships.friend\_id WHERE (`users`.`id` = 2) AND  
> ((`friendships`.user\_id = 1) AND ((status = ‘requested’))) ORDER BY  
> created\_at LIMIT 1

well at the point where you’ve written :order =\> ‘created\_at’ you need  
to say ‘users.created\_at’ or ‘friendships.created\_at’

Fred