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'
sechix
commented
6 years ago
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'