Database Update Pending
-
I have a problem with the Woocommerce Database Update pending:
In the status it says woocommerce_cleanup_draft_orders
- all?(4)
- Complete?(1)
- Pending?(3)
- Past-due?(2)
Ive tried everything from all the (un)solved topics, disabled all plugins, only woocommerce active and 2020 theme.. still no change.
-
Hi @vdub_nl,
When you manually delete content from a table in your database via PHPMyAdmin, it doesn’t automatically update the database version. The database version is usually only updated when a new release or update of WooCommerce includes database changes.
However, you can use the Update database tool to update the WooComemrce database. To do so, navigate to WooCommerce > Status > Tools.
Additionally, past-due actions are tasks that have missed their scheduled dates. This is not uncommon due to the nature of WP Cron. However, multiple past-due actions over a day old could signal an issue with WP Cron on your website.
You can use the Advanced Cron Manager plugin to see what’s going on.
You may also find this guide helpful in debugging WP Cron:
- https://devknoll.net/debugging-wp-cron-delayed-task-execution/
- https://www.linsoftware.com/how-to-debug-wordpress-wp-cron-jobs/
- https://edywerder.ch/how-to-troubleshoot-wordpress-cron-jobs/
- https://4it.com.au/kb/article/wordpress-cron-missing-schedule-easy-fix/
- https://betternotificationsforwp.com/guides/troubleshooting-wp-cron/
If you are still having problems, we recommend contacting your hosting provider for further assassinate.
I hope this clarifies your concern. If you have any other questions, feel free to ask.
I dont think those logfiles will help..
Viewing log file wc-myparcel-2024-04-04 Download Delete permanently 2024-04-04T14:24:50+00:00 Debug *** Creating shipments started *** 2024-04-04T14:24:50+00:00 Debug Shipment data for order 881. 2024-04-04T14:24:51+00:00 Debug 1 zendingen met succes ge?xporteerd naar Myparcel 2024-04-04T14:24:51+00:00 Debug ids: 182629036Viewing log file mollie-payments-for-woocommerce-2024-04-04 Download Delete permanently 2024-04-04T13:51:13+00:00 Debug ideal: Start process_payment for order 881 Additional context 2024-04-04T13:51:13+00:00 Debug mollie_wc_gateway_ideal: Create Mollie payment object for order 881 Additional context 2024-04-04T13:51:13+00:00 Debug Order 881 returnUrl: https://vagperformancecenter.nl/afrekenen/order-received/881/?key=wc_order_sT8yTXFI7xwJ5&order_id=881&filter_flag=onMollieReturn Additional context 2024-04-04T13:51:13+00:00 Debug Order 881 webhookUrl: https://vagperformancecenter.nl/wc-api/mollie_wc_gateway_ideal?order_id=881&key=wc_order_sT8yTXFI7xwJ5&filter_flag Additional context 2024-04-04T13:51:13+00:00 Debug Creating payment object: type Order, first try creating a Mollie Order. 2024-04-04T13:51:13+00:00 Debug {"amount":{"currency":"EUR","value":"58.00"},"redirectUrl":"https:\/\/vagperformancecenter.nl\/afrekenen\/order-received\/881\/?key=wc_order_sT8yTXFI7xwJ5&order_id=881&filter_flag=onMollieReturn","webhookUrl":"https:\/\/vagperformancecenter.nl\/wc-api\/mollie_wc_gateway_ideal?order_id=881&key=wc_order_sT8yTXFI7xwJ5&filter_flag","method":"ideal","payment":{"issuer":"ideal_KNABNL2H","customerId":null},"locale":"nl_NL","metadata":{"order_id":881,"order_number":"881"},"orderNumber":"881","lines":[{"sku":"547","name":"BG 44K Benzinereiniger","quantity":2,"vatRate":0,"unitPrice":{"currency":"EUR","value":"29.00"},"totalAmount":{"currency":"EUR","value":"58.00"},"vatAmount":{"currency":"EUR","value":"0.00"},"discountAmount":{"currency":"EUR","value":"0.00"},"metadata":{"order_item_id":53}},{"type":"shipping_fee","name":"Verzending","quantity":1,"vatRate":0,"unitPrice":{"currency":"EUR","value":"0.00"},"totalAmount":{"currency":"EUR","value":"0.00"},"vatAmount":{"currency":"EUR","value":"0.00"},"metadata":{"order_item_id":"54"}}]} 2024-04-04T13:51:14+00:00 Debug {"resource":"order","id":"ord_1.hb1j0r","profileId":"pfl_q78D26mNGm","mode":"live","amount":{"value":"58.00","currency":"EUR"},"amountCaptured":null,"amountRefunded":null,"status":"created","billingAddress":{"streetAndNumber":"Wiek 11","postalCode":"4841BS","city":"Prinsenbeek","country":"NL","givenName":"B","familyName":"Kessels","email":"[email protected]"},"consumerDateOfBirth":null,"orderNumber":"881","shippingAddress":{"streetAndNumber":"Wiek 11","postalCode":"4841BS","city":"Prinsenbeek","country":"NL","givenName":"B","familyName":"Kessels","email":"[email protected]"},"method":"ideal","locale":"nl_NL","metadata":{"order_id":881,"order_number":"881"},"isCancelable":false,"webhookUrl":"https:\/\/vagperformancecenter.nl\/wc-api\/mollie_wc_gateway_ideal?order_id=881&key=wc_order_sT8yTXFI7xwJ5&filter_flag","redirectUrl":"https:\/\/vagperformancecenter.nl\/afrekenen\/order-received\/881\/?key=wc_order_sT8yTXFI7xwJ5&order_id=881&filter_flag=onMollieReturn","cancelUrl":null,"createdAt":"2024-04-04T13:51:13+00:00","expiresAt":"2024-05-02T13:51:13+00:00","expiredAt":null,"paidAt":null,"authorizedAt":null,"canceledAt":null,"completedAt":null,"lines":[{"resource":"orderline","id":"odl_3.u0rpo9","orderId":"ord_1.hb1j0r","name":"BG 44K Benzinereiniger","sku":"547","type":"physical","status":"created","metadata":{"order_item_id":53},"isCancelable":false,"quantity":2,"quantityShipped":0,"amountShipped":{"value":"0.00","currency":"EUR"},"quantityRefunded":0,"amountRefunded":{"value":"0.00","currency":"EUR"},"quantityCanceled":0,"amountCanceled":{"value":"0.00","currency":"EUR"},"shippableQuantity":0,"refundableQuantity":0,"cancelableQuantity":0,"unitPrice":{"value":"29.00","currency":"EUR"},"vatRate":"0.00","vatAmount":{"value":"0.00","currency":"EUR"},"totalAmount":{"value":"58.00","currency":"EUR"},"createdAt":"2024-04-04T13:51:13+00:00"},{"resource":"orderline","id":"odl_3.gxp24j","orderId":"ord_1.hb1j0r","name":"Verzending","sku":null,"type":"shipping_fee","status":"created","metadata":{"order_item_id":"54"},"isCancelable":false,"quantity":1,"quantityShipped":0,"amountShipped":{"value":"0.00","currency":"EUR"},"quantityRefunded":0,"amountRefunded":{"value":"0.00","currency":"EUR"},"quantityCanceled":0,"amountCanceled":{"value":"0.00","currency":"EUR"},"shippableQuantity":0,"refundableQuantity":0,"cancelableQuantity":0,"unitPrice":{"value":"0.00","currency":"EUR"},"vatRate":"0.00","vatAmount":{"value":"0.00","currency":"EUR"},"totalAmount":{"value":"0.00","currency":"EUR"},"createdAt":"2024-04-04T13:51:13+00:00"}],"shopperCountryMustMatchBillingCountry":false,"_links":{"self":{"href":"https:\/\/api.mollie.com\/v2\/orders\/ord_1.hb1j0r","type":"application\/hal+json"},"dashboard":{"href":"https:\/\/my.mollie.com\/dashboard\/org_4727204\/orders\/ord_1.hb1j0r","type":"text\/html"},"checkout":{"href":"https:\/\/www.mollie.com\/checkout\/order\/1.hb1j0r","type":"text\/html"},"documentation":{"href":"https:\/\/docs.mollie.com\/reference\/v2\/orders-api\/create-order","type":"text\/html"}},"_embedded":null} 2024-04-04T13:51:15+00:00 Debug ideal: Mollie payment object ord_1.hb1j0r (live) created for order 881 2024-04-04T13:51:15+00:00 Debug For order 881 redirect user to Mollie Checkout URL: https://www.mollie.com/checkout/order/1.hb1j0r 2024-04-04T13:51:37+00:00 Debug mollie_wc_gateway_ideal: Mollie payment object ord_1.hb1j0r (live) webhook call for order 881. Additional context 2024-04-04T13:51:37+00:00 Debug Mollie\WooCommerce\Payment\MollieOrderService::orderNeedsPayment mollie_wc_gateway_ideal: Order 881 orderNeedsPayment check: yes, order not previously processed by Mollie gateway. Additional context 2024-04-04T13:51:37+00:00 Debug Mollie\WooCommerce\Payment\MollieOrder::onWebhookPaid called for order 881 2024-04-04T13:51:39+00:00 Debug Mollie\WooCommerce\Payment\MollieOrder::onWebhookPaid WooCommerce payment_complete() processed and returned to Mollie\WooCommerce\Payment\MollieOrder::onWebhookPaid for order 881 2024-04-04T13:51:39+00:00 Debug Mollie\WooCommerce\Payment\MollieOrder::onWebhookPaid processing paid order via Mollie plugin fully completed for order 881 2024-04-04T13:51:40+00:00 Debug Mollie\WooCommerce\Payment\MollieOrder::onWebhookPaid updated payment with webhook and metadata 2024-04-04T13:51:41+00:00 Debug Mollie\WooCommerce\Gateway\MolliePaymentGateway::getReturnRedirectUrlForOrder 881: Determine what the redirect URL in WooCommerce should be. 2024-04-04T13:51:41+00:00 Debug Mollie\WooCommerce\Payment\PaymentModule::onMollieReturn: Redirect url on return order mollie_wc_gateway_ideal, order 881: https://vagperformancecenter.nl/afrekenen/order-received/881/?key=wc_order_sT8yTXFI7xwJ5&utm_nooverride=1 2024-04-04T14:25:20+00:00 Debug Mollie\WooCommerce\Payment\PaymentModule::shipAndCaptureOrderAtMollie - 881 - Try to process completed order for a potential capture at Mollie. 2024-04-04T14:25:21+00:00 Debug Mollie\WooCommerce\Payment\PaymentModule::shipAndCaptureOrderAtMollie - 881 - Order successfully updated to shipped at Mollie, capture of funds underway. 2024-04-04T14:25:22+00:00 Debug mollie_wc_gateway_ideal: Mollie payment object ord_1.hb1j0r (live) webhook call for order 881. Additional context 2024-04-04T14:25:22+00:00 Debug Mollie\WooCommerce\Gateway\MolliePaymentGateway::handlePaidOrderWebhook - mollie_wc_gateway_ideal: Order 881 does not need a payment by Mollie (payment ord_1.hb1j0r). Additional context 2024-04-04T14:25:22+00:00 Debug Mollie\WooCommerce\Payment\MollieOrderService::processRefunds called for order 881 / paymentord_1.hb1j0r 2024-04-04T14:25:22+00:00 Debug Mollie\WooCommerce\Payment\MollieOrderService::processRefunds: No refunds to process for order 881 / paymentord_1.hb1j0r Additional context 2024-04-04T14:25:22+00:00 Debug Mollie\WooCommerce\Payment\MollieOrderService::processChargebacks called for order 881 / payment ord_1.hb1j0r 2024-04-04T14:25:22+00:00 Debug Mollie\WooCommerce\Payment\MollieOrderService::processChargebacks: No chargebacks to process for order 881 / payment ord_1.hb1j0r Additional context
- The topic ‘Database Update Pending’ is closed to new replies.
