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
Hi,
I update solidus and I have several errors:
Fisrts :'<%= content_tag(div, class: 'hidden report-data', data: { report_data: @report_data_json } {} %>
'
The second one is that stay with loading symbol and not finalize.
And third, I get this error in products report:
´PG::GroupingError: ERROR: column "spree_line_items.updated_at" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...ame", "product_slug", spree_variants.sku ORDER BY "spree_lin... ^ : SELECT spree_products.name as product_name, spree_products.slug as product_slug, spree_variants.sku as sku, sum(quantity) as sold_count FROM "spree_line_items" INNER JOIN "spree_orders" ON "spree_orders"."id" = "spree_line_items"."order_id" INNER JOIN "spree_variants" ON "spree_variants"."id" = "spree_line_items"."variant_id" INNER JOIN "spree_variants" "variants_spree_line_items_join" ON "variants_spree_line_items_join"."id" = "spree_line_items"."variant_id" INNER JOIN "spree_products" ON "spree_products"."id" = "variants_spree_line_items_join"."product_id" WHERE ("spree_products"."name" ILIKE '%') AND "spree_orders"."state" = 'complete' AND ("spree_orders"."completed_at" BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:59.999999') GROUP BY "spree_line_items"."variant_id", "product_name", "product_slug", spree_variants.sku ORDER BY "spree_line_items"."updated_at" DESC, sold_count asc'
The text was updated successfully, but these errors were encountered:
Hi,
I update solidus and I have several errors:
Fisrts :'<%= content_tag(div, class: 'hidden report-data', data: { report_data: @report_data_json } {} %>
'
The second one is that stay with loading symbol and not finalize.
And third, I get this error in products report:
´PG::GroupingError: ERROR: column "spree_line_items.updated_at" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...ame", "product_slug", spree_variants.sku ORDER BY "spree_lin... ^ : SELECT spree_products.name as product_name, spree_products.slug as product_slug, spree_variants.sku as sku, sum(quantity) as sold_count FROM "spree_line_items" INNER JOIN "spree_orders" ON "spree_orders"."id" = "spree_line_items"."order_id" INNER JOIN "spree_variants" ON "spree_variants"."id" = "spree_line_items"."variant_id" INNER JOIN "spree_variants" "variants_spree_line_items_join" ON "variants_spree_line_items_join"."id" = "spree_line_items"."variant_id" INNER JOIN "spree_products" ON "spree_products"."id" = "variants_spree_line_items_join"."product_id" WHERE ("spree_products"."name" ILIKE '%') AND "spree_orders"."state" = 'complete' AND ("spree_orders"."completed_at" BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:59.999999') GROUP BY "spree_line_items"."variant_id", "product_name", "product_slug", spree_variants.sku ORDER BY "spree_line_items"."updated_at" DESC, sold_count asc'
The text was updated successfully, but these errors were encountered: