gistfile1.txt

Started GET "/reports" for 192.168.239.1 at 2012-05-01 14:50:47 +0100
Processing by ReportsController#index as HTML
  Clinical Load (0.7ms)  SELECT YEAR(transactiondate) as year, MONTH(transactiondate) as month, SUM(LineBalance) as income FROM `clinical` WHERE `clinical`.`payment` = 0 AND (LineBalance <> 0) AND (analysiscode <> 213) GROUP BY monthyear ORDER BY FullDateTime DESC LIMIT 1
Mysql2::Error: Unknown column 'clinical.payment' in 'where clause': SELECT  YEAR(transactiondate) as year, MONTH(transactiondate) as month, SUM(LineBalance) as income FROM `clinical`  WHERE `clinical`.`payment` = 0 AND (LineBalance <> 0) AND (analysiscode <> 213) GROUP BY monthyear ORDER BY FullDateTime DESC LIMIT 1
  Rendered reports/_income_by_month.erb (8.1ms)
  Rendered reports/index.html.erb within layouts/application (8.8ms)
Completed 500 Internal Server Error in 18ms

ActionView::Template::Error (Mysql2::Error: Unknown column 'clinical.payment' in 'where clause': SELECT  YEAR(transactiondate) as year, MONTH(transactiondate) as month, SUM(LineBalance) as income FROM `clinical`  WHERE `clinical`.`payment` = 0 AND (LineBalance <> 0) AND (analysiscode <> 213) GROUP BY monthyear ORDER BY FullDateTime DESC LIMIT 1):
    1: <div class="row">
    2:     <div class="twelve columns"><h5>This months income so far is <span style="font-size:1.2em"class="<% if @clinical_income_by_month.first.income >= @clinical_income_by_month.first(:offset => 12).income %>green<% else %>red<% end %> radius label"><%= number_to_currency(@clinical_income_by_month.first.income, :unit => "&pound;", :separator => ".", :delimiter => ",") %></span></h5> <%= @clinical_income_by_month.first.month %> <%= @clinical_income_by_month.first(:offset => 12).year %>'s income was <%= number_to_currency(@clinical_income_by_month.first(:offset => 12).income, :unit => "&pound;", :separator => ".", :delimiter => ",") %>.</div>
    3:   </div>
    4: <hr />
    5: 
  app/views/reports/_income_by_month.erb:2:in `_app_views_reports__income_by_month_erb___996056379_83015720'
  app/views/reports/index.html.erb:15:in `_app_views_reports_index_html_erb__346934006_85050700'
  app/controllers/reports_controller.rb:13:in `index'