ActiveRecord::StatementInvalid in ConditionsController#matches

DatabaseError: ERROR	VERROR	C42703	Mcolumn "distance" does not exist	P790	Fparse_relation.c	L3337	RerrorMissingColumn: 
      SELECT DISTINCT ON (distance, catname(items.name), conditions.id) conditions.id,

          l.id AS latest_load_id
        FROM conditions, items, shelters
          LEFT OUTER JOIN (SELECT * FROM loads WHERE id IN
            (SELECT max(id) FROM loads WHERE loads.status = 0 AND loads.source_id = 781 GROUP BY loads.destination_id)) l 
            ON l.destination_id = shelters.id
        WHERE (shelters.facility_type != 11) AND  shelters.id = conditions.shelter_id
          AND shelters.id != 781
          AND conditions.item_id = items.id
          AND conditions.type = 'Need'
          AND (load_id IS NULL)
          AND conditions.item_id IN
            (SELECT item_id FROM conditions WHERE shelter_id = 781 AND type = 'Surplus' AND (load_id IS NULL))
        ORDER BY distance, catname(items.name)
      ;

RAILS_ROOT: /home/ubuntu/relief/reliefdb/script/../config/..

Application Trace | Framework Trace | Full Trace
/home/ubuntu/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-1.15.6/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'
/home/ubuntu/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-1.15.6/lib/active_record/connection_adapters/postgresql_adapter.rb:152:in `execute'
/home/ubuntu/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-1.15.6/lib/active_record/connection_adapters/postgresql_adapter.rb:433:in `select'
/home/ubuntu/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-1.15.6/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
/home/ubuntu/relief/reliefdb/app/models/shelter.rb:190:in `matches'
/home/ubuntu/relief/reliefdb/app/models/shelter.rb:164:in `avail_matches'
/home/ubuntu/relief/reliefdb/app/controllers/conditions_controller.rb:336:in `matches'

Request

Parameters: {"show_only_my"=>"0", "show_regional"=>"1", "avail"=>"1", "id"=>"781", "show_urgent"=>"0", "show_closed"=>"1", "sort_req_id"=>"1", "sort"=>"Distance", "factype"=>"All, Except Businesses", "show_servaff"=>"1"}

Show session dump

Response

Headers: {"Cache-Control"=>"no-cache", "cookie"=>[]}