You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I get this error when using spree mollie gateway with spree globalize :
(Strange fact: I get the error once the app is deployed, not in my dev environment...)
ActionView::Template::Error (PG::InvalidColumnReference: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 1: ...store_translations"."locale" IN ($1, $2) ORDER BY spree_stor...
^
: SELECT DISTINCT spree_store_translations.name, "spree_stores"."id" FROM "spree_stores" INNER JOIN "spree_store_translations" ON "spree_store_translations"."spree_store_id" = "spree_stores"."id" WHERE "spree_store_translations"."locale" IN ($1, $2) ORDER BY spree_stores.name):
<div class="col-xs-12 col-md-4">
<div class="form-group">
<%= label_tag :q_store_id_in, Spree.t(:store) %>
<%= f.select :store_id_in, Spree::Store.order("#{Spree::Store.table_name}.name").pluck(:name, :id), {include_blank: true}, class: 'select2' %>
</div>
</div>
I actually don't understand why you put "#{Spree::Store.table_name}" in the above line. A simple Spree::Store.order("name").pluck(:name, :id), works just fine and doesn't raise the above bug.
I get this error when using spree mollie gateway with spree globalize :
(Strange fact: I get the error once the app is deployed, not in my dev environment...)
I actually don't understand why you put "#{Spree::Store.table_name}" in the above line. A simple
Spree::Store.order("name").pluck(:name, :id),
works just fine and doesn't raise the above bug.And, indeed, this is the code used in official backend repository: https://github.com/spree/spree/blob/master/backend/app/views/spree/admin/orders/index.html.erb#L134
Could that be fixed? Thanks! (I'll open a little PR)
Could I also open another PR that gets all updates from official backend files to this gem?
The text was updated successfully, but these errors were encountered: