Error after updating WooCommerce
-
Hello,
i have updated my WooCommerce Plugin and now my customers dont recieve emails after their checkout.
This is the following error code which i have get from WooCommerce > Status > Logs
2020-11-15T17:17:25+00:00 CRITICAL Uncaught RuntimeException: Aktionen können nicht abgeholt werden. Datenbankfehler. in C:\Inetpub\vhosts\pose-shisha.de\httpdocs\wp-content\plugins\woocommerce\packages\action-scheduler\classes\data-stores\ActionScheduler_DBStore.php:675
Stack trace:0 C:\Inetpub\vhosts\pose-shisha.de\httpdocs\wp-content\plugins\woocommerce\packages\action-scheduler\classes\data-stores\ActionScheduler_DBStore.php(599): ActionScheduler_DBStore->claim_actions()
1 C:\Inetpub\vhosts\pose-shisha.de\httpdocs\wp-content\plugins\woocommerce\packages\action-scheduler\classes\ActionScheduler_QueueRunner.php(153): ActionScheduler_DBStore->stake_claim()
2 C:\Inetpub\vhosts\pose-shisha.de\httpdocs\wp-content\plugins\woocommerce\packages\action-scheduler\classes\ActionScheduler_QueueRunner.php(132): ActionScheduler_QueueRunner->do_batch()
3 C:\Inetpub\vhosts\pose-shisha.de\httpdocs\wp-includes\class-wp-hook.php(287): ActionScheduler_QueueRunner->run()
4 C:\Inetpub\vhosts\pose-shisha.de\httpdocs\wp-includes\class-wp-hook.php(311): WP_H in C:\Inetpub\vhosts\pose-shisha.de\httpdocs\wp-content\plugins\woocommerce\packages\action-scheduler\classes\data-stores\ActionScheduler_DBStore.php in Zeile 675Is there any chance to repair my WooCommerce without losing my data?
I hope someone can help me.Best regards
The page I need help with: [log in to see the link]
-
Hi there! 👋
Normally, this kind of problem is usually caused by either a conflict with your theme or with another plugin.
The best way to determine this is to:- Temporarily switch your theme to Storefront
- Disable all plugins except for WooCommerce
- Repeat the action that is causing the problem
If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.
Before you start
Please make sure you have a good backup in place of your full site and database. Most hosting companies have this included in the subscription, but you could also consider using a service like Jetpack. If something goes wrong, it’s nice to know that you can restore your site.
Please keep us posted, we will be more than happy to help moving forward. 🙂
Hey there,
thanks for the quick answer. I do all the steps but the problem is still there.
I had a few complications while updating my WooCommerce. Is it possible that this can be the problem?Best regards.
Oh! That probably might be the cause of the issue.
However, to dive deeper into this issue, could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
Thanks in advance 🙂
Hello,
Here is my system report:
### WordPress Environment ### WordPress address (URL): https://pose-shisha.de Site address (URL): https://pose-shisha.de WC Version: 4.8.0 REST API Version: ✔ 4.8.0 WC Blocks Version: ✔ 3.8.1 Action Scheduler Version: ✔ 3.1.6 WC Admin Version: ✔ 1.7.3 Log Directory Writable: ✔ WP Version: 5.6 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ✔ Language: de_DE External object cache: – ### Server Environment ### Server Info: Microsoft-IIS/10.0 PHP Version: 7.4.13 PHP Post Max Size: 256 MB PHP Time Limit: 90 PHP Max Input Vars: 1000 cURL Version: 7.70.0 OpenSSL/1.1.1h SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.23-MariaDB Max Upload Size: 128 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ❌ Dein Server verfügt nicht über eine lauffähige Version der SoapClient Klasse - einige Zahlungsschnittstellen welche SOAP nutzen funktionieren unter Umständen nicht korrekt. DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 4.8.0 WC Database Prefix: qwFGGnZC_ Datenbank-Gesamtgröße: 17.79MB Datenbank-Datengröße: 14.08MB Datenbank-Indexgröße: 3.71MB qwFGGnZC_woocommerce_sessions: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_api_keys: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_attribute_taxonomies: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_downloadable_product_permissions: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_order_items: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_order_itemmeta: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_tax_rates: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_tax_rate_locations: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_shipping_zones: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_shipping_zone_locations: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_shipping_zone_methods: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_payment_tokens: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_payment_tokenmeta: ❌ Tabelle ist nicht vorhanden qwFGGnZC_woocommerce_log: ❌ Tabelle ist nicht vorhanden qwfggnzc_actionscheduler_actions: Daten: 0.08MB + Index: 0.11MB + Engine InnoDB qwfggnzc_actionscheduler_claims: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_actionscheduler_groups: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_actionscheduler_logs: Daten: 0.06MB + Index: 0.03MB + Engine InnoDB qwfggnzc_cmplz_cookiebanners: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB qwfggnzc_cmplz_cookies: Daten: 0.05MB + Index: 0.00MB + Engine InnoDB qwfggnzc_cmplz_services: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB qwfggnzc_commentmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_comments: Daten: 0.05MB + Index: 0.09MB + Engine InnoDB qwfggnzc_ewwwio_images: Daten: 0.42MB + Index: 0.44MB + Engine InnoDB qwfggnzc_ewwwio_queue: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_links: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_nextend2_image_storage: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_nextend2_section_storage: Daten: 0.05MB + Index: 0.06MB + Engine InnoDB qwfggnzc_nextend2_smartslider3_generators: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB qwfggnzc_nextend2_smartslider3_sliders: Daten: 0.06MB + Index: 0.03MB + Engine InnoDB qwfggnzc_nextend2_smartslider3_sliders_xref: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_nextend2_smartslider3_slides: Daten: 0.08MB + Index: 0.16MB + Engine InnoDB qwfggnzc_options: Daten: 3.02MB + Index: 0.09MB + Engine InnoDB qwfggnzc_postmeta: Daten: 5.33MB + Index: 0.66MB + Engine InnoDB qwfggnzc_posts: Daten: 3.23MB + Index: 0.13MB + Engine InnoDB qwfggnzc_storeabill_documentmeta: Daten: 0.09MB + Index: 0.09MB + Engine InnoDB qwfggnzc_storeabill_documents: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB qwfggnzc_storeabill_document_itemmeta: Daten: 0.16MB + Index: 0.14MB + Engine InnoDB qwfggnzc_storeabill_document_items: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB qwfggnzc_storeabill_document_noticemeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_storeabill_document_notices: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_storeabill_journals: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_termmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_terms: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_term_relationships: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_term_taxonomy: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_usermeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_users: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB qwfggnzc_wc_admin_notes: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB qwfggnzc_wc_admin_note_actions: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_wc_category_lookup: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB qwfggnzc_wc_customer_lookup: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_wc_download_log: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_wc_order_coupon_lookup: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_wc_order_product_lookup: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB qwfggnzc_wc_order_stats: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB qwfggnzc_wc_order_tax_lookup: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_wc_product_meta_lookup: Daten: 0.05MB + Index: 0.09MB + Engine InnoDB qwfggnzc_wc_reserved_stock: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB qwfggnzc_wc_tax_rate_classes: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_wc_webhooks: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_woocommerce_api_keys: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_woocommerce_attribute_taxonomies: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_woocommerce_downloadable_product_permissions: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB qwfggnzc_woocommerce_gzd_dhl_im_products: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_woocommerce_gzd_dhl_im_product_services: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_woocommerce_gzd_dhl_labelmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_woocommerce_gzd_dhl_labels: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_woocommerce_gzd_packaging: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB qwfggnzc_woocommerce_gzd_packagingmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_woocommerce_gzd_shipmentmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_woocommerce_gzd_shipments: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB qwfggnzc_woocommerce_gzd_shipment_itemmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_woocommerce_gzd_shipment_items: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB qwfggnzc_woocommerce_gzd_shipping_provider: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB qwfggnzc_woocommerce_gzd_shipping_providermeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_woocommerce_log: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_woocommerce_order_itemmeta: Daten: 0.09MB + Index: 0.09MB + Engine InnoDB qwfggnzc_woocommerce_order_items: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_woocommerce_payment_tokenmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_woocommerce_payment_tokens: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB qwfggnzc_woocommerce_sessions: Daten: 0.06MB + Index: 0.02MB + Engine InnoDB qwfggnzc_woocommerce_shipping_zones: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB qwfggnzc_woocommerce_shipping_zone_locations: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_woocommerce_shipping_zone_methods: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB qwfggnzc_woocommerce_tax_rates: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB qwfggnzc_woocommerce_tax_rate_locations: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB qwfggnzc_wpfm_backup: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB qwfggnzc_wpmailsmtp_tasks_meta: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB qwfggnzc_wpsmtp_logs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### attachment: 221 custom_css: 1 document_template: 4 elementor_library: 5 jet-theme-core: 2 jet-woo-builder: 2 nav_menu_item: 23 page: 34 post: 1 product: 124 revision: 245 seedprod: 1 shop_coupon: 1 shop_order: 23 shop_order_refund: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (21) ### a3 Lazy Load: von a3rev Software – 2.4.2 Coming Soon Page, Maintenance Mode & Landing Pages by SeedProd: von SeedProd – 6.0.9.0 Complianz | GDPR/CCPA Cookie Consent: von Really Simple Plugins – 4.8.2 Agy: von Patrick Posner – 4.2.4 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.0 getestet Custom Order Numbers for WooCommerce: von Tyche Softwares – 1.2.11 Elementor: von Elementor.com – 3.0.14 JetBlocks For Elementor: von Crocoblock – 1.2.4 JetElements For Elementor: von Crocoblock – 2.3.3 JetTabs For Elementor: von Crocoblock – 2.1.7 JetThemeCore: von Crocoblock – 1.1.25 JetWooBuilder For Elementor: von Crocoblock – 1.7.0 JetProductGallery For Elementor: von Crocoblock – 1.1.5 Kava Extra: von Zemez – 1.0.5 Payment Gateways per Products for WooCommerce: von WPWhale – 1.3.1 Smart Slider 3: von Nextend – 3.4.1.14 Vendidero Helper: von Vendidero – 1.3.0 Germanized für WooCommerce Pro: von vendidero – 3.1.0 Germanized für WooCommerce: von vendidero – 3.3.1 WooCommerce: von Automattic – 4.8.0 WP Fastest Cache: von Emre Vona – 0.9.1.3 WP Mail SMTP: von WPForms – 2.5.1 ### Inactive Plugins (6) ### EWWW Image Optimizer: von Exactly WWW – 5.8.2 Jet Data Importer: von Zemez – 1.2.2 Jet Plugins Wizard: von Zemez – 1.2.8 Woostroid Theme Wizard: von Zemez – 1.0.0 WordPress Importer: von wordpressdotorg – 0.7 WP File Manager: von mndpsingh287 – 6.9 ### Dropin Plugins (1) ### maintenance.php: maintenance.php ### Settings ### API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: right_space Thousand Separator: . Decimal Separator: , Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: – ### WC Pages ### Shop-Basis: #246 - /shop/ Warenkorb: #429 - /warenkorb/ Kasse: #424 - /kasse/ Mein Konto: #426 - /mein-konto/ Allgemeine Geschäftsbedingungen: #999 - /agb/ ### Theme ### Name: Woostroid2 Child Version: 1.0.0 Author URL: http://www.templatemonster.com/ Child Theme: ✔ Parent Theme Name: Woostroid2 Parent Theme Version: 1.0.8 Parent Theme Author URL: https://zemez.io/ WooCommerce Support: ✔ ### Templates ### Overrides: – ### Action Scheduler ### Abgebrochen: 10 Oldest: 2020-11-23 20:28:37 +0100 Newest: 2020-12-09 16:54:35 +0100 Abgeschlossen: 149 Oldest: 2020-12-16 01:47:35 +0100 Newest: 2020-12-22 18:34:45 +0100 Ausstehend: 1 Oldest: 2020-12-23 08:55:56 +0100 Newest: 2020-12-23 08:55:56 +0100Hey @eazyminz
It’s very possible there is an issue with (or related to) the WP Mail SMTP plugin, or its configuration.
What I would suggest is to check if the emails are actually being sent (and not received), or if they are not being sent to begin with. You can find a quick guide for that, using a plugin called WP Mail Logging, right here:
https://docs.woocommerce.com/document/email-faq/#section-4With that, you can see what happens behind the scenes when an email is being sent from your site, and WP Mail Logging will show what happens for each individual email.
If WP Mail Logging shows the email being sent, but it’s not received, that means that the issue is not with WordPress/WooCommerce, and it could be with the SMTP plugin, SMTP provider, or your webhost, or on the receiver’s end. You will need to troubleshoot with your SMTP provider and your host.
If WP Mail Logging shows the email as not being sent, you will see an error message as well, which could point you in the right direction and give you some information about what might be wrong.
A full troubleshooting guide for email issues can be found here.
Hi @eazyminz,
We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, you were able to find a solution to your problem!
If you have further questions, please feel free to open a new topic.
Thanks.
The topic ‘Error after updating WooCommerce’ is closed to new replies.
