This project is archived and is in readonly mode.

#6765 new

Column 'created_at' in order clause is ambiguous on queries with include

Reported by Quantum | May 2nd, 2011 @ 06:35 PM

ObjectItem HABTM ObjectGroup and ObjectGroup HABTM ObjectItem. I have the following query that is working correctly:

ObjectItem.find(:all, :include => :object_groups, :conditions => "object_items.description LIKE '%#{search}%' OR object_groups.description LIKE '%#{search}%'", :order => 'object_items.created_at DESC')

But doing query this way is now deprecated so i'm trying to change to this form

ObjectItem.order('object_items.created_at DESC').includes(:object_groups).where("object_items.description LIKE '%#{search}%' OR object_groups.description LIKE '%#{search}%'")

But i'm getting the following error:

Mysql2::Error: Column 'created_at' in order clause is ambiguous: SELECT DISTINCT FROM object_items LEFT OUTER JOIN object_groups_object_items ON object_groups_object_items.object_item_id = LEFT OUTER JOIN object_groups ON = object_groups_object_items.object_group_id WHERE (object_items.description LIKE '%%' OR object_groups.description LIKE '%%') ORDER BY object_items.created_at DESC, created_at DESC LIMIT 20 OFFSET 0

No comments found

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

<h2 style="font-size: 14px">Tickets have moved to Github</h2>

The new ticket tracker is available at <a href=""></a>

People watching this ticket