vinsol / solidus_admin_insights Goto Github PK

Hello,
I have following errors executing insights reports
PG::UndefinedFunction: ERROR: function date_format(timestamp without time zone, unknown) does not exist

ERROR: function ifnull(numeric, numeric) does not exist LINE 1: ...ent", 0 AS "promotion_discount

PG::UndefinedFunction: ERROR: function strcmp(character varying, unknown) does not exist LINE 1: ...ct_name", "products"."slug" AS "product_slug", IF(STRCMP("va... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

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'

Sequel::DatabaseError (Mysql2::Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't1.number' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by)

Page header displays:

Insights:

should display Insights: REPORT NAME

Thanks for sharing this extension. Would be great to have some unit tests for the reports