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

Closed
lighthouse-import opened this Issue May 16, 2011 · 0 comments

Comments

Projects
None yet
1 participant
@lighthouse-import

Imported from Lighthouse. Original ticket at: http://rails.lighthouseapp.com/projects/8994/tickets/6765
Created by Quantum - 2011-05-02 17:35:28 UTC

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 object_items.id FROM object_items LEFT OUTER JOIN object_groups_object_items ON object_groups_object_items.object_item_id = object_items.id LEFT OUTER JOIN object_groups ON object_groups.id = 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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment