An ActiveRecord::StatementInvalid occurred in home#field_technician_index:
PG::InvalidColumnReference: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 7: ...126, $127, $128, $129, $130, $131, $132) ORDER BY locations....
^
app/datatables/home_trouble_tickets_datatable.rb:23:in `map'
-------------------------------
Request:
-------------------------------
* URL : https://www.bikelink.org/home/field_technician_index.json?datatable=problem_reports&sEcho=8&iColumns=7&sColumns=%2C%2C%2C%2C%2C%2C&iDisplayStart=60&iDisplayLength=10&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=true&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&sSearch=&bRegex=false&iSortCol_0=3&sSortDir_0=asc&iSortingCols=1&_=1774011776203
* HTTP Method: GET
* IP address : 47.232.168.233
* Parameters : {"datatable"=>"problem_reports", "sEcho"=>"8", "iColumns"=>"7", "sColumns"=>",,,,,,", "iDisplayStart"=>"60", "iDisplayLength"=>"10", "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"=>"true", "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", "sSearch"=>"", "bRegex"=>"false", "iSortCol_0"=>"3", "sSortDir_0"=>"asc", "iSortingCols"=>"1", "_"=>"1774011776203", "controller"=>"home", "action"=>"field_technician_index", "format"=>"json"}
* Timestamp : 2026-03-20 13:06:04 UTC
* Server : www-8.internal.bikelink.org
* Rails root : /var/www/bikelink
* Process: 3084382
-------------------------------
Session:
-------------------------------
* session id: [FILTERED]
* data: {"session_id"=>"9e4216d324c7f0dc45cffd5413331342",
"warden.user.person.key"=>[[97128], "DSqAdmo1WDY3znTieq9E"],
"_csrf_token"=>"ZhnZSsZMQUBpe92VBZph_oEPJ_B9nv11jmqD8KYEcik"}
-------------------------------
Environment:
-------------------------------
* GATEWAY_INTERFACE : CGI/1.2
* HTTP_ACCEPT : application/json, text/javascript, */*; q=0.01
* HTTP_ACCEPT_ENCODING : gzip, deflate, br
* HTTP_ACCEPT_LANGUAGE : en-US,en;q=0.9
* HTTP_CONNECTION : close
* HTTP_COOKIE : _bikelink_session=0SAWWyMv%2BHnqF%2B5osW7inoPnBvxpuSt%2BetQVtIi1GQVI3QMc6qEbq%2ByUbuKlssGNXr1ckooDauxHJMdLLLLMcdt%2BdeuQtmxvSHtWwJqIlbO%2Fo9HavA4RiPxUa5DRUIDQrkYDI21zt%2FWUZv%2B68S1%2BWP5HoRlrUwQHr9LDXOeAfBnMY7nCt3%2BTAIIqaFGB8ckU%2Fve04teHUbb3JMm5LdkkhAjrf1ynPvWYO5qT36FbKtvAPfGf3IkfFEIP60bVU2uENvINW%2BQsV6PW3YKONJuyoWIlh%2FLr6IVZHH19A0V%2BeZCU8%2Blx7Fr4T6n0AsIznaCbWkxgXQ1hoKJkjRiwIHdChOxLmse2KGqsWlPNN06UDx%2BbQxkT3FFmtCsdkGWEg23mHmpETRQ%3D--qxqJ%2Bnv4hCoDLC5i--9R%2FuzGKPow8OIuspRDTWtw%3D%3D; _ga=GA1.1.1582918056.1758426849; _ga_5XJXN3VELE=GS2.1.s1774011386$o196$g1$t1774011776$j41$l0$h0
* HTTP_HOST : www.bikelink.org
* HTTP_PRIORITY : u=3, i
* HTTP_REFERER : https://www.bikelink.org/
* HTTP_SEC_FETCH_DEST : empty
* HTTP_SEC_FETCH_MODE : cors
* HTTP_SEC_FETCH_SITE : same-origin
* HTTP_USER_AGENT : Mozilla/5.0 (iPhone; CPU iPhone OS 26_2_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/146.0.7680.151 Mobile/15E148 Safari/604.1
* HTTP_VERSION : HTTP/1.0
* HTTP_X_AMZN_TRACE_ID : Root=1-69bd463c-28e1568e4129e8917e7577e4
* HTTP_X_CSRF_TOKEN : [FILTERED]
* HTTP_X_FORWARDED_FOR : 47.232.168.233, 47.232.168.233
* HTTP_X_FORWARDED_PORT : 443
* HTTP_X_FORWARDED_PROTO : https
* HTTP_X_REQUESTED_WITH : XMLHttpRequest
* ORIGINAL_FULLPATH : /home/field_technician_index.json?datatable=problem_reports&sEcho=8&iColumns=7&sColumns=%2C%2C%2C%2C%2C%2C&iDisplayStart=60&iDisplayLength=10&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=true&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&sSearch=&bRegex=false&iSortCol_0=3&sSortDir_0=asc&iSortingCols=1&_=1774011776203
*
---
⚠ The description was truncated because it was too long. Please check the original issue in Easy Redmine for the full content.
