DATABASE ERROR
-
Hello,
after the last update of woocommerce i get this error on the database:WordPress errore sul database Commands out of sync; you can’t run this command now per la query INSERT INTO wpzw_woocommerce_sessions (
session_key,session_value,session_expiry) VALUES (‘t_8c6521ec2d40b5d1fb700904d07c26’, ‘a:8:{s:4:\”ppcp\”;s:364:\”O:49:\”WooCommerce\\PayPalCommerce\\Session\\SessionHandler\”:4:{s:56:\”\0WooCommerce\\PayPalCommerce\\Session\\SessionHandler\0order\”;N;s:58:\”\0WooCommerce\\PayPalCommerce\\Session\\SessionHandler\0bn_code\”;s:0:\”\”;s:77:\”\0WooCommerce\\PayPalCommerce\\Session\\SessionHandler\0insufficient_funding_tries\”;i:0;s:65:\”\0WooCommerce\\PayPalCommerce\\Session\\SessionHandler\0funding_source\”;N;}\”;s:4:\”cart\”;s:6:\”a:0:{}\”;s:11:\”cart_totals\”;s:367:\”a:15:{s:8:\”subtotal\”;i:0;s:12:\”subtotal_tax\”;i:0;s:14:\”shipping_total\”;i:0;s:12:\”shipping_tax\”;i:0;s:14:\”shipping_taxes\”;a:0:{}s:14:\”discount_total\”;i:0;s:12:\”discount_tax\”;i:0;s:19:\”cart_contents_total\”;i:0;s:17:\”cart_contents_tax\”;i:0;s:19:\”cart_contents_taxes\”;a:0:{}s:9:\”fee_total\”;i:0;s:7:\”fee_tax\”;i:0;s:9:\”fee_taxes\”;a:0:{}s:5:\”total\”;i:0;s:9:\”total_tax\”;i:0;}\”;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:8:\”customer\”;s:720:\”a:27:{s:2:\”id\”;s:1:\”0\”;s:13:\”date_modified\”;s:0:\”\”;s:8:\”postcode\”;s:0:\”\”;s:4:\”city\”;s:0:\”\”;s:9:\”address_1\”;s:0:\”\”;s:7:\”address\”;s:0:\”\”;s:9:\”address_2\”;s:0:\”\”;s:5:\”state\”;s:2:\”AG\”;s:7:\”country\”;s:2:\”IT\”;s:17:\”shipping_postcode\”;s:0:\”\”;s:13:\”shipping_city\”;s:0:\”\”;s:18:\”shipping_address_1\”;s:0:\”\”;s:16:\”shipping_address\”;s:0:\”\”;s:18:\”shipping_address_2\”;s:0:\”\”;s:14:\”shipping_state\”;s:2:\”AG\”;s:16:\”shipping_country\”;s:2:\”IT\”;s:13:\”is_vat_exempt\”;s:0:\”\”;s:19:\”calculated_shipping\”;s:0:\”\”;s:10:\”first_name\”;s:0:\”\”;s:9:\”last_name\”;s:0:\”\”;s:7:\”company\”;s:0:\”\”;s:5:\”phone\”;s:0:\”\”;s:5:\”email\”;s:0:\”\”;s:19:\”shipping_first_name\”;s:0:\”\”;s:18:\”shipping_last_name\”;s:0:\”\”;s:16:\”shipping_company\”;s:0:\”\”;s:14:\”shipping_phone\”;s:0:\”\”;}\”;}’, 1664611773)
ON DUPLICATE KEY UPDATEsession_value= VALUES(session_value),session_expiry= VALUES(session_expiry) fatta da shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data
-
Hi there @tendenzeshabbychic ??
Sorry for the delay, the problem occurred immediately after activating Paypal, before I had standard paypal
I see. From what I understand, when the
WooCommerce PayPal Paymentsplugin is active, as seen in the System Status Report you are sending us, the database error appears. Could you please share a screenshot of the screen where you see the error? https://snipboard.io/ is a reliable tool for sharing that over here with us.Next-up, I’d like you to go ahead with updating the following:
– WC Version: 6.9.4
– WC Database Version: 6.9.4
– WooCommerce PayPal Payments: by WooCommerce – 1.9.3The plugins can be updated from the WordPress dashboard, under
Dashboard > Updates. As for the WooCommerce database version, head toWooCommerce > Status > Tools. Feel free toVerify base database tablesalso, while you are on that screen.Do you still see the error screen, after completing the updates?
Should the issue persist, I would suggest following the troubleshooting steps outlined here.
Let us know how that goes!
- The topic ‘DATABASE ERROR’ is closed to new replies.
