Error Processing Checkout
-
Hello, my whole wordpress installation is working fine, and so is wooocommerce, the only thing not working is the checkout. I have the logs to attatch below, can you help me fix this please
ordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_woocommerce_sessions (
session_key,session_value,session_expiry) VALUES (‘t_660b9f61d654e3ff033580cc2e87bc’, ‘a:14:{s:4:\”cart\”;s:482:\”a:1:{s:32:\”5b57b2f48ab3fc410ac2827457a954a7\”;a:11:{s:3:\”key\”;s:32:\”5b57b2f48ab3fc410ac2827457a954a7\”;s:10:\”product_id\”;i:163108;s:12:\”variation_id\”;i:0;s:9:\”variation\”;a:0:{}s:8:\”quantity\”;i:3;s:9:\”data_hash\”;s:32:\”b5c1d5ca8bae6d4896cf1807cdf763f0\”;s:13:\”line_tax_data\”;a:2:{s:8:\”subtotal\”;a:1:{i:1;d:731.0939999999999;}s:5:\”total\”;a:1:{i:1;d:731.0939999999999;}}s:13:\”line_subtotal\”;d:3655.47;s:17:\”line_subtotal_tax\”;d:731.09;s:10:\”line_total\”;d:3655.47;s:8:\”line_tax\”;d:731.09;}}\”;s:11:\”cart_totals\”;s:433:\”a:15:{s:8:\”subtotal\”;s:7:\”3655.47\”;s:12:\”subtotal_tax\”;d:731.09;s:14:\”shipping_total\”;s:1:\”0\”;s:12:\”shipping_tax\”;d:0;s:14:\”shipping_taxes\”;a:0:{}s:14:\”discount_total\”;d:0;s:12:\”discount_tax\”;d:0;s:19:\”cart_contents_total\”;s:7:\”3655.47\”;s:17:\”cart_contents_tax\”;d:731.09;s:19:\”cart_contents_taxes\”;a:1:{i:1;d:731.09;}s:9:\”fee_total\”;s:1:\”0\”;s:7:\”fee_tax\”;d:0;s:9:\”fee_taxes\”;a:0:{}s:5:\”total\”;s:7:\”4386.56\”;s:9:\”total_tax\”;d:731.09;}\”;s:15:\”applied_coupons\”;s:6:\”a:0:{}\”;s:22:\”coupon_discount_totals\”;s:6:\”a:0:{}\”;s:26:\”coupon_discount_tax_totals\”;s:6:\”a:0:{}\”;s:21:\”removed_cart_contents\”;s:6:\”a:0:{}\”;s:25:\”previous_shipping_methods\”;s:165:\”a:1:{i:0;a:4:{i:0;s:16:\”free_shipping:23\”;i:1;s:25:\”wbs:17:60d2e80b_overnight\”;i:2;s:27:\”wbs:18:3d4af855_am_delivery\”;i:3;s:33:\”wbs:19:b3a95e97_10_30_am_delivery\”;}}\”;s:23:\”chosen_shipping_methods\”;s:34:\”a:1:{i:0;s:16:\”free_shipping:23\”;}\”;s:22:\”shipping_method_counts\”;s:14:\”a:1:{i:0;i:4;}\”;s:10:\”wc_notices\”;N;s:8:\”customer\”;s:994:\”a:27:{s:2:\”id\”;s:1:\”0\”;s:13:\”date_modified\”;s:0:\”\”;s:8:\”postcode\”;s:6:\”TF17gy\”;s:4:\”city\”;s:7:\”Telford\”;s:9:\”address_1\”;s:21:\”Unit 12, Horton Court\”;s:7:\”address\”;s:21:\”Unit 12, Horton Court\”;s:9:\”address_2\”;s:15:\”, Hortonwood 50\”;s:5:\”state\”;s:12:\”Warwickshire\”;s:7:\”country\”;s:2:\”GB\”;s:17:\”shipping_postcode\”;s:6:\”TF17gy\”;s:13:\”shipping_city\”;s:7:\”Telford\”;s:18:\”shipping_address_1\”;s:21:\”Unit 12, Horton Court\”;s:16:\”shipping_address\”;s:21:\”Unit 12, Horton Court\”;s:18:\”shipping_address_2\”;s:15:\”, Hortonwood 50\”;s:14:\”shipping_state\”;s:12:\”Warwickshire\”;s:16:\”shipping_country\”;s:2:\”GB\”;s:13:\”is_vat_exempt\”;s:0:\”\”;s:19:\”calculated_shipping\”;s:1:\”1\”;s:10:\”first_name\”;s:4:\”Andy\”;s:9:\”last_name\”;s:6:\”Bowyer\”;s:7:\”company\”;s:17:\”AC Electric Motor\”;s:5:\”phone\”;s:11:\”07593204996\”;s:5:\”email\”;s:24:\”[email protected]\”;s:19:\”shipping_first_name\”;s:4:\”Andy\”;s:18:\”shipping_last_name\”;s:6:\”Bowyer\”;s:16:\”shipping_company\”;s:17:\”AC Electric Motor\”;s:14:\”shipping_phone\”;s:11:\”07593204996\”;}\”;s:21:\”chosen_payment_method\”;s:4:\”bacs\”;s:14:\”wcf_session_id\”;s:32:\”59c563f210a0925eac85e5a7cb6bf544\”;s:22:\”shipping_for_package_0\”;s:1388:\”a:2:{s:12:\”package_hash\”;s:40:\”wc_ship_ed3ddeb3b98c324180912851bb1fd06a\”;s:5:\”rates\”;a:4:{s:16:\”free_shipping:23\”;O:16:\”WC_Shipping_Rate\”:2:{s:7:\”\0*\0data\”;a:6:{s:2:\”id\”;s:16:\”free_shipping:23\”;s:9:\”method_id\”;s:13:\”free_shipping\”;s:11:\”instance_id\”;i:23;s:5:\”label\”;s:13:\”Free shipping\”;s:4:\”cost\”;s:4:\”0.00\”;s:5:\”taxes\”;a:0:{}}s:12:\”\0*\0meta_data\”;a:1:{s:5:\”Items\”;s:143:\”TEC Three Phase Electric Brake Motor, 7.5KW, (10HP), Flange Mounted(B35), 1500rpm(4 pole), IE2 efficiency, 132M Frame, Aluminium Body × 3\”;}}s:25:\”wbs:17:60d2e80b_overnight\”;O:16:\”WC_Shipping_Rate\”:2:{s:7:\”\0*\0data\”;a:6:{s:2:\”id\”;s:25:\”wbs:17:60d2e80b_overnight\”;s:9:\”method_id\”;s:3:\”wbs\”;s:11:\”instance_id\”;i:17;s:5:\”label\”;s:9:\”Overnight\”;s:4:\”cost\”;s:5:\”15.00\”;s:5:\”taxes\”;a:1:{i:1;d:3;}}s:12:\”\0*\0meta_data\”;a:0:{}}s:27:\”wbs:18:3d4af855_am_delivery\”;O:16:\”WC_Shipping_Rate\”:2:{s:7:\”\0*\0data\”;a:6:{s:2:\”id\”;s:27:\”wbs:18:3d4af855_am_delivery\”;s:9:\”method_id\”;s:3:\”wbs\”;s:11:\”instance_id\”;i:18;s:5:\”label\”;s:11:\”AM Delivery\”;s:4:\”cost\”;s:5:\”44.00\”;s:5:\”taxes\”;a:1:{i:1;d:8.8;}}s:12:\”\0*\0meta_data\”;a:0:{}}s:33:\”wbs:19:b3a95e97_10_30_am_delivery\”;O:16:\”WC_Shipping_Rate\”:2:{s:7:\”\0*\0data\”;a:6:{s:2:\”id\”;s:33:\”wbs:19:b3a95e97_10_30_am_delivery\”;s:9:\”method_id\”;s:3:\”wbs\”;s:11:\”instance_id\”;i:19;s:5:\”label\”;s:17:\”10:30 AM Delivery\”;s:4:\”cost\”;s:5:\”58.67\”;s:5:\”taxes\”;a:1:{i:1;d:11.734;}}s:12:\”\0*\0meta_data\”;a:0:{}}}}\”;}’, 1683896232)ON DUPLICATE KEY UPDATE
session_value= VALUES(session_value),session_expiry= VALUES(session_expiry) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data[10-May-2023 13:06:22 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM
wp_woocommerce_sessionsmade by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data, WC_Session_Handler->delete_session
-
Hi @jj1423
Thanks for reaching out!
I am sorry to hear that you are receiving the error message above when trying to complete a checkout process on your site.
I checked your site, however, I am encountering a different error on your site’s checkout page:
There are no shipping options available. Please ensure that your address has been entered correctly, or contact us if you need any help.Hence, I am unable to complete the checkout process even after changing the country to UK or US.
The error message above appears if you have not set up your shipping zones as suggested in this support documentation: https://woocommerce.com/documentation/woocommerce/getting-started/shipping/
If you have set up the shipping zones correctly and still the issue persists, please provide us with a clear screenshot of the following settings below:
- General Settings (WooCommerce > Settings > General)
- Shipping Settings (WooCommerce > Settings > Shipping)
If you don’t already have a screenshot service installed, you can try https://snipboard.io. You can share the direct link to the image as a response to this topic.
Meanwhile, as per the error logs, these are pointing to your theme:
ourtheme. I can see that you also haveOutdated Templates: ?too. Please update outdated templates on your site by following our guide here: Fixing Outdated WooCommerce TemplatesFurthermore, since this is a third-party product that we don’t provide support for based on our Support Policy, I recommend that you reach out to the developers of the plugin for further assistance. They will be better equipped to help you resolve any issues you’re experiencing with the plugin.
All the best and hopefully, the issue will be fixed soon.
- The topic ‘Error Processing Checkout’ is closed to new replies.
