Created
November 14, 2013 05:10
-
-
Save samhamilton/7461735 to your computer and use it in GitHub Desktop.
PayPal Gateway Error
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
| Redirected to http://localhost:3000/checkout/payment | |
| Completed 302 Found in 303.9ms (ActiveRecord: 40.5ms) | |
| Started GET "/checkout/payment" for 127.0.0.1 at 2013-11-14 12:54:06 +0800 | |
| Spree::Page Exists (0.5ms) SELECT 1 AS one FROM "spree_pages" WHERE "spree_pages"."visible" = 't' AND (("spree_pages"."slug" = 'checkout/payment' OR "spree_pages"."slug" = '/checkout/payment')) ORDER BY position ASC LIMIT 1 | |
| CACHE (0.0ms) SELECT 1 AS one FROM "spree_pages" WHERE "spree_pages"."visible" = 't' AND (("spree_pages"."slug" = 'checkout/payment' OR "spree_pages"."slug" = '/checkout/payment')) ORDER BY position ASC LIMIT 1 | |
| Deface: 1 overrides found for 'spree/checkout/edit' | |
| Deface: 'move_checkout_header_to_layout_subheader' matched 1 times with '[data-hook="checkout_header"]' | |
| Deface: [WARNING] No :original defined for 'move_checkout_header_to_layout_subheader', you should change its definition to include: | |
| :original => '14750f5f6800a5c2597e6cce4273df2406862135' | |
| Processing by Spree::CheckoutController#edit as HTML | |
| Parameters: {"state"=>"payment"} | |
| Spree::User Load (1.2ms) SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."id" = 1 LIMIT 1 | |
| Spree::Preference Load (0.3ms) SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = 'spree/frontend_configuration/locale' LIMIT 1 | |
| Spree::Order Load (0.5ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."user_id" = 1 AND "spree_orders"."completed_at" IS NULL AND "spree_orders"."created_by_id" = 1 ORDER BY created_at DESC LIMIT 1 | |
| Spree::Order Load (0.3ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 AND "spree_orders"."currency" = 'USD' LIMIT 1 | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."adjustable_id" IN (1540) ORDER BY created_at ASC | |
| Spree::Payment Load (0.4ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| Spree::LineItem Load (0.3ms) SELECT "spree_line_items".* FROM "spree_line_items" WHERE "spree_line_items"."order_id" = 1540 ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.5ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| (0.2ms) SELECT COUNT(*) FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 | |
| Spree::Payment Load (0.2ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 | |
| Spree::PaymentMethod Load (0.4ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = 5 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| CACHE (0.0ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| CACHE (0.0ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| (0.4ms) SELECT COUNT(*) FROM "spree_line_items" WHERE "spree_line_items"."order_id" = 1540 | |
| (0.4ms) SELECT SUM("spree_stock_items"."count_on_hand") AS sum_id FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."variant_id" = 11 AND "spree_stock_locations"."active" = 't' AND ("spree_stock_items".deleted_at IS NULL) | |
| Spree::StockItem Load (0.5ms) SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."variant_id" = 11 AND "spree_stock_locations"."active" = 't' AND ("spree_stock_items".deleted_at IS NULL) | |
| CACHE (0.0ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| CACHE (0.0ms) SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."id" = 1 LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| Spree::Shipment Load (0.5ms) SELECT "spree_shipments".* FROM "spree_shipments" WHERE "spree_shipments"."order_id" = 1540 | |
| Spree::StockLocation Load (0.3ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = 1 LIMIT 1 | |
| Spree::Order Load (0.3ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 LIMIT 1 | |
| Spree::InventoryUnit Load (0.2ms) SELECT "spree_inventory_units".* FROM "spree_inventory_units" WHERE "spree_inventory_units"."shipment_id" = 78 | |
| Spree::Variant Load (0.2ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" IN (11) AND ("spree_variants".deleted_at IS NULL) | |
| Spree::Variant Load (0.4ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" = 11 LIMIT 1 | |
| (0.4ms) SELECT COUNT(*) FROM "spree_roles" INNER JOIN "spree_roles_users" ON "spree_roles"."id" = "spree_roles_users"."role_id" WHERE "spree_roles_users"."user_id" = 1 AND "spree_roles"."name" = 'admin' | |
| Deface: 1 overrides found for 'spree/checkout/edit' | |
| Deface: 'move_checkout_header_to_layout_subheader' matched 1 times with '[data-hook="checkout_header"]' | |
| Deface: [WARNING] No :original defined for 'move_checkout_header_to_layout_subheader', you should change its definition to include: | |
| :original => '14750f5f6800a5c2597e6cce4273df2406862135' | |
| Deface: 7 overrides found for 'spree/layouts/spree_application' | |
| Deface: 'add_container_to_wrapper' matched 1 times with '#wrapper' | |
| Deface: [WARNING] No :original defined for 'add_container_to_wrapper', you should change its definition to include: | |
| :original => 'b783e7268d2ab196e65a32bc048cf6af2627dd06' | |
| Deface: 'add_mobile_navigation' matched 0 times with '[data-hook="body"]' | |
| Deface: 'add_slider_pager_to_wrapper' matched 1 times with '#wrapper' | |
| Deface: [WARNING] No :original defined for 'add_slider_pager_to_wrapper', you should change its definition to include: | |
| :original => '128eb031d328cb9bdbe9668fb82275f82cbbe4c4' | |
| Deface: 'unwrap_header_from_container_class' matched 1 times with '.container' | |
| Deface: [WARNING] No :original defined for 'unwrap_header_from_container_class', you should change its definition to include: | |
| :original => '6aeaab163e0e7c9ddcd8e8cfe797dc800f864ffc' | |
| Deface: 'add_subheader_to_layout' matched 1 times with '#wrapper' | |
| Deface: [WARNING] No :original defined for 'add_subheader_to_layout', you should change its definition to include: | |
| :original => 'a37b596967add3ea616dc60952a6b19e51e9b472' | |
| Deface: 'move_breadcrumb_inside_subheader' matched 1 times with '#subheader .subheader-wrapper' | |
| Deface: [WARNING] No :original defined for 'move_breadcrumb_inside_subheader', you should change its definition to include: | |
| :original => 'f3eec6288684efe3052aa74a68a22354cf3ebe4c' | |
| Deface: 'remove_breadcrumb_from_main_container' matched 1 times with '#wrapper > code:contains("breadcrumbs(@taxon)")' | |
| Deface: [WARNING] No :original defined for 'remove_breadcrumb_from_main_container', you should change its definition to include: | |
| :original => '72944bdd49a37f4721106a9794823dce41f4c306' | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/core/app/views/spree/shared/_error_messages.html.erb (0.2ms) | |
| CACHE (0.0ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| Deface: 2 overrides found for 'spree/checkout/_payment' | |
| Deface: 'add_icon_to_payment_submit_button' matched 1 times with 'code:contains("submit_tag Spree.t(:save_and_continue)")' | |
| Deface: [WARNING] No :original defined for 'add_icon_to_payment_submit_button', you should change its definition to include: | |
| :original => 'f87239cbe8641e902da84ab6631f2decf80103fa' | |
| Deface: 'make_payment_method_selection_as_a_button' matched starting with 'code:contains("@order.available_payment_methods.each")' and ending with 'code:contains("end")' | |
| Spree::PaymentMethod Load (0.5ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND ("spree_payment_methods".deleted_at IS NULL) | |
| Spree::Address Load (0.5ms) SELECT "spree_addresses".* FROM "spree_addresses" WHERE "spree_addresses"."id" = 100 LIMIT 1 | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/checkout/payment/_gateway.html.erb (7.7ms) | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/better_spree_paypal_express-0f3932184525/app/views/spree/checkout/payment/_paypal.html.erb (1.4ms) | |
| (0.6ms) SELECT COUNT(*) FROM "spree_activators" WHERE "spree_activators"."type" IN ('Spree::Promotion') AND "spree_activators"."event_name" = 'spree.checkout.coupon_code_added' | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/checkout/_payment.html.erb (187.4ms) | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| CACHE (0.0ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 LIMIT 1 | |
| Spree::Adjustment Load (0.8ms) SELECT "spree_adjustments".* FROM "spree_adjustments" INNER JOIN "spree_line_items" ON "spree_adjustments"."adjustable_id" = "spree_line_items"."id" AND "spree_adjustments"."adjustable_type" = 'Spree::LineItem' WHERE "spree_line_items"."order_id" = 1540 AND "spree_adjustments"."eligible" = 't' | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/checkout/_summary.html.erb (11.1ms) | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/checkout/edit.html.erb within spree/layouts/spree_application (235.2ms) | |
| Deface: 2 overrides found for 'spree/shared/_head' | |
| Deface: 'add_print_stylesheet' matched 1 times with 'code:contains("csrf_meta_tags")' | |
| Deface: [WARNING] No :original defined for 'add_print_stylesheet', you should change its definition to include: | |
| :original => 'b7ad84db3162a7f3a6b3286677d73ba1ee84f047' | |
| Deface: 'add_to_head' matched 1 times with 'code[erb-loud]:contains('meta_data_tags')' | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/core/app/views/spree/shared/_routes.html.erb (0.6ms) | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/shared/_head.html.erb (34.9ms) | |
| Deface: 2 overrides found for 'spree/shared/_header' | |
| Deface: 'replace_logo_grid_class' matched 1 times with '#logo' | |
| Deface: [WARNING] No :original defined for 'replace_logo_grid_class', you should change its definition to include: | |
| :original => '1d1c79977051248cdd96489f1225bfd1f64dd1ef' | |
| Deface: 'wrap_header_content_with_container_class' matched 1 times with '#header' | |
| Deface: [WARNING] No :original defined for 'wrap_header_content_with_container_class', you should change its definition to include: | |
| :original => '487a1abc9205d68676af35afc2af46e7e93a77f0' | |
| Deface: 7 overrides found for 'spree/shared/_nav_bar' | |
| Deface: 'auth_shared_login_bar' matched 1 times with 'li#search-bar' | |
| Deface: 'add_cart_link' matched 1 times with '#nav-bar' | |
| Deface: [WARNING] No :original defined for 'add_cart_link', you should change its definition to include: | |
| :original => 'b30bdf27e0930d6b3dd36d944b8d102c03fdb97f' | |
| Deface: 'add_search_icon_to_nav_bar' matched 1 times with '#search-bar' | |
| Deface: [WARNING] No :original defined for 'add_search_icon_to_nav_bar', you should change its definition to include: | |
| :original => 'eb3fa668cd98b6a1c75c36420ef1b238a1fc55ac' | |
| Deface: 'replace_nav_bar_grid_classes' matched 1 times with '#top-nav-bar' | |
| Deface: [WARNING] No :original defined for 'replace_nav_bar_grid_classes', you should change its definition to include: | |
| :original => '54f3107a99d0816d6b2649b7504bbd8da77c9a90' | |
| Deface: 'replace_logout_with_icon' matched 1 times with 'code:contains("Spree.t(:logout)")' | |
| Deface: [WARNING] No :original defined for 'replace_logout_with_icon', you should change its definition to include: | |
| :original => '568961154b4968b22b127fee211ecaa333a32241' | |
| Deface: 'replace_my_account_with_icon' matched 1 times with 'code:contains("Spree.t(:my_account)")' | |
| Deface: [WARNING] No :original defined for 'replace_my_account_with_icon', you should change its definition to include: | |
| :original => '775a69b7662a4914649827f3421c70464f7e23c1' | |
| Deface: 'replace_login_with_icon' matched 1 times with 'code:contains("Spree.t(:login)")' | |
| Deface: [WARNING] No :original defined for 'replace_login_with_icon', you should change its definition to include: | |
| :original => 'c99948f50c4cf2df5c3a36456faef39d15f74eb5' | |
| Deface: 2 overrides found for 'spree/shared/_search' | |
| Deface: 'remove_search_button' matched 1 times with 'code:contains("submit_tag Spree.t(:search)")' | |
| Deface: [WARNING] No :original defined for 'remove_search_button', you should change its definition to include: | |
| :original => '0e3ccc641e309928a63debf5967133151f0bc407' | |
| Deface: 'remove_taxon_search_select' matched 1 times with 'code:contains("select_tag :taxon")' | |
| Deface: [WARNING] No :original defined for 'remove_taxon_search_select', you should change its definition to include: | |
| :original => '167737e00dc030a9fa0de115339d2e1a20c43fee' | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/shared/_search.html.erb (1.9ms) | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/shared/_nav_bar.html.erb (15.0ms) | |
| Deface: 5 overrides found for 'spree/shared/_main_nav_bar' | |
| Deface: 'pages_in_header' matched 1 times with '#main-nav-bar' | |
| Deface: [WARNING] No :original defined for 'pages_in_header', you should change its definition to include: | |
| :original => 'db2835f20e2ab66e854a74f6ae2a05cfb86f20fd' | |
| Deface: 'insert_menu_trigger_link_to_main_menu' matched 1 times with '#main-nav-bar' | |
| Deface: [WARNING] No :original defined for 'insert_menu_trigger_link_to_main_menu', you should change its definition to include: | |
| :original => '4309a2e7e0fffab7320abc552486f755d55342d3' | |
| Deface: 'insert_shop_link_to_main_menu' matched 1 times with '#home-link' | |
| Deface: [WARNING] No :original defined for 'insert_shop_link_to_main_menu', you should change its definition to include: | |
| :original => 'a4890d2d334f58a60097ab531c88df2193f86e61' | |
| Deface: 'remove_cart_link' matched 1 times with '#link-to-cart' | |
| Deface: [WARNING] No :original defined for 'remove_cart_link', you should change its definition to include: | |
| :original => '0d843946b3a53643c5a7da90a3a21610208db866' | |
| Deface: 'replace_main_nav_bar_grid_classes' matched 1 times with 'nav' | |
| Deface: [WARNING] No :original defined for 'replace_main_nav_bar_grid_classes', you should change its definition to include: | |
| :original => 'b1336cfebe7708d6020b5d24428d08c660a9667d' | |
| Spree::Page Load (0.6ms) SELECT "spree_pages".* FROM "spree_pages" WHERE "spree_pages"."show_in_header" = 't' AND "spree_pages"."visible" = 't' ORDER BY position ASC | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree_static_content-a9d17d7fe22b/app/views/spree/static_content/_static_content_list.html.erb (0.0ms) | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/shared/_main_nav_bar.html.erb (7.8ms) | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/shared/_header.html.erb (171.8ms) | |
| Deface: 1 overrides found for 'spree/shared/_footer' | |
| Deface: 'pages_in_footer' matched 0 times with '#footer-right' | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/zooron_spree_fancy-1ac5d082f754/app/views/spree/shared/_footer.html.erb (1.1ms) | |
| Spree::Tracker Load (0.4ms) SELECT "spree_trackers".* FROM "spree_trackers" WHERE "spree_trackers"."active" = 't' AND "spree_trackers"."environment" = 'development' LIMIT 1 | |
| Rendered spree/shared/_google_analytics.html.erb (1.8ms) | |
| Completed 200 OK in 574.5ms (Views: 517.9ms | ActiveRecord: 11.6ms) | |
| Action: SetExpressCheckout | |
| Request[post]: https://api-3t.sandbox.paypal.com/2.0/ | |
| Response[200]: OK, Duration: 2.348s | |
| Started POST "/paypal?payment_method_id=5" for 127.0.0.1 at 2013-11-14 12:54:15 +0800 | |
| Processing by Spree::PaypalController#express as HTML | |
| Parameters: {"authenticity_token"=>"qSggyB4Wg7+QV38S3f+9TTlUor+id5yCmWL09jC9Eus=", "payment_method_id"=>"5"} | |
| Spree::User Load (0.7ms) SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."id" = 1 LIMIT 1 | |
| Spree::Preference Load (0.3ms) SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = 'spree/frontend_configuration/locale' LIMIT 1 | |
| Spree::Order Load (0.6ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."user_id" = 1 AND "spree_orders"."completed_at" IS NULL AND "spree_orders"."created_by_id" = 1 ORDER BY created_at DESC LIMIT 1 | |
| Spree::Order Load (0.3ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 AND "spree_orders"."currency" = 'USD' LIMIT 1 | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."adjustable_id" IN (1540) ORDER BY created_at ASC | |
| Spree::LineItem Load (0.2ms) SELECT "spree_line_items".* FROM "spree_line_items" WHERE "spree_line_items"."order_id" = 1540 ORDER BY created_at ASC | |
| Spree::Variant Load (0.2ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" = 11 LIMIT 1 | |
| Spree::Product Load (0.3ms) SELECT "spree_products".* FROM "spree_products" WHERE "spree_products"."id" = 11 LIMIT 1 | |
| Spree::Adjustment Load (0.4ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."originator_type" = 'Spree::TaxRate' AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.8ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::ShippingMethod' ORDER BY created_at ASC | |
| Spree::PaymentMethod Load (0.5ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = $1 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 [["id", "5"]] | |
| CACHE (0.0ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = $1 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 [["id", "5"]] | |
| CACHE (0.0ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = $1 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 [["id", "5"]] | |
| CACHE (0.0ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = $1 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 [["id", "5"]] | |
| CACHE (0.0ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = $1 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 [["id", "5"]] | |
| CACHE (0.0ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = $1 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 [["id", "5"]] | |
| CACHE (0.0ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = $1 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 [["id", "5"]] | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::ShippingMethod' ORDER BY created_at ASC | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."originator_type" = 'Spree::TaxRate' AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC | |
| Spree::Address Load (0.5ms) SELECT "spree_addresses".* FROM "spree_addresses" WHERE "spree_addresses"."id" = 100 LIMIT 1 | |
| Spree::State Load (0.2ms) SELECT "spree_states".* FROM "spree_states" WHERE "spree_states"."id" = 1061493585 LIMIT 1 | |
| Spree::Country Load (0.2ms) SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."id" = 214 LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = $1 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 [["id", "5"]] | |
| CACHE (0.0ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = $1 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 [["id", "5"]] | |
| Redirected to https://www.sandbox.paypal.com/webscr?cmd=_express-checkout&token=EC-37V24539YU738921S | |
| Completed 302 Found in 2784.9ms (ActiveRecord: 5.8ms) | |
| Action: GetExpressCheckoutDetails | |
| Request[post]: https://api-3t.sandbox.paypal.com/2.0/ | |
| Response[200]: OK, Duration: 2.422s | |
| Action: DoExpressCheckoutPayment | |
| Request[post]: https://api-3t.sandbox.paypal.com/2.0/ | |
| Response[200]: OK, Duration: 2.032s | |
| Started GET "/paypal/confirm?payment_method_id=5&utm_nooverride=1&token=EC-37V24539YU738921S&PayerID=7L35JWRS982JA" for 127.0.0.1 at 2013-11-14 12:55:00 +0800 | |
| Spree::Page Exists (0.5ms) SELECT 1 AS one FROM "spree_pages" WHERE "spree_pages"."visible" = 't' AND (("spree_pages"."slug" = 'paypal/confirm' OR "spree_pages"."slug" = '/paypal/confirm')) ORDER BY position ASC LIMIT 1 | |
| CACHE (0.0ms) SELECT 1 AS one FROM "spree_pages" WHERE "spree_pages"."visible" = 't' AND (("spree_pages"."slug" = 'paypal/confirm' OR "spree_pages"."slug" = '/paypal/confirm')) ORDER BY position ASC LIMIT 1 | |
| Processing by Spree::PaypalController#confirm as HTML | |
| Parameters: {"payment_method_id"=>"5", "utm_nooverride"=>"1", "token"=>"EC-37V24539YU738921S", "PayerID"=>"7L35JWRS982JA"} | |
| Spree::User Load (0.7ms) SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."id" = 1 LIMIT 1 | |
| Spree::Preference Load (0.5ms) SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = 'spree/frontend_configuration/locale' LIMIT 1 | |
| Spree::Order Load (0.8ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."user_id" = 1 AND "spree_orders"."completed_at" IS NULL AND "spree_orders"."created_by_id" = 1 ORDER BY created_at DESC LIMIT 1 | |
| Spree::Order Load (0.6ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 AND "spree_orders"."currency" = 'USD' LIMIT 1 | |
| Spree::Adjustment Load (0.4ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."adjustable_id" IN (1540) ORDER BY created_at ASC | |
| (0.2ms) BEGIN | |
| SQL (1.1ms) INSERT INTO "spree_paypal_express_checkouts" ("created_at", "payer_id", "refund_transaction_id", "refund_type", "refunded_at", "state", "token", "transaction_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id" [["created_at", Thu, 14 Nov 2013 04:55:00 UTC +00:00], ["payer_id", "7L35JWRS982JA"], ["refund_transaction_id", nil], ["refund_type", nil], ["refunded_at", nil], ["state", "complete"], ["token", "EC-37V24539YU738921S"], ["transaction_id", nil]] | |
| (1.1ms) COMMIT | |
| Spree::PaymentMethod Load (0.3ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = $1 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 [["id", "5"]] | |
| (0.1ms) BEGIN | |
| Spree::Payment Exists (0.4ms) SELECT 1 AS one FROM "spree_payments" WHERE "spree_payments"."identifier" = 'ZF9FLWQ3' LIMIT 1 | |
| SQL (0.8ms) INSERT INTO "spree_payments" ("amount", "avs_response", "created_at", "cvv_response_code", "cvv_response_message", "identifier", "order_id", "payment_method_id", "response_code", "source_id", "source_type", "state", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" [["amount", #<BigDecimal:7fc010008f48,'0.2305E2',18(18)>], ["avs_response", nil], ["created_at", Thu, 14 Nov 2013 04:55:00 UTC +00:00], ["cvv_response_code", nil], ["cvv_response_message", nil], ["identifier", "ZF9FLWQ3"], ["order_id", 1540], ["payment_method_id", 5], ["response_code", nil], ["source_id", 3], ["source_type", "Spree::PaypalExpressCheckout"], ["state", "checkout"], ["updated_at", Thu, 14 Nov 2013 04:55:00 UTC +00:00]] | |
| Spree::Order Load (0.7ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 LIMIT 1 | |
| Spree::Payment Load (0.4ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'checkout' AND (id != 42) | |
| Spree::Payment Load (0.2ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 | |
| Spree::Payment Load (0.2ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| Spree::LineItem Load (0.3ms) SELECT "spree_line_items".* FROM "spree_line_items" WHERE "spree_line_items"."order_id" = 1540 ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC | |
| Spree::Adjustment Load (1.8ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::PromotionAction' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.6ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::PromotionAction' AND "spree_adjustments"."eligible" = 't' ORDER BY amount ASC, created_at DESC LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::ShippingMethod' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."id" = $1 LIMIT 1 [["id", 77]] | |
| Spree::ShippingMethod Load (0.3ms) SELECT "spree_shipping_methods".* FROM "spree_shipping_methods" WHERE "spree_shipping_methods"."deleted_at" IS NULL AND "spree_shipping_methods"."id" = 3 LIMIT 1 | |
| Spree::Shipment Load (0.2ms) SELECT "spree_shipments".* FROM "spree_shipments" WHERE "spree_shipments"."id" = 78 LIMIT 1 | |
| Spree::StockLocation Load (0.2ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = 1 LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 LIMIT 1 | |
| Spree::InventoryUnit Load (0.3ms) SELECT "spree_inventory_units".* FROM "spree_inventory_units" WHERE "spree_inventory_units"."shipment_id" = 78 | |
| Spree::Variant Load (0.3ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" IN (11) AND ("spree_variants".deleted_at IS NULL) | |
| Spree::Calculator Load (0.2ms) SELECT "spree_calculators".* FROM "spree_calculators" WHERE "spree_calculators"."calculable_id" = 3 AND "spree_calculators"."calculable_type" = 'Spree::ShippingMethod' LIMIT 1 | |
| Spree::Price Load (0.2ms) SELECT "spree_prices".* FROM "spree_prices" WHERE "spree_prices"."variant_id" = 11 AND "spree_prices"."currency" = 'USD' LIMIT 1 | |
| SQL (0.2ms) UPDATE "spree_adjustments" SET "amount" = 5.0 WHERE "spree_adjustments"."id" = 77 | |
| SQL (0.2ms) UPDATE "spree_adjustments" SET "eligible" = 't' WHERE "spree_adjustments"."id" = 77 | |
| Spree::Payment Load (0.2ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| SQL (0.3ms) UPDATE "spree_orders" SET "payment_state" = NULL, "shipment_state" = NULL, "item_total" = 18.05, "adjustment_total" = 5.0, "payment_total" = 0.0, "total" = 23.05 WHERE "spree_orders"."id" = 1540 | |
| (0.9ms) COMMIT | |
| (0.4ms) SELECT COUNT(*) FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 | |
| Spree::Payment Load (0.2ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 | |
| Spree::PaymentMethod Load (0.3ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = 5 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 | |
| (0.1ms) BEGIN | |
| (0.4ms) UPDATE "spree_payments" SET "created_at" = '2013-11-14 04:55:00.000000', "updated_at" = '2013-11-14 04:55:00.000000', "state" = 'processing' WHERE "spree_payments"."id" = 42 | |
| Spree::Payment Load (0.3ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 | |
| Spree::Payment Load (0.2ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.4ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.2ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::PromotionAction' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::PromotionAction' AND "spree_adjustments"."eligible" = 't' ORDER BY amount ASC, created_at DESC LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::ShippingMethod' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.2ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."id" = $1 LIMIT 1 [["id", 77]] | |
| Spree::ShippingMethod Load (0.2ms) SELECT "spree_shipping_methods".* FROM "spree_shipping_methods" WHERE "spree_shipping_methods"."deleted_at" IS NULL AND "spree_shipping_methods"."id" = 3 LIMIT 1 | |
| Spree::Shipment Load (0.2ms) SELECT "spree_shipments".* FROM "spree_shipments" WHERE "spree_shipments"."id" = 78 LIMIT 1 | |
| Spree::StockLocation Load (0.2ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = 1 LIMIT 1 | |
| Spree::Order Load (0.3ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 LIMIT 1 | |
| Spree::InventoryUnit Load (0.3ms) SELECT "spree_inventory_units".* FROM "spree_inventory_units" WHERE "spree_inventory_units"."shipment_id" = 78 | |
| Spree::Variant Load (0.6ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" IN (11) AND ("spree_variants".deleted_at IS NULL) | |
| Spree::Calculator Load (0.2ms) SELECT "spree_calculators".* FROM "spree_calculators" WHERE "spree_calculators"."calculable_id" = 3 AND "spree_calculators"."calculable_type" = 'Spree::ShippingMethod' LIMIT 1 | |
| Spree::Price Load (0.3ms) SELECT "spree_prices".* FROM "spree_prices" WHERE "spree_prices"."variant_id" = 11 AND "spree_prices"."currency" = 'USD' LIMIT 1 | |
| SQL (0.4ms) UPDATE "spree_adjustments" SET "amount" = 5.0 WHERE "spree_adjustments"."id" = 77 | |
| SQL (0.2ms) UPDATE "spree_adjustments" SET "eligible" = 't' WHERE "spree_adjustments"."id" = 77 | |
| Spree::Payment Load (0.2ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| SQL (0.2ms) UPDATE "spree_orders" SET "payment_state" = NULL, "shipment_state" = NULL, "item_total" = 18.05, "adjustment_total" = 5.0, "payment_total" = 0.0, "total" = 23.05 WHERE "spree_orders"."id" = 1540 | |
| Spree::Adjustment Load (0.4ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::ShippingMethod' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.2ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."originator_type" = 'Spree::TaxRate' AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.2ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' AND "spree_adjustments"."originator_type" = 'Spree::PromotionAction' ORDER BY created_at ASC | |
| Spree::Address Load (0.3ms) SELECT "spree_addresses".* FROM "spree_addresses" WHERE "spree_addresses"."id" = 100 LIMIT 1 | |
| Spree::State Load (0.2ms) SELECT "spree_states".* FROM "spree_states" WHERE "spree_states"."id" = 1061493585 LIMIT 1 | |
| Spree::Country Load (0.2ms) SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."id" = 214 LIMIT 1 | |
| Spree::Address Load (0.9ms) SELECT "spree_addresses".* FROM "spree_addresses" WHERE "spree_addresses"."id" = 101 LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_states".* FROM "spree_states" WHERE "spree_states"."id" = 1061493585 LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."id" = 214 LIMIT 1 | |
| SQL (1.4ms) INSERT INTO "spree_log_entries" ("created_at", "details", "source_id", "source_type", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", Thu, 14 Nov 2013 04:55:05 UTC +00:00], ["details", "--- !ruby/object:PayPal::SDK::Merchant::DataTypes::DoExpressCheckoutPaymentResponseType\nTimestamp: !ruby/object:DateTime 2013-11-14 04:55:04.000000000 Z\nAck: !ruby/string:PayPal::SDK::Merchant::DataTypes::AckCodeType |-\n RmFpbHVyZQ==\nCorrelationID: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |-\n MTFkOGY4YTM4YzViNg==\nErrors: !ruby/array:PayPal::SDK::Core::API::DataTypes::ArrayWithBlock\n internal:\n - !ruby/object:PayPal::SDK::Merchant::DataTypes::ErrorType\n ShortMessage: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |-\n VHJhbnNhY3Rpb24gcmVmdXNlZCBiZWNhdXNlIG9mIGFuIGludmFsaWQgYXJn\n dW1lbnQuIFNlZSBhZGRpdGlvbmFsIGVycm9yIG1lc3NhZ2VzIGZvciBkZXRh\n aWxzLg==\n LongMessage: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |-\n VGhlIHRvdGFscyBvZiB0aGUgY2FydCBpdGVtIGFtb3VudHMgZG8gbm90IG1h\n dGNoIG9yZGVyIGFtb3VudHMu\n ErrorCode: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |-\n MTA0MTM=\n SeverityCode: !ruby/string:PayPal::SDK::Merchant::DataTypes::SeverityCodeType |-\n RXJyb3I=\n ivars:\n :@block: !ruby/object:Proc {}\nVersion: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |-\n MTA2LjA=\nBuild: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |-\n ODQ1MTg3Mw==\nDoExpressCheckoutPaymentResponseDetails: \n"], ["source_id", 42], ["source_type", "Spree::Payment"], ["updated_at", Thu, 14 Nov 2013 04:55:05 UTC +00:00]] | |
| (0.4ms) UPDATE "spree_payments" SET "state" = 'failed', "updated_at" = '2013-11-14 04:55:05.384004' WHERE "spree_payments"."id" = 42 | |
| Spree::Payment Load (0.3ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 | |
| Spree::Payment Load (0.3ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| Spree::Adjustment Load (0.4ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.2ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::PromotionAction' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::PromotionAction' AND "spree_adjustments"."eligible" = 't' ORDER BY amount ASC, created_at DESC LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::ShippingMethod' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.2ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."id" = $1 LIMIT 1 [["id", 77]] | |
| Spree::ShippingMethod Load (0.2ms) SELECT "spree_shipping_methods".* FROM "spree_shipping_methods" WHERE "spree_shipping_methods"."deleted_at" IS NULL AND "spree_shipping_methods"."id" = 3 LIMIT 1 | |
| Spree::Shipment Load (0.2ms) SELECT "spree_shipments".* FROM "spree_shipments" WHERE "spree_shipments"."id" = 78 LIMIT 1 | |
| Spree::StockLocation Load (0.2ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = 1 LIMIT 1 | |
| Spree::Order Load (0.2ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 LIMIT 1 | |
| Spree::InventoryUnit Load (0.2ms) SELECT "spree_inventory_units".* FROM "spree_inventory_units" WHERE "spree_inventory_units"."shipment_id" = 78 | |
| Spree::Variant Load (1.0ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" IN (11) AND ("spree_variants".deleted_at IS NULL) | |
| Spree::Calculator Load (0.4ms) SELECT "spree_calculators".* FROM "spree_calculators" WHERE "spree_calculators"."calculable_id" = 3 AND "spree_calculators"."calculable_type" = 'Spree::ShippingMethod' LIMIT 1 | |
| Spree::Price Load (1.7ms) SELECT "spree_prices".* FROM "spree_prices" WHERE "spree_prices"."variant_id" = 11 AND "spree_prices"."currency" = 'USD' LIMIT 1 | |
| SQL (0.4ms) UPDATE "spree_adjustments" SET "amount" = 5.0 WHERE "spree_adjustments"."id" = 77 | |
| SQL (0.2ms) UPDATE "spree_adjustments" SET "eligible" = 't' WHERE "spree_adjustments"."id" = 77 | |
| Spree::Payment Load (0.2ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| Spree::Adjustment Load (1.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| SQL (0.4ms) UPDATE "spree_orders" SET "payment_state" = NULL, "shipment_state" = NULL, "item_total" = 18.05, "adjustment_total" = 5.0, "payment_total" = 0.0, "total" = 23.05 WHERE "spree_orders"."id" = 1540 | |
| Gateway Error | |
| --- !ruby/object:PayPal::SDK::Merchant::DataTypes::DoExpressCheckoutPaymentResponseType | |
| Timestamp: !ruby/object:DateTime 2013-11-14 04:55:04.000000000 Z | |
| Ack: !ruby/string:PayPal::SDK::Merchant::DataTypes::AckCodeType |- | |
| RmFpbHVyZQ== | |
| CorrelationID: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |- | |
| MTFkOGY4YTM4YzViNg== | |
| Errors: !ruby/array:PayPal::SDK::Core::API::DataTypes::ArrayWithBlock | |
| internal: | |
| - !ruby/object:PayPal::SDK::Merchant::DataTypes::ErrorType | |
| ShortMessage: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |- | |
| VHJhbnNhY3Rpb24gcmVmdXNlZCBiZWNhdXNlIG9mIGFuIGludmFsaWQgYXJn | |
| dW1lbnQuIFNlZSBhZGRpdGlvbmFsIGVycm9yIG1lc3NhZ2VzIGZvciBkZXRh | |
| aWxzLg== | |
| LongMessage: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |- | |
| VGhlIHRvdGFscyBvZiB0aGUgY2FydCBpdGVtIGFtb3VudHMgZG8gbm90IG1h | |
| dGNoIG9yZGVyIGFtb3VudHMu | |
| ErrorCode: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |- | |
| MTA0MTM= | |
| SeverityCode: !ruby/string:PayPal::SDK::Merchant::DataTypes::SeverityCodeType |- | |
| RXJyb3I= | |
| ivars: | |
| :@block: !ruby/object:Proc {} | |
| Version: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |- | |
| MTA2LjA= | |
| Build: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |- | |
| ODQ1MTg3Mw== | |
| DoExpressCheckoutPaymentResponseDetails: | |
| (0.4ms) ROLLBACK | |
| (0.1ms) BEGIN | |
| (0.6ms) UPDATE "spree_payments" SET "state" = 'failed', "updated_at" = '2013-11-14 04:55:05.490063' WHERE "spree_payments"."id" = 42 | |
| Spree::Payment Load (0.4ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 | |
| Spree::Payment Load (0.3ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| Spree::Adjustment Load (0.4ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.4ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::PromotionAction' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::PromotionAction' AND "spree_adjustments"."eligible" = 't' ORDER BY amount ASC, created_at DESC LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.3ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::ShippingMethod' ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.2ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."id" = $1 LIMIT 1 [["id", 77]] | |
| Spree::ShippingMethod Load (0.5ms) SELECT "spree_shipping_methods".* FROM "spree_shipping_methods" WHERE "spree_shipping_methods"."deleted_at" IS NULL AND "spree_shipping_methods"."id" = 3 LIMIT 1 | |
| Spree::Shipment Load (0.2ms) SELECT "spree_shipments".* FROM "spree_shipments" WHERE "spree_shipments"."id" = 78 LIMIT 1 | |
| Spree::StockLocation Load (0.2ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = 1 LIMIT 1 | |
| Spree::Order Load (0.3ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 LIMIT 1 | |
| Spree::InventoryUnit Load (0.2ms) SELECT "spree_inventory_units".* FROM "spree_inventory_units" WHERE "spree_inventory_units"."shipment_id" = 78 | |
| Spree::Variant Load (0.7ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" IN (11) AND ("spree_variants".deleted_at IS NULL) | |
| Spree::Calculator Load (1.8ms) SELECT "spree_calculators".* FROM "spree_calculators" WHERE "spree_calculators"."calculable_id" = 3 AND "spree_calculators"."calculable_type" = 'Spree::ShippingMethod' LIMIT 1 | |
| Spree::Price Load (0.4ms) SELECT "spree_prices".* FROM "spree_prices" WHERE "spree_prices"."variant_id" = 11 AND "spree_prices"."currency" = 'USD' LIMIT 1 | |
| SQL (0.2ms) UPDATE "spree_adjustments" SET "amount" = 5.0 WHERE "spree_adjustments"."id" = 77 | |
| SQL (0.2ms) UPDATE "spree_adjustments" SET "eligible" = 't' WHERE "spree_adjustments"."id" = 77 | |
| Spree::Payment Load (0.2ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| Spree::Adjustment Load (0.8ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| SQL (0.4ms) UPDATE "spree_orders" SET "payment_state" = NULL, "shipment_state" = NULL, "item_total" = 18.05, "adjustment_total" = 5.0, "payment_total" = 0.0, "total" = 23.05 WHERE "spree_orders"."id" = 1540 | |
| (0.4ms) COMMIT | |
| Spree::Payment Load (0.4ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."id" = 42 LIMIT 1 | |
| (0.2ms) BEGIN | |
| SQL (0.6ms) INSERT INTO "spree_log_entries" ("created_at", "details", "source_id", "source_type", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", Thu, 14 Nov 2013 04:55:05 UTC +00:00], ["details", "--- !ruby/object:PayPal::SDK::Merchant::DataTypes::DoExpressCheckoutPaymentResponseType\nTimestamp: !ruby/object:DateTime 2013-11-14 04:55:04.000000000 Z\nAck: !ruby/string:PayPal::SDK::Merchant::DataTypes::AckCodeType |-\n RmFpbHVyZQ==\nCorrelationID: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |-\n MTFkOGY4YTM4YzViNg==\nErrors: !ruby/array:PayPal::SDK::Core::API::DataTypes::ArrayWithBlock\n internal:\n - !ruby/object:PayPal::SDK::Merchant::DataTypes::ErrorType\n ShortMessage: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |-\n VHJhbnNhY3Rpb24gcmVmdXNlZCBiZWNhdXNlIG9mIGFuIGludmFsaWQgYXJn\n dW1lbnQuIFNlZSBhZGRpdGlvbmFsIGVycm9yIG1lc3NhZ2VzIGZvciBkZXRh\n aWxzLg==\n LongMessage: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |-\n VGhlIHRvdGFscyBvZiB0aGUgY2FydCBpdGVtIGFtb3VudHMgZG8gbm90IG1h\n dGNoIG9yZGVyIGFtb3VudHMu\n ErrorCode: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |-\n MTA0MTM=\n SeverityCode: !ruby/string:PayPal::SDK::Merchant::DataTypes::SeverityCodeType |-\n RXJyb3I=\n ivars:\n :@block: !ruby/object:Proc {}\nVersion: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |-\n MTA2LjA=\nBuild: !ruby/string:PayPal::SDK::Core::API::DataTypes::SimpleTypes::String |-\n ODQ1MTg3Mw==\nDoExpressCheckoutPaymentResponseDetails: \n"], ["source_id", 42], ["source_type", "Spree::Payment"], ["updated_at", Thu, 14 Nov 2013 04:55:05 UTC +00:00]] | |
| (0.4ms) COMMIT | |
| Redirected to http://localhost:3000/checkout/payment | |
| Completed 302 Found in 5166.5ms (ActiveRecord: 53.6ms) | |
| Started GET "/checkout/payment" for 127.0.0.1 at 2013-11-14 12:55:05 +0800 | |
| Spree::Page Exists (1.6ms) SELECT 1 AS one FROM "spree_pages" WHERE "spree_pages"."visible" = 't' AND (("spree_pages"."slug" = 'checkout/payment' OR "spree_pages"."slug" = '/checkout/payment')) ORDER BY position ASC LIMIT 1 | |
| CACHE (0.0ms) SELECT 1 AS one FROM "spree_pages" WHERE "spree_pages"."visible" = 't' AND (("spree_pages"."slug" = 'checkout/payment' OR "spree_pages"."slug" = '/checkout/payment')) ORDER BY position ASC LIMIT 1 | |
| Deface: 1 overrides found for 'spree/checkout/edit' | |
| Deface: 'move_checkout_header_to_layout_subheader' matched 1 times with '[data-hook="checkout_header"]' | |
| Deface: [WARNING] No :original defined for 'move_checkout_header_to_layout_subheader', you should change its definition to include: | |
| :original => '14750f5f6800a5c2597e6cce4273df2406862135' | |
| Processing by Spree::CheckoutController#edit as HTML | |
| Parameters: {"state"=>"payment"} | |
| Spree::User Load (0.8ms) SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."id" = 1 LIMIT 1 | |
| Spree::Preference Load (1.1ms) SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = 'spree/frontend_configuration/locale' LIMIT 1 | |
| Spree::Order Load (5.4ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."user_id" = 1 AND "spree_orders"."completed_at" IS NULL AND "spree_orders"."created_by_id" = 1 ORDER BY created_at DESC LIMIT 1 | |
| Spree::Order Load (5.2ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 AND "spree_orders"."currency" = 'USD' LIMIT 1 | |
| Spree::Adjustment Load (0.5ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."adjustable_id" IN (1540) ORDER BY created_at ASC | |
| Spree::Payment Load (0.5ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| Spree::LineItem Load (0.8ms) SELECT "spree_line_items".* FROM "spree_line_items" WHERE "spree_line_items"."order_id" = 1540 ORDER BY created_at ASC | |
| Spree::Adjustment Load (0.5ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| (1.3ms) SELECT COUNT(*) FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 | |
| Spree::Payment Load (1.2ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 | |
| Spree::PaymentMethod Load (8.0ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = 5 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND "spree_payment_methods"."id" = 5 AND ("spree_payment_methods".deleted_at IS NULL) LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| CACHE (0.0ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| CACHE (0.0ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| (0.5ms) SELECT COUNT(*) FROM "spree_line_items" WHERE "spree_line_items"."order_id" = 1540 | |
| (0.4ms) SELECT SUM("spree_stock_items"."count_on_hand") AS sum_id FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."variant_id" = 11 AND "spree_stock_locations"."active" = 't' AND ("spree_stock_items".deleted_at IS NULL) | |
| Spree::StockItem Load (0.3ms) SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."variant_id" = 11 AND "spree_stock_locations"."active" = 't' AND ("spree_stock_items".deleted_at IS NULL) | |
| CACHE (0.0ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| CACHE (0.0ms) SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."id" = 1 LIMIT 1 | |
| CACHE (0.0ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| Spree::Shipment Load (1.1ms) SELECT "spree_shipments".* FROM "spree_shipments" WHERE "spree_shipments"."order_id" = 1540 | |
| Spree::StockLocation Load (0.3ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = 1 LIMIT 1 | |
| Spree::Order Load (0.6ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 LIMIT 1 | |
| Spree::InventoryUnit Load (0.3ms) SELECT "spree_inventory_units".* FROM "spree_inventory_units" WHERE "spree_inventory_units"."shipment_id" = 78 | |
| Spree::Variant Load (0.3ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" IN (11) AND ("spree_variants".deleted_at IS NULL) | |
| Spree::Variant Load (0.2ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" = 11 LIMIT 1 | |
| (0.4ms) SELECT COUNT(*) FROM "spree_roles" INNER JOIN "spree_roles_users" ON "spree_roles"."id" = "spree_roles_users"."role_id" WHERE "spree_roles_users"."user_id" = 1 AND "spree_roles"."name" = 'admin' | |
| Deface: 1 overrides found for 'spree/checkout/edit' | |
| Deface: 'move_checkout_header_to_layout_subheader' matched 1 times with '[data-hook="checkout_header"]' | |
| Deface: [WARNING] No :original defined for 'move_checkout_header_to_layout_subheader', you should change its definition to include: | |
| :original => '14750f5f6800a5c2597e6cce4273df2406862135' | |
| Deface: 7 overrides found for 'spree/layouts/spree_application' | |
| Deface: 'add_container_to_wrapper' matched 1 times with '#wrapper' | |
| Deface: [WARNING] No :original defined for 'add_container_to_wrapper', you should change its definition to include: | |
| :original => 'b783e7268d2ab196e65a32bc048cf6af2627dd06' | |
| Deface: 'add_mobile_navigation' matched 0 times with '[data-hook="body"]' | |
| Deface: 'add_slider_pager_to_wrapper' matched 1 times with '#wrapper' | |
| Deface: [WARNING] No :original defined for 'add_slider_pager_to_wrapper', you should change its definition to include: | |
| :original => '128eb031d328cb9bdbe9668fb82275f82cbbe4c4' | |
| Deface: 'unwrap_header_from_container_class' matched 1 times with '.container' | |
| Deface: [WARNING] No :original defined for 'unwrap_header_from_container_class', you should change its definition to include: | |
| :original => '6aeaab163e0e7c9ddcd8e8cfe797dc800f864ffc' | |
| Deface: 'add_subheader_to_layout' matched 1 times with '#wrapper' | |
| Deface: [WARNING] No :original defined for 'add_subheader_to_layout', you should change its definition to include: | |
| :original => 'a37b596967add3ea616dc60952a6b19e51e9b472' | |
| Deface: 'move_breadcrumb_inside_subheader' matched 1 times with '#subheader .subheader-wrapper' | |
| Deface: [WARNING] No :original defined for 'move_breadcrumb_inside_subheader', you should change its definition to include: | |
| :original => 'f3eec6288684efe3052aa74a68a22354cf3ebe4c' | |
| Deface: 'remove_breadcrumb_from_main_container' matched 1 times with '#wrapper > code:contains("breadcrumbs(@taxon)")' | |
| Deface: [WARNING] No :original defined for 'remove_breadcrumb_from_main_container', you should change its definition to include: | |
| :original => '72944bdd49a37f4721106a9794823dce41f4c306' | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/core/app/views/spree/shared/_error_messages.html.erb (0.2ms) | |
| CACHE (0.0ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 1540 AND "spree_payments"."state" = 'completed' | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| Deface: 2 overrides found for 'spree/checkout/_payment' | |
| Deface: 'add_icon_to_payment_submit_button' matched 1 times with 'code:contains("submit_tag Spree.t(:save_and_continue)")' | |
| Deface: [WARNING] No :original defined for 'add_icon_to_payment_submit_button', you should change its definition to include: | |
| :original => 'f87239cbe8641e902da84ab6631f2decf80103fa' | |
| Deface: 'make_payment_method_selection_as_a_button' matched starting with 'code:contains("@order.available_payment_methods.each")' and ending with 'code:contains("end")' | |
| Spree::PaymentMethod Load (0.6ms) SELECT "spree_payment_methods".* FROM "spree_payment_methods" WHERE "spree_payment_methods"."deleted_at" IS NULL AND ("spree_payment_methods".deleted_at IS NULL) | |
| Spree::Address Load (0.6ms) SELECT "spree_addresses".* FROM "spree_addresses" WHERE "spree_addresses"."id" = 100 LIMIT 1 | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/checkout/payment/_gateway.html.erb (9.2ms) | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/better_spree_paypal_express-0f3932184525/app/views/spree/checkout/payment/_paypal.html.erb (0.7ms) | |
| (0.4ms) SELECT COUNT(*) FROM "spree_activators" WHERE "spree_activators"."type" IN ('Spree::Promotion') AND "spree_activators"."event_name" = 'spree.checkout.coupon_code_added' | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/checkout/_payment.html.erb (29.1ms) | |
| CACHE (0.0ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 1540 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC | |
| CACHE (0.0ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 1540 LIMIT 1 | |
| Spree::Adjustment Load (0.7ms) SELECT "spree_adjustments".* FROM "spree_adjustments" INNER JOIN "spree_line_items" ON "spree_adjustments"."adjustable_id" = "spree_line_items"."id" AND "spree_adjustments"."adjustable_type" = 'Spree::LineItem' WHERE "spree_line_items"."order_id" = 1540 AND "spree_adjustments"."eligible" = 't' | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/checkout/_summary.html.erb (8.2ms) | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/checkout/edit.html.erb within spree/layouts/spree_application (77.0ms) | |
| Deface: 2 overrides found for 'spree/shared/_head' | |
| Deface: 'add_print_stylesheet' matched 1 times with 'code:contains("csrf_meta_tags")' | |
| Deface: [WARNING] No :original defined for 'add_print_stylesheet', you should change its definition to include: | |
| :original => 'b7ad84db3162a7f3a6b3286677d73ba1ee84f047' | |
| Deface: 'add_to_head' matched 1 times with 'code[erb-loud]:contains('meta_data_tags')' | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/core/app/views/spree/shared/_routes.html.erb (0.7ms) | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/shared/_head.html.erb (37.5ms) | |
| Deface: 2 overrides found for 'spree/shared/_header' | |
| Deface: 'replace_logo_grid_class' matched 1 times with '#logo' | |
| Deface: [WARNING] No :original defined for 'replace_logo_grid_class', you should change its definition to include: | |
| :original => '1d1c79977051248cdd96489f1225bfd1f64dd1ef' | |
| Deface: 'wrap_header_content_with_container_class' matched 1 times with '#header' | |
| Deface: [WARNING] No :original defined for 'wrap_header_content_with_container_class', you should change its definition to include: | |
| :original => '487a1abc9205d68676af35afc2af46e7e93a77f0' | |
| Deface: 7 overrides found for 'spree/shared/_nav_bar' | |
| Deface: 'auth_shared_login_bar' matched 1 times with 'li#search-bar' | |
| Deface: 'add_cart_link' matched 1 times with '#nav-bar' | |
| Deface: [WARNING] No :original defined for 'add_cart_link', you should change its definition to include: | |
| :original => 'b30bdf27e0930d6b3dd36d944b8d102c03fdb97f' | |
| Deface: 'add_search_icon_to_nav_bar' matched 1 times with '#search-bar' | |
| Deface: [WARNING] No :original defined for 'add_search_icon_to_nav_bar', you should change its definition to include: | |
| :original => 'eb3fa668cd98b6a1c75c36420ef1b238a1fc55ac' | |
| Deface: 'replace_nav_bar_grid_classes' matched 1 times with '#top-nav-bar' | |
| Deface: [WARNING] No :original defined for 'replace_nav_bar_grid_classes', you should change its definition to include: | |
| :original => '54f3107a99d0816d6b2649b7504bbd8da77c9a90' | |
| Deface: 'replace_logout_with_icon' matched 1 times with 'code:contains("Spree.t(:logout)")' | |
| Deface: [WARNING] No :original defined for 'replace_logout_with_icon', you should change its definition to include: | |
| :original => '568961154b4968b22b127fee211ecaa333a32241' | |
| Deface: 'replace_my_account_with_icon' matched 1 times with 'code:contains("Spree.t(:my_account)")' | |
| Deface: [WARNING] No :original defined for 'replace_my_account_with_icon', you should change its definition to include: | |
| :original => '775a69b7662a4914649827f3421c70464f7e23c1' | |
| Deface: 'replace_login_with_icon' matched 1 times with 'code:contains("Spree.t(:login)")' | |
| Deface: [WARNING] No :original defined for 'replace_login_with_icon', you should change its definition to include: | |
| :original => 'c99948f50c4cf2df5c3a36456faef39d15f74eb5' | |
| Deface: 2 overrides found for 'spree/shared/_search' | |
| Deface: 'remove_search_button' matched 1 times with 'code:contains("submit_tag Spree.t(:search)")' | |
| Deface: [WARNING] No :original defined for 'remove_search_button', you should change its definition to include: | |
| :original => '0e3ccc641e309928a63debf5967133151f0bc407' | |
| Deface: 'remove_taxon_search_select' matched 1 times with 'code:contains("select_tag :taxon")' | |
| Deface: [WARNING] No :original defined for 'remove_taxon_search_select', you should change its definition to include: | |
| :original => '167737e00dc030a9fa0de115339d2e1a20c43fee' | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/shared/_search.html.erb (2.3ms) | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/shared/_nav_bar.html.erb (15.8ms) | |
| Deface: 5 overrides found for 'spree/shared/_main_nav_bar' | |
| Deface: 'pages_in_header' matched 1 times with '#main-nav-bar' | |
| Deface: [WARNING] No :original defined for 'pages_in_header', you should change its definition to include: | |
| :original => 'db2835f20e2ab66e854a74f6ae2a05cfb86f20fd' | |
| Deface: 'insert_menu_trigger_link_to_main_menu' matched 1 times with '#main-nav-bar' | |
| Deface: [WARNING] No :original defined for 'insert_menu_trigger_link_to_main_menu', you should change its definition to include: | |
| :original => '4309a2e7e0fffab7320abc552486f755d55342d3' | |
| Deface: 'insert_shop_link_to_main_menu' matched 1 times with '#home-link' | |
| Deface: [WARNING] No :original defined for 'insert_shop_link_to_main_menu', you should change its definition to include: | |
| :original => 'a4890d2d334f58a60097ab531c88df2193f86e61' | |
| Deface: 'remove_cart_link' matched 1 times with '#link-to-cart' | |
| Deface: [WARNING] No :original defined for 'remove_cart_link', you should change its definition to include: | |
| :original => '0d843946b3a53643c5a7da90a3a21610208db866' | |
| Deface: 'replace_main_nav_bar_grid_classes' matched 1 times with 'nav' | |
| Deface: [WARNING] No :original defined for 'replace_main_nav_bar_grid_classes', you should change its definition to include: | |
| :original => 'b1336cfebe7708d6020b5d24428d08c660a9667d' | |
| Spree::Page Load (0.5ms) SELECT "spree_pages".* FROM "spree_pages" WHERE "spree_pages"."show_in_header" = 't' AND "spree_pages"."visible" = 't' ORDER BY position ASC | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree_static_content-a9d17d7fe22b/app/views/spree/static_content/_static_content_list.html.erb (0.0ms) | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/shared/_main_nav_bar.html.erb (8.2ms) | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/spree-0840e2335a08/frontend/app/views/spree/shared/_header.html.erb (56.0ms) | |
| Deface: 1 overrides found for 'spree/shared/_footer' | |
| Deface: 'pages_in_footer' matched 0 times with '#footer-right' | |
| Rendered /Users/samhamilton/.rvm/gems/ruby-2.0.0-p247@zooron/bundler/gems/zooron_spree_fancy-1ac5d082f754/app/views/spree/shared/_footer.html.erb (1.1ms) | |
| Spree::Tracker Load (0.9ms) SELECT "spree_trackers".* FROM "spree_trackers" WHERE "spree_trackers"."active" = 't' AND "spree_trackers"."environment" = 'development' LIMIT 1 | |
| Rendered spree/shared/_google_analytics.html.erb (2.5ms) | |
| Completed 200 OK in 600.6ms (Views: 521.6ms | ActiveRecord: 33.5ms) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment