I have this error when trying to start filtering using checkboxes.
I try to follow link in JS console and have this:
.../frontend/app/views/spree/shared/_products.html.erb where line #8 raised:
PG::UndefinedTable: ERROR: missing FROM-clause entry for table "spree_product_properties"
LINE 1: ... "spree_products"."deleted_at" IS NULL AND (lower(spree_prod...
^
: SELECT COUNT(DISTINCT "spree_products"."id") FROM "spree_products" INNER JOIN "spree_variants" ON "spree_variants"."product_id" = "spree_products"."id" AND "spree_variants"."is_master" = 't' AND "spree_variants"."deleted_at" IS NULL INNER JOIN "spree_prices" ON "spree_prices"."variant_id" = "spree_variants"."id" AND "spree_prices"."deleted_at" IS NULL LEFT OUTER JOIN "spree_products_taxons" ON "spree_products_taxons"."product_id" = "spree_products"."id" WHERE "spree_products"."deleted_at" IS NULL AND ("spree_products".deleted_at IS NULL or "spree_products".deleted_at >= '2015-08-24 00:54:48.550989') AND ("spree_products".available_on <= '2015-08-24 00:54:48.551708') AND (spree_products.id in (SELECT spree_products.id FROM "spree_products" WHERE "spree_products"."deleted_at" IS NULL AND (lower(spree_product_properties.value) LIKE lower('Scell-it')))) AND "spree_products_taxons"."taxon_id" IN (10, 19, 20, 21, 22) AND (spree_prices.amount BETWEEN 0 AND 10000000 AND spree_prices.amount > 0) AND "spree_prices"."currency" = 'USD'
Spree 2.4 (vanila)
postgresql 9.4
webgradus/spree_filters - last
Thank you for wonderful plugin.
I have this error when trying to start filtering using checkboxes.
I try to follow link in JS console and have this:
.../frontend/app/views/spree/shared/_products.html.erb where line #8 raised:
PG::UndefinedTable: ERROR: missing FROM-clause entry for table "spree_product_properties"
LINE 1: ... "spree_products"."deleted_at" IS NULL AND (lower(spree_prod...
^
: SELECT COUNT(DISTINCT "spree_products"."id") FROM "spree_products" INNER JOIN "spree_variants" ON "spree_variants"."product_id" = "spree_products"."id" AND "spree_variants"."is_master" = 't' AND "spree_variants"."deleted_at" IS NULL INNER JOIN "spree_prices" ON "spree_prices"."variant_id" = "spree_variants"."id" AND "spree_prices"."deleted_at" IS NULL LEFT OUTER JOIN "spree_products_taxons" ON "spree_products_taxons"."product_id" = "spree_products"."id" WHERE "spree_products"."deleted_at" IS NULL AND ("spree_products".deleted_at IS NULL or "spree_products".deleted_at >= '2015-08-24 00:54:48.550989') AND ("spree_products".available_on <= '2015-08-24 00:54:48.551708') AND (spree_products.id in (SELECT spree_products.id FROM "spree_products" WHERE "spree_products"."deleted_at" IS NULL AND (lower(spree_product_properties.value) LIKE lower('Scell-it')))) AND "spree_products_taxons"."taxon_id" IN (10, 19, 20, 21, 22) AND (spree_prices.amount BETWEEN 0 AND 10000000 AND spree_prices.amount > 0) AND "spree_prices"."currency" = 'USD'
Spree 2.4 (vanila)
postgresql 9.4
webgradus/spree_filters - last
Thank you for wonderful plugin.