[Alumnionrails-errors] [ALI] stay_abroads#list (ActiveRecord::StatementInvalid) "Mysql::Error: Table 'alumnionrailsbeta_production.stay_abroads' doesn't exist: SELECT distinct abroad_university_id FROM `stay_abroads` inner join users on user_id = users.id inner join courses on users.course_no = courses.id WHERE (courses.id = '1') "

Sun Jul 18 13:30:49 EDT 2010

A ActiveRecord::StatementInvalid occurred in stay_abroads#list:

  Mysql::Error: Table 'alumnionrailsbeta_production.stay_abroads' doesn't exist: SELECT distinct abroad_university_id FROM `stay_abroads`    inner join users on user_id = users.id inner join courses on users.course_no = courses.id WHERE (courses.id = '1') 
  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:147:in `log'

-------------------------------
Request:
-------------------------------

  * URL       : http://beta.alumnionrails.com/stay_abroads/list/1
  * IP address: 85.216.17.200
  * Parameters: {"action"=>"list", "id"=>"1", "controller"=>"stay_abroads"}
  * Rails root: /home/www/beta.alumnionrails.com/rails/releases/20100718172808

-------------------------------
Session:
-------------------------------

  * session id: "BAh7CDoMdXNlcl9pZGkJOhJyZXF1ZXN0ZWRfdXJpMCIKZmxhc2hJQzonQWN0\naW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==--1c67864e53e76a4eda44b37bce4117fa26955896"
  * data: {:user_id=>4, :requested_uri=>nil, "flash"=>{}}

-------------------------------
Environment:
-------------------------------

  * CONTENT_LENGTH          : 0

  * CONTENT_TYPE            : application/x-www-form-urlencoded; charset=UTF-8

  * GATEWAY_INTERFACE       : CGI/1.2

  * HTTP_ACCEPT             : text/javascript, text/html, application/xml, text/xml, */*

  * HTTP_ACCEPT_CHARSET     : ISO-8859-1,utf-8;q=0.7,*;q=0.7

  * HTTP_ACCEPT_ENCODING    : gzip,deflate

  * HTTP_ACCEPT_LANGUAGE    : de-de,de;q=0.8,en-us;q=0.5,en;q=0.3

  * HTTP_CACHE_CONTROL      : no-cache

  * HTTP_CONNECTION         : Keep-Alive

  * HTTP_CONTENT_LENGTH     : 0

  * HTTP_CONTENT_TYPE       : application/x-www-form-urlencoded; charset=UTF-8

  * HTTP_COOKIE             : _ali_session=BAh7CDoMdXNlcl9pZGkJOhJyZXF1ZXN0ZWRfdXJpMCIKZmxhc2hJQzonQWN0%0AaW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA%3D%3D--1c67864e53e76a4eda44b37bce4117fa26955896; __utma=236534546.989438808.1279465286.1279465286.1279474223.2; __utmc=236534546; __utmz=236534546.1279465286.1.1.utmccn=(direct)|utmcsr=(direct)|utmcmd=(none); __utmb=236534546

  * HTTP_HOST               : 127.0.0.1:8071

  * HTTP_PRAGMA             : no-cache

  * HTTP_REFERER            : http://beta.alumnionrails.com/courses/show/1

  * HTTP_USER_AGENT         : Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2.6) Gecko/20100625 Firefox/3.6.6 (.NET CLR 3.5.30729)

  * HTTP_VERSION            : HTTP/1.1

  * HTTP_X_FORWARDED_FOR    : 85.216.17.200

  * HTTP_X_FORWARDED_HOST   : beta.alumnionrails.com

  * HTTP_X_FORWARDED_SERVER : beta.alumnionrails.com

  * HTTP_X_PROTOTYPE_VERSION: 1.6.0.1

  * HTTP_X_REQUESTED_WITH   : XMLHttpRequest

  * PATH_INFO               : /stay_abroads/list/1

  * REMOTE_ADDR             : 127.0.0.1

  * REQUEST_METHOD          : POST

  * REQUEST_PATH            : /stay_abroads/list/1

  * REQUEST_URI             : /stay_abroads/list/1

  * SCRIPT_NAME             : /

  * SERVER_NAME             : 127.0.0.1

  * SERVER_PORT             : 8071

  * SERVER_PROTOCOL         : HTTP/1.1

  * SERVER_SOFTWARE         : Mongrel 1.1.5

  * Process: 20851
  * Server : s15280848

-------------------------------
Backtrace:
-------------------------------

  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:147:in `log'
  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/mysql_adapter.rb:299:in `execute'
  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/mysql_adapter.rb:515:in `select_without_analyzer'
  [RAILS_ROOT]/vendor/plugins/query_analyzer/lib/query_analyzer.rb:38:in `select'
  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:59:in `select_all'
  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:80:in `cache_sql'
  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:59:in `select_all'
  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:582:in `find_by_sql'
  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:1341:in `find_every'
  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:536:in `find'
  [RAILS_ROOT]/app/controllers/stay_abroads_controller.rb:15:in `list'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:1162:in `send'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:1162:in `perform_action_without_filters'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/filters.rb:580:in `call_filters'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/filters.rb:573:in `perform_action_without_benchmark'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
  /usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/rescue.rb:201:in `perform_action_without_caching'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/caching/sql_cache.rb:13:in `perform_action'
  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:33:in `cache'
  /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/query_cache.rb:8:in `cache'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/caching/sql_cache.rb:12:in `perform_action'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:529:in `send'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:529:in `process_without_filters'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/filters.rb:569:in `process_without_session_management_support'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/session_management.rb:130:in `process'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:389:in `process'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:149:in `handle_request'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:107:in `dispatch'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:104:in `synchronize'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:104:in `dispatch'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:120:in `dispatch_cgi'
  /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:35:in `dispatch'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/rails.rb:76:in `process'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/rails.rb:74:in `synchronize'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/rails.rb:74:in `process'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:159:in `process_client'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:158:in `each'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:158:in `process_client'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `run'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `initialize'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `new'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `run'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `initialize'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `new'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `run'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/configurator.rb:282:in `run'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/configurator.rb:281:in `each'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/configurator.rb:281:in `run'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/mongrel_rails:128:in `run'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/command.rb:212:in `run'
  /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/mongrel_rails:281
  /usr/local/bin/mongrel_rails:19:in `load'
  /usr/local/bin/mongrel_rails:19