Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Mysql::Error: Column 'lead_rating' in order clause is ambiguous: SELECT member_id FROM `member_leads` INNER JOIN `members` ON `members`.id = `member_leads`.member_id INNER JOIN `s_object_monitors` ON `s_object_monitors`.id = `member_leads`.s_object_monitor_id WHERE ((((`members`.`user_id` = 1 AND `members`.`member_state` IN (7,1) AND `members`.`entered_state_at` BETWEEN '2012-04-13' AND '2012-04-16')) AND (`s_object_monitors`.`enabled` = 1)) AND (member_leads.user_id = 1)) ORDER BY lead_rating DESC
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `log_without_newrelic_instrumentation'
- C:/Ruby187/lib/ruby/gems/1.8/gems/newrelic_rpm-3.1.1/lib/new_relic/agent/instrumentation/rails/active_record_instrumentation.rb:61:in `log'
- C:/Ruby187/lib/ruby/gems/1.8/gems/newrelic_rpm-3.1.1/lib/new_relic/agent/method_tracer.rb:242:in `trace_execution_scoped'
- C:/Ruby187/lib/ruby/gems/1.8/gems/newrelic_rpm-3.1.1/lib/new_relic/agent/instrumentation/rails/active_record_instrumentation.rb:58:in `log'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/mysql_adapter.rb:324:in `execute'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/mysql_adapter.rb:639:in `select'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/abstract/query_cache.rb:62:in `select_all'
- C:/Ruby187/lib/ruby/gems/1.8/gems/schoefmax-multi_db-0.2.1/lib/multi_db/connection_proxy.rb:149:in `send'
- C:/Ruby187/lib/ruby/gems/1.8/gems/schoefmax-multi_db-0.2.1/lib/multi_db/connection_proxy.rb:149:in `send_to_current'
- C:/Ruby187/lib/ruby/gems/1.8/gems/schoefmax-multi_db-0.2.1/lib/multi_db/query_cache_compat.rb:6:in `select_all_without_query_cache'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/base.rb:665:in `find_by_sql_without_trace_ActiveRecord_self_name_find_by_sql'
- C:/Ruby187/lib/ruby/gems/1.8/gems/newrelic_rpm-3.1.1/lib/new_relic/agent/method_tracer.rb:491:in `find_by_sql'
- C:/Ruby187/lib/ruby/gems/1.8/gems/newrelic_rpm-3.1.1/lib/new_relic/agent/method_tracer.rb:242:in `trace_execution_scoped'
- C:/Ruby187/lib/ruby/gems/1.8/gems/newrelic_rpm-3.1.1/lib/new_relic/agent/method_tracer.rb:486:in `find_by_sql'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/base.rb:1582:in `find_every'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/base.rb:619:in `find'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/base.rb:639:in `all'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/named_scope.rb:186:in `send'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/named_scope.rb:186:in `method_missing'
- C:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.10/lib/active_record/base.rb:2182:in `with_scope'
- C:1:in `__send__'
- C:1:in `with_scope'
- C:1:in `__send__'
- C:1:in `with_scope'
- C:1:in `__send__'
- C:1:in `with_scope'
- C:1:in `__send__'
- C:1:in `with_scope'
- C:1:in `__send__'
- C:1:in `with_scope'
- C:1:in `__send__'
- C:1:in `with_scope'
- C:1:in `__send__'
- C:1:in `with_scope'
- C:1:in `__send__'
- C:1:in `with_scope'
- C:1:in `__send__'
- C:1:in `with_scope'
- C:1:in `__send__'
- C:1:in `with_scope'
- C:/Projects/Communit/web/app/models/member_lead.rb:96:in `get_top_leads_member_ids'
- C:/Projects/Communit/web/app/models/member_lead.rb:55:in `get_member_leads'
- C:/Projects/Communit/web/lib/logic/member_data_layer.rb:484:in `get_top_new_leads'
- C:/Projects/Communit/web/lib/management/mailing_management.rb:115:in `get_top_leads'
- C:/Projects/Communit/web/lib/management/mailing_management.rb:33:in `get_recent_activity_data'
- C:/Projects/Communit/web/app/controllers/retention_mailer_controller.rb:8:in `recent_activity'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement