#4425 - g7_spaces#index - PG::AmbiguousColumn error
Also check other Datagrids for the same error.
An ActionView::Template::Error occurred in g7_spaces#index:
PG::AmbiguousColumn: ERROR: column reference "pricing" is ambiguous
LINE 1: SELECT DISTINCT pricing->>'reservation_cost' AS alias_0, "g7...
^
app/views/datagrid/_table.html.slim:11
-------------------------------
Request:
-------------------------------
* URL : https://www.bikelink.org/g7_spaces?commit=Apply&g7_spaces_datagrid%5Bdescending%5D=true&g7_spaces_datagrid%5Bg7_pricing_type%5D=&g7_spaces_datagrid%5Bg7_space_model%5D=&g7_spaces_datagrid%5Bid%5D=&g7_spaces_datagrid%5Blocation%5D=&g7_spaces_datagrid%5Border%5D=reservation_cost&g7_spaces_datagrid%5Bowner%5D=113&g7_spaces_datagrid%5Bper_page%5D=50
* HTTP Method: GET
* IP address : 184.23.37.178
* Parameters : {"commit"=>"Apply", "g7_spaces_datagrid"=>{"descending"=>"true", "g7_pricing_type"=>"", "g7_space_model"=>"", "id"=>"", "location"=>"", "order"=>"reservation_cost", "owner"=>"113", "per_page"=>"50"}, "controller"=>"g7_spaces", "action"=>"index"}
* Timestamp : 2026-03-24 00:27:14 UTC
* Server : www-8.internal.bikelink.org
* Rails root : /var/www/bikelink
* Process: 3160810
-------------------------------
Session:
-------------------------------
* session id: [FILTERED]
* data: {"session_id"=>"417e64ceef0c909fa26b7bd4456d2e5f",
"warden.user.person.key"=>[[31069], "oa8zM7WW7o4Pjn2npiwT"],
"_csrf_token"=>"cEfnJYAaeoZb9AXqcMRKL2W_uwChdvf-iCOtPNIU0as"}
-------------------------------
Environment:
-------------------------------
* GATEWAY_INTERFACE : CGI/1.2
* HTTP_ACCEPT : text/html, application/xhtml+xml
* HTTP_ACCEPT_ENCODING : gzip, deflate, br, zstd
* HTTP_ACCEPT_LANGUAGE : en-US,en;q=0.9
* HTTP_CONNECTION : close
* HTTP_COOKIE : _ga_5XJXN3VELE=GS2.1.s1752190966$o4$g0$t1752190966$j60$l0$h0; _ga=GA1.1.1082406862.1750092084; _bikelink_session=LRHZh9BSWKtYKMzzZseQbjWvR%2FSyS5%2BXAM%2FGWQo0O48BMC28RQPaeZtmIk6VQ2lPL%2F8XF1qUjf4pq66abGLaKcibMEzdYN2C%2FaI144tm2Um2wn54GM%2FHqyEkLZp2ZWRmhyOXYLrejNpfG88fVGVB%2FJ%2BOE3u4UM2iMUqRTIRbWY%2FXOk%2F5HHBKb4E6vB7CcgEEttvy7cOosFl6oM01AQsix7P6iAhLtHawwEHZzZFR8GIFIR6ShILyEXWNvyizOfr%2FDfZ60D%2F4U4Dmn6h7lO0MjwL0L2U8xjnGC6FAKiiCH0kwqmfiIoOoB9sBNIIY8%2BVqWBCnhVkX%2FxYCpl30NAg0TOqHyByoqNZljS9OAOaWojA8tWUsPuMZYfONSMz26J25z2we9w8%3D--dYnsfZsWgifOJYj2--z%2FP7jr6i95aSRMincHxWnQ%3D%3D
* HTTP_DNT : 1
* HTTP_HOST : www.bikelink.org
* HTTP_PRIORITY : u=4
* HTTP_REFERER : https://www.bikelink.org/g7_spaces?commit=Apply&g7_spaces_datagrid%5Bdescending%5D=false&g7_spaces_datagrid%5Bg7_pricing_type%5D=&g7_spaces_datagrid%5Bg7_space_model%5D=&g7_spaces_datagrid%5Bid%5D=&g7_spaces_datagrid%5Blocation%5D=&g7_spaces_datagrid%5Border%5D=name&g7_spaces_datagrid%5Bowner%5D=113&g7_spaces_datagrid%5Bper_page%5D=50
* HTTP_SEC_FETCH_DEST : empty
* HTTP_SEC_FETCH_MODE : cors
* HTTP_SEC_FETCH_SITE : same-origin
* HTTP_SEC_GPC : 1
* HTTP_TURBO_FRAME : g7_spaces_datagrid_g7_spaces_datagrid
* HTTP_USER_AGENT : Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:148.0) Gecko/20100101 Firefox/148.0
* HTTP_VERSION : HTTP/1.0
* HTTP_X_AMZN_TRACE_ID : Root=1-69c1da62-72d5df23192692e830e456ec
* HTTP_X_FORWARDED_FOR : 184.23.37.178, 184.23.37.178
* HTTP_X_FORWARDED_PORT : 443
* HTTP_X_FORWARDED_PROTO : https
* HTTP_X_SEC_PURPOSE : prefetch
* HTTP_X_TURBO_REQUEST_ID : 9102de17-c2dd-48cc-8594-7e265b2401b1
* ORIGINAL_FULLPATH : /g7_spaces?commit=Apply&g7_spaces_datagrid%5Bdescending%5D=true&g7_spaces_datagrid%5Bg7_pricing_type%5D=&g7_spaces_datagrid%5Bg7_space_model%5D=&g7_spaces_datagrid%5Bid%5D=&g7_spaces_datagrid%5Blocation%5D=&g7_spaces_datagrid%5Border%5D=reservation_cost&g7_spaces_datagrid%5Bowner%5D=113&g7_spaces_datagrid%5Bper_page%5D=50
* ORIGINAL_SCRIPT_NAME :
* PATH_INFO : /g7_spaces
* QUERY_STRING : commit=Apply&g7_spaces_datagrid%5Bdescending%5D=true&g7_spaces_datagrid%5Bg7_pricing_type%5D=&g7_spaces_datagrid%5Bg7_space_model%5D=&g7_spaces_datagrid%5Bid%5D=&g7_spaces_datagrid%5Blocation%5D=&g7_spaces_datagrid%5Border%5D=reservation_cost&g7_spaces_datagrid%5Bowner%5D=113&g7_spaces_datagrid%5Bper_page%5D=50
* REMOTE_ADDR : 127.0.0.1
* REQUEST_METHOD : GET
* REQUEST_PATH : /g7_spaces
* REQUEST_URI : /g7_spaces?commit=Apply&g7_spaces_datagrid%5Bdescending%5D=true&g7_spaces_datagrid%5Bg7_pricing_type%5D=&g7_spaces_datagrid%5Bg7_space_model%5D=&g7_spaces_datagrid%5Bid%5D=&g7_spaces_datagrid%5Blocation%5D=&g7_spaces_datagrid%5Border%5D=reservation_cost&g7_spaces_datagrid%5Bowner%5D=113&g7_spaces_datagrid%5Bper_page%5D=50
* ROUTES_13720_SCRIPT_NAME :
* SCRIPT_NAME :
* SERVER_NAME : www.bikelink.org
* SE
---
⚠ The description was truncated because it was too long. Please check the original issue in Easy Redmine for the full content.