Created
January 13, 2014 16:33
-
-
Save Willianvdv/8403295 to your computer and use it in GitHub Desktop.
Sql log for RuntimeError: No master variant found to infer price
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
(0.2ms) BEGIN | |
(0.8ms) SELECT COUNT(*) FROM "spree_products" WHERE ("spree_products".deleted_at IS NULL) AND (spree_products.permalink LIKE 'the-other-product%') | |
Spree::Product Load (0.8ms) SELECT "spree_products".* FROM "spree_products" WHERE ("spree_products".deleted_at IS NULL) AND (spree_products.permalink LIKE 'the-other-product%') | |
Spree::Product::Translation Load (0.4ms) SELECT "spree_product_translations".* FROM "spree_product_translations" WHERE "spree_product_translations"."spree_product_id" = $1 [["spree_product_id", 303]] | |
SQL (0.5ms) INSERT INTO "spree_products" ("created_at", "name", "permalink", "shipping_category_id", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", Mon, 13 Jan 2014 16:29:00 UTC +00:00], ["name", "The Other Product"], ["permalink", "the-other-product-1"], ["shipping_category_id", 1], ["updated_at", Mon, 13 Jan 2014 16:29:00 UTC +00:00]] | |
SQL (0.4ms) INSERT INTO "spree_product_properties" ("created_at", "product_id", "property_id", "updated_at", "value") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", Mon, 13 Jan 2014 16:29:00 UTC +00:00], ["product_id", 306], ["property_id", 763], ["updated_at", Mon, 13 Jan 2014 16:29:00 UTC +00:00], ["value", "cotton"]] | |
Spree::Product Load (0.4ms) SELECT "spree_products".* FROM "spree_products" WHERE ("spree_products".deleted_at IS NULL) AND "spree_products"."id" = $1 ORDER BY "spree_products"."id" ASC LIMIT 1 [["id", 306]] | |
SQL (0.3ms) UPDATE "spree_products" SET "updated_at" = '2014-01-13 16:29:00.613677' WHERE "spree_products"."id" = 306 | |
Spree::Property Load (1.2ms) SELECT "spree_properties".* FROM "spree_properties" INNER JOIN "spree_product_properties" ON "spree_properties"."id" = "spree_product_properties"."property_id" WHERE "spree_product_properties"."product_id" = $1 ORDER BY spree_product_properties.position [["product_id", 306]] | |
Spree::Property::Translation Load (0.3ms) SELECT "spree_property_translations".* FROM "spree_property_translations" WHERE "spree_property_translations"."spree_property_id" = $1 [["spree_property_id", 763]] | |
Spree::Property Load (0.7ms) SELECT "spree_properties".* FROM "spree_properties" INNER JOIN "spree_product_properties" ON "spree_properties"."id" = "spree_product_properties"."property_id" WHERE "spree_product_properties"."product_id" = $1 AND "spree_properties"."name" = 'fabric' ORDER BY spree_product_properties.position LIMIT 1 [["product_id", 306]] | |
Spree::ProductProperty Load (0.4ms) SELECT "spree_product_properties".* FROM "spree_product_properties" WHERE "spree_product_properties"."product_id" = $1 AND "spree_product_properties"."property_id" = 763 ORDER BY spree_product_properties.position LIMIT 1 [["product_id", 306]] | |
Spree::Product::Translation Load (0.3ms) SELECT "spree_product_translations".* FROM "spree_product_translations" WHERE "spree_product_translations"."spree_product_id" = $1 [["spree_product_id", 306]] | |
Spree::Variant Load (0.6ms) SELECT "spree_variants".* FROM "spree_variants" WHERE ("spree_variants".deleted_at IS NULL) AND "spree_variants"."product_id" = $1 AND "spree_variants"."is_master" = 't' ORDER BY "spree_variants"."id" ASC LIMIT 1 [["product_id", 306]] | |
Spree::Variant Load (0.5ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."product_id" = $1 AND "spree_variants"."is_master" = 't' ORDER BY "spree_variants".position ASC LIMIT 1 [["product_id", 306]] | |
Spree::Variant Load (0.4ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."product_id" = $1 AND "spree_variants"."is_master" = 't' ORDER BY "spree_variants".position ASC LIMIT 1 [["product_id", 306]] | |
(0.2ms) ROLLBACK |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment