An ActiveRecord::StatementInvalid occurred in trouble_tickets#index:
PG::InvalidColumnReference: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 7: ...id) WHERE (trouble_tickets.state_id = 2) ORDER BY trouble_ti...
^
app/datatables/trouble_tickets_datatable.rb:38:in `data'
-------------------------------
Request:
-------------------------------
* URL : https://bikelink.org/trouble_tickets.json?filter_by_state=2&sEcho=2&iColumns=11&sColumns=%2C%2C%2C%2C%2C%2C%2C%2C%2C%2C&iDisplayStart=0&iDisplayLength=50&mDataProp_0=0&sSearch_0=&bRegex_0=false&bSearchable_0=true&bSortable_0=true&mDataProp_1=1&sSearch_1=&bRegex_1=false&bSearchable_1=true&bSortable_1=true&mDataProp_2=2&sSearch_2=&bRegex_2=false&bSearchable_2=true&bSortable_2=true&mDataProp_3=3&sSearch_3=&bRegex_3=false&bSearchable_3=true&bSortable_3=true&mDataProp_4=4&sSearch_4=&bRegex_4=false&bSearchable_4=true&bSortable_4=false&mDataProp_5=5&sSearch_5=&bRegex_5=false&bSearchable_5=true&bSortable_5=true&mDataProp_6=6&sSearch_6=&bRegex_6=false&bSearchable_6=true&bSortable_6=true&mDataProp_7=7&sSearch_7=&bRegex_7=false&bSearchable_7=true&bSortable_7=true&mDataProp_8=8&sSearch_8=&bRegex_8=false&bSearchable_8=true&bSortable_8=true&mDataProp_9=9&sSearch_9=&bRegex_9=false&bSearchable_9=true&bSortable_9=true&mDataProp_10=10&sSearch_10=&bRegex_10=false&bSearchable_10=true&bSortable_10=true&sSearch=&bRegex=false&iSortCol_0=10&sSortDir_0=asc&iSortingCols=1&_=1627407614828
* HTTP Method: GET
* IP address : 98.35.154.160
* Parameters : {"filter_by_state"=>"2", "sEcho"=>"2", "iColumns"=>"11", "sColumns"=>",,,,,,,,,,", "iDisplayStart"=>"0", "iDisplayLength"=>"50", "mDataProp_0"=>"0", "sSearch_0"=>"", "bRegex_0"=>"false", "bSearchable_0"=>"true", "bSortable_0"=>"true", "mDataProp_1"=>"1", "sSearch_1"=>"", "bRegex_1"=>"false", "bSearchable_1"=>"true", "bSortable_1"=>"true", "mDataProp_2"=>"2", "sSearch_2"=>"", "bRegex_2"=>"false", "bSearchable_2"=>"true", "bSortable_2"=>"true", "mDataProp_3"=>"3", "sSearch_3"=>"", "bRegex_3"=>"false", "bSearchable_3"=>"true", "bSortable_3"=>"true", "mDataProp_4"=>"4", "sSearch_4"=>"", "bRegex_4"=>"false", "bSearchable_4"=>"true", "bSortable_4"=>"false", "mDataProp_5"=>"5", "sSearch_5"=>"", "bRegex_5"=>"false", "bSearchable_5"=>"true", "bSortable_5"=>"true", "mDataProp_6"=>"6", "sSearch_6"=>"", "bRegex_6"=>"false", "bSearchable_6"=>"true", "bSortable_6"=>"true", "mDataProp_7"=>"7", "sSearch_7"=>"", "bRegex_7"=>"false", "bSearchable_7"=>"true", "bSortable_7"=>"true", "mDataProp_8"=>"8", "sSearch_8"=>"", "bRegex_8"=>"false", "bSearchable_8"=>"true", "bSortable_8"=>"true", "mDataProp_9"=>"9", "sSearch_9"=>"", "bRegex_9"=>"false", "bSearchable_9"=>"true", "bSortable_9"=>"true", "mDataProp_10"=>"10", "sSearch_10"=>"", "bRegex_10"=>"false", "bSearchable_10"=>"true", "bSortable_10"=>"true", "sSearch"=>"", "bRegex"=>"false", "iSortCol_0"=>"10", "sSortDir_0"=>"asc", "iSortingCols"=>"1", "_"=>"1627407614828", "controller"=>"trouble_tickets", "action"=>"index", "format"=>"json"}
* Timestamp : 2021-07-27 17:40:19 UTC
* Server : www-3.internal.bikelink.org
* Rails root : /var/www/bikelink
* Process: 31233
-------------------------------
Session:
-------------------------------
* session id: [FILTERED]
* data: {"session_id"=>"bf433f4c408152a20b8fef23cbea7995",
"warden.user.person.key"=>[[31069], "v64WXxPZ8M1zqfDtyyMc"],
"_csrf_token"=>"ihjpS72WHVKcIFkE32fcG7/LqgBFN0NAWv7KD1cbFJo=",
"params_for_filter"=>
{"filter_by_location"=>nil,
"filter_by_owner"=>nil,
"filter_by_state"=>2,
"filter_by_priority"=>nil}}
-------------------------------
Backtrace:
-------------------------------
app/datatables/trouble_tickets_datatable.rb:38:in `data'
app/datatables/trouble_tickets_datatable.rb:19:in `as_json'
app/controllers/trouble_tickets_controller.rb:60:in `block (2 levels) in index'
app/controllers/trouble_tickets_controller.rb:47:in `index'
