Problem updating database
-
Hi there!
After updating woocommerce, I am getting the errors from these printscreens: https://pasteboard.co/aZzl4HQ4h5yf.png and https://pasteboard.co/vmxGfVSAEiPt.png.
I coldn’t find a fix searching online. Could you please help me?Thanks!
-
Hi @xmsmmgrs
After updating woocommerce, I am getting the errors from these printscreens: https://pasteboard.co/aZzl4HQ4h5yf.png and https://pasteboard.co/vmxGfVSAEiPt.png. I coldn’t find a fix searching online. Could you please help me?
From what I understand, you’re experiencing a problem with a database error after updating WooCommerce. The error message you’re seeing, “Fatal error: Uncaught Exception: Error saving action: Database error,” seems to be originating from the ActionScheduler_DBStore.php file.
Here are a few steps you can take to resolve this issue:
- Update all plugins and themes: Make sure all your plugins and themes are updated to the latest version. An outdated plugin or theme could be causing a conflict with WooCommerce.
- Check your PHP version: WooCommerce recommends using PHP version 7.4 or higher. If you’re using an older version, consider updating it. Here’s a link to the ?? WooCommerce Server Recommendations.
- Disable all plugins: Temporarily disable all plugins except WooCommerce. If the error disappears, re-enable the plugins one by one until you find the one causing the conflict.
- Switch to a default theme: If the error persists after disabling all plugins, try switching to a default WordPress theme like Storefront. If the error disappears, the issue might be with your theme. Here’s a helpful guide on how to test for conflicts: ?? How to Test for Plugin and Theme Conflicts.
If none of these steps work, could you please share your site’s System Status with us? It will give us a better understanding of your site’s setup and help us identify the problem. You can find it via
WooCommerce > Status. SelectGet system reportand thenCopy for support.Once you’ve gathered this information, please paste it inside a Code block in your reply, or use https://pastebin.com to paste it and share the link with us.
Thanks for your patience and cooperation in this matter! We’re here to help you get this sorted.
I managed to fix that. Now I am getting this error:
[21-Oct-2023 07:38:13 UTC] PHP Fatal error: Uncaught RuntimeException: Unable to release actions from claim id 0. in /home/xxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:1040
Stack trace: 0 /home/coaching/iosifszenasi.com/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(176): ActionScheduler_DBStore->release_claim(Object(ActionScheduler_ActionClaim)) 1 /home/xxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(139): ActionScheduler_QueueRunner->do_batch(25, ‘WP Cron’) 2 /home/xxx/wp-includes/class-wp-hook.php(310): ActionScheduler_QueueRunner->run(‘WP Cron’) 3 /home/xxx/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters(”, Array) 4 /home/xxx/wp-includes/plugin.php(565): WP_Hook->do_action(Array) 5 /home/xxx/wp-cron.php(191): do_action_ref_array(‘action_ in /home/xxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 1040Hi @xmsmmgrs
I’m thrilled to know that you’ve successfully resolved the initial issue. However, I’m sorry to hear about the new error you’re facing. Let’s tackle this together and find a solution.
The error message you’ve shared indicates that the problem might be linked to the ActionScheduler_DBStore.php file. It appears to be struggling to release actions from claim id 0. It’s possible that this error is connected to a scheduled action that WooCommerce is trying to execute.
Here’s how you can troubleshoot this issue:
- Clear WooCommerce Transients: Navigate to the WooCommerce > Status > Tools tab and click the Clear Transients button.
- Inspect Action Scheduler: WooCommerce utilizes the Action Scheduler for queued tasks. You can find this under Tools > Scheduled Actions. If any actions are pending, attempt to run them manually.
- Refresh WordPress Cron: The error message hints at a potential issue with the WordPress Cron system. Consider using a plugin like ?? WP Crontrolto view and manage WP Cron events.
- Deactivate All Plugins: If the error continues, deactivate all plugins except WooCommerce to see if another plugin is causing a conflict.
- Change to a Default Theme: If the error persists even after deactivating all plugins, switch to a default WordPress theme like Storefront. This can help determine if the problem lies with your theme.
If these steps don’t solve the problem, could you please share your site’s System Status with us again? You can find this by going to WooCommerce > Status. Click on Get system report and then Copy for support. Paste this inside a Code block in your reply, or use https://pastebin.com to upload it and share the link with us.
Thank you for your understanding and patience. We’re dedicated to assisting you in resolving this issue.
Hi there!
Now I am having trouble adding/deleting stuff from cart. No matter if I am logged in or not.
Here is the system report..
` WordPress Environment WC Version: 8.2.1 REST API Version: ? 8.2.1 WC Blocks Version: ? 11.1.2 Action Scheduler Version: ? 3.6.3 Log Directory Writable: ? WP Version: 6.3.2 WP Multisite: – WP Memory Limit: 256 Mo WP Debug Mode: – WP Cron: ? Language: ro_RO External object cache: – Server Environment Server Info: LiteSpeed PHP Version: 7.4.33 PHP Post Max Size: 512 Mo PHP Time Limit: 360 PHP Max Input Vars: 10000 cURL Version: 7.87.0 OpenSSL/1.1.1w SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.39-MariaDB-cll-lve Max Upload Size: 512 Mo Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? Database WC Database Version: 8.2.1 WC Database Prefix: wp_ Dimensiune total? baz? de date: 74.83MB Dimensiune date baz? de date: 65.64MB Dimensiune index baz? de date: 9.19MB wp_woocommerce_sessions: Date: 0.04 MO + Index: 0.00 MO + Motor MyISAM wp_woocommerce_api_keys: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_woocommerce_attribute_taxonomies: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_woocommerce_downloadable_product_permissions: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM wp_woocommerce_order_items: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_woocommerce_order_itemmeta: Date: 0.01 MO + Index: 0.02 MO + Motor MyISAM wp_woocommerce_tax_rates: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_woocommerce_tax_rate_locations: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_woocommerce_shipping_zones: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_woocommerce_shipping_zone_locations: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_woocommerce_shipping_zone_methods: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_woocommerce_payment_tokens: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_woocommerce_payment_tokenmeta: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_woocommerce_log: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM ahm_files: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM linkuri: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM parteneriat: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM Plata: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM PSW_data: Date: 2.08 MO + Index: 0.00 MO + Motor MyISAM PSW_members: Date: 0.01 MO + Index: 0.00 MO + Motor MyISAM voucher: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM wp_actionscheduler_actions: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB wp_actionscheduler_claims: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB wp_actionscheduler_groups: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_actionscheduler_logs: Date: 2.52 MO + Index: 0.00 MO + Motor InnoDB wp_ah_blockeds: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB wp_ah_fingerprint: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB wp_ah_rules: Date: 0.41 MO + Index: 0.00 MO + Motor InnoDB wp_ah_scan: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_ah_scan_files: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB wp_ah_stats: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB wp_ah_tor: Date: 0.08 MO + Index: 0.06 MO + Motor InnoDB wp_ah_visitorslog: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB wp_aps_social_icons: Date: 0.03 MO + Index: 0.00 MO + Motor InnoDB wp_bpspro_login_security: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_bpspro_seclog_ignore: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_clickervolt_actions: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_actions_summary: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_aids: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_clicks: Date: 0.25 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_devices: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_external_ids: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_funnel_links: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_geos: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_links: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_parallel_ids: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_referrers: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_source_templates: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_base: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_devices: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_geos: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_referrers: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_var1: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_var10: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_var2: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_var3: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_var4: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_var5: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_var6: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_var7: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_var8: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_stats_whole_path_var9: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_suspicious_clicks: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_clickervolt_urls_paths: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_cli_cookie_scan: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_cli_cookie_scan_categories: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_cli_cookie_scan_cookies: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_cli_cookie_scan_url: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_cli_scripts: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_commentmeta: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM wp_comments: Date: 0.04 MO + Index: 0.01 MO + Motor MyISAM wp_comments_fbseo: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_comment_rating: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_cpappbk_forms: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_cpappbk_messages: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_download_log: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_ea_error_logs: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_ep_donations6: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_eventscalendar_main: Date: 0.01 MO + Index: 0.00 MO + Motor MyISAM wp_fb_comments_image_data: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_gla_attribute_mapping_rules: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_gla_budget_recommendations: Date: 0.20 MO + Index: 0.11 MO + Motor InnoDB wp_gla_merchant_issues: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_gla_shipping_rates: Date: 0.02 MO + Index: 0.03 MO + Motor InnoDB wp_gla_shipping_times: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB wp_inlinks_data: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_files: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_learnpress_order_itemmeta: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_order_items: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_question_answermeta: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_question_answers: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_question_answers_bk: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_quiz_questions: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_review_logs: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_sections: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_section_items: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_sessions: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_upgrade_db: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_learnpress_user_itemmeta: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_user_itemmeta_bk: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_user_items: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_user_items_bk: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_learnpress_user_item_results: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_links: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_login_security_solution_fail: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_custom_fields: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_forms: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_mapping_to_external_entities: Date: 0.02 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_newsletters: Date: 0.01 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_newsletter_links: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_newsletter_option: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_newsletter_option_fields: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_newsletter_posts: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_newsletter_segment: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_newsletter_templates: Date: 0.19 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_scheduled_tasks: Date: 0.01 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_scheduled_task_subscribers: Date: 0.13 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_segments: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_sending_queues: Date: 0.03 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_settings: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_statistics_clicks: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_statistics_forms: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_statistics_newsletters: Date: 0.01 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_statistics_opens: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_statistics_unsubscribes: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_subscribers: Date: 0.03 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_subscriber_custom_field: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_subscriber_ips: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mailpoet_subscriber_segment: Date: 0.06 MO + Index: 0.00 MO + Motor MyISAM wp_mban_banner: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mban_options: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mban_zone: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_mypos_pending_payments_schedule: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_mypos_upsells: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB wp_mystickyelement_contact_lists: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_newsletter: Date: 0.08 MO + Index: 0.00 MO + Motor MyISAM wp_newsletter_emails: Date: 0.33 MO + Index: 0.00 MO + Motor MyISAM wp_newsletter_profiles: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_newsletter_sent: Date: 0.01 MO + Index: 0.00 MO + Motor MyISAM wp_newsletter_stats: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_newsletter_user_logs: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_news_announcement: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_options: Date: 2.23 MO + Index: 0.08 MO + Motor MyISAM wp_options_bk: Date: 2.83 MO + Index: 0.00 MO + Motor MyISAM wp_pollsa: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_pollsip: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_pollsq: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_postmeta: Date: 2.97 MO + Index: 0.26 MO + Motor MyISAM wp_postmeta_bk: Date: 8.31 MO + Index: 0.00 MO + Motor MyISAM wp_posts: Date: 2.42 MO + Index: 0.14 MO + Motor MyISAM wp_post_views: Date: 0.13 MO + Index: 0.00 MO + Motor InnoDB wp_ppc_tracker: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_ppc_tracker_archived: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_ps_keywords: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_ps_shorted_links: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_ps_tag_images: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_ratings: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_sbb_badips: Date: 0.30 MO + Index: 0.00 MO + Motor InnoDB wp_sbb_badref: Date: 1.52 MO + Index: 0.00 MO + Motor InnoDB wp_sbb_blacklist: Date: 0.42 MO + Index: 0.00 MO + Motor InnoDB wp_sbb_fingerprint: Date: 1.52 MO + Index: 0.00 MO + Motor InnoDB wp_sbb_http_tools: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_sbb_stats: Date: 0.05 MO + Index: 0.00 MO + Motor InnoDB wp_sbb_visitorslog: Date: 25.55 MO + Index: 7.55 MO + Motor InnoDB wp_sby_feeds: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_sby_feed_caches: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_sby_feed_locator: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_smush_dir_images: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_stt2_meta: Date: 0.02 MO + Index: 0.00 MO + Motor MyISAM wp_subscribe2: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_subscribe_reloaded_subscribers: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_termmeta: Date: 0.03 MO + Index: 0.03 MO + Motor MyISAM wp_terms: Date: 0.03 MO + Index: 0.04 MO + Motor MyISAM wp_term_relationships: Date: 0.04 MO + Index: 0.07 MO + Motor MyISAM wp_term_taxonomy: Date: 0.03 MO + Index: 0.03 MO + Motor MyISAM wp_thim_cache: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_tla_data: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_tm_taskmeta: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_tm_tasks: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_up_down_comment_vote: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_up_down_comment_vote_totals: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_up_down_post_vote: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_up_down_post_vote_totals: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_usermeta: Date: 0.03 MO + Index: 0.01 MO + Motor MyISAM wp_users: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM wp_wc_admin_notes: Date: 0.05 MO + Index: 0.00 MO + Motor InnoDB wp_wc_admin_note_actions: Date: 0.05 MO + Index: 0.02 MO + Motor InnoDB wp_wc_category_lookup: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_wc_customer_lookup: Date: 0.02 MO + Index: 0.03 MO + Motor InnoDB wp_wc_download_log: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wc_orders: Date: 0.02 MO + Index: 0.11 MO + Motor InnoDB wp_wc_orders_meta: Date: 0.02 MO + Index: 0.03 MO + Motor InnoDB wp_wc_order_addresses: Date: 0.02 MO + Index: 0.06 MO + Motor InnoDB wp_wc_order_coupon_lookup: Date: 0.02 MO + Index: 0.03 MO + Motor InnoDB wp_wc_order_operational_data: Date: 0.02 MO + Index: 0.03 MO + Motor InnoDB wp_wc_order_product_lookup: Date: 0.02 MO + Index: 0.06 MO + Motor InnoDB wp_wc_order_stats: Date: 0.02 MO + Index: 0.05 MO + Motor InnoDB wp_wc_order_tax_lookup: Date: 0.02 MO + Index: 0.03 MO + Motor InnoDB wp_wc_product_attributes_lookup: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB wp_wc_product_download_directories: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB wp_wc_product_meta_lookup: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM wp_wc_rate_limits: Date: 0.02 MO + Index: 0.02 MO + Motor InnoDB wp_wc_reserved_stock: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_wc_tax_rate_classes: Date: 0.00 MO + Index: 0.01 MO + Motor MyISAM wp_wc_webhooks: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfBadLeechers: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfBlocks: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfBlocksAdv: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfConfig: Date: 0.01 MO + Index: 0.00 MO + Motor MyISAM wp_wfCrawlers: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfFileMods: Date: 0.46 MO + Index: 0.00 MO + Motor MyISAM wp_wfHits: Date: 3.32 MO + Index: 0.00 MO + Motor MyISAM wp_wfHoover: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfIssues: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfLeechers: Date: 0.04 MO + Index: 0.00 MO + Motor MyISAM wp_wfLockedOut: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfLocs: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfLogins: Date: 0.01 MO + Index: 0.00 MO + Motor MyISAM wp_wfNet404s: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfReverseCache: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfScanners: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfStatus: Date: 0.06 MO + Index: 0.00 MO + Motor MyISAM wp_wfThrottleLog: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wfVulnScanners: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wow_skype_free: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_wplc_chat_msgs: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_wplc_chat_sessions: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_wp_rp_tags: Date: 0.08 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_campaign: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_campaign_list: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_custom_field: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_email: Date: 1.60 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_email_user_stat: Date: 0.80 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_email_user_url: Date: 0.08 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_form: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_list: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_queue: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_url: Date: 0.02 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_url_mail: Date: 0.01 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_user: Date: 0.10 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_user_field: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_user_history: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM wp_wysija_user_list: Date: 0.03 MO + Index: 0.00 MO + Motor MyISAM wp_xyz_ips_short_code: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_yoast_indexable: Date: 0.30 MO + Index: 0.00 MO + Motor InnoDB wp_yoast_indexable_hierarchy: Date: 0.05 MO + Index: 0.00 MO + Motor InnoDB wp_yoast_migrations: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_yoast_primary_term: Date: 0.02 MO + Index: 0.00 MO + Motor InnoDB wp_yoast_seo_links: Date: 0.15 MO + Index: 0.00 MO + Motor MyISAM wp_yoast_seo_meta: Date: 0.16 MO + Index: 0.00 MO + Motor MyISAM yourls_log: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM yourls_options: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM yourls_url: Date: 0.00 MO + Index: 0.00 MO + Motor MyISAM Post Type Counts attachment: 290 cf7_style: 13 custom_css: 2 dlm_download: 1 dlm_download_version: 1 flamingo_contact: 133 flamingo_inbound: 155 lp_course: 2 lp_lesson: 40 lp_order: 1 lp_quiz: 1 mailpoet_page: 1 nav_menu_item: 11 oembed_cache: 21 page: 55 polylang_mo: 2 post: 292 postman_sent_mail: 249 product: 16 qa_faqs: 2 shop_coupon: 1 shop_order: 19 testimonial: 1 ufaq: 5 wooframework: 3 wpcf7r_action: 2 wpcf7_contact_form: 9 wpdmpro: 1 wp_global_styles: 1 wysijap: 1 Security Secure connection (HTTPS): ? Hide errors from visitors: ? Active Plugins (28) Query Monitor: de John Blackbourn – 3.14.1 2Performant Link2: de 2Performant – 1.0.1 AntiHacker: de Bill Minozzi – 4.36 Antispam Bee: de pluginkollektiv – 2.11.5 Blackhole for Bad Bots: de Jeff Starr – 3.6 Piese clasice: de Contributori WordPress – 0.3 Formular de contact 7: de Takayuki Miyoshi – 5.8.1 CookieYes | GDPR Cookie Consent: de CookieYes – 3.1.6 Disable Emojis (GDPR friendly): de Ryan Hellyer – 1.7.6 Disable XML-RPC: de Philip Erb – 1.0.1 Easy Table of Contents: de Magazine3 – 2.0.56.1 Feeds for YouTube: de Smash Balloon YouTube Team – 2.1.3 Flamingo: de Takayuki Miyoshi – 2.4 footnotes: de Mark Cheret – 2.7.3 Google Listings and Ads: de WooCommerce – 2.5.10 HTML5 Cumulus: de Flector – 1.01 Insert PHP Code Snippet: de xyzscripts.com – 1.3.3 Linkify Text: de Scott Reilly – 1.9.1 Woocommerce myPOS Checkout: de myPOS Europe LTD – 1.3.24 Sassy Social Share: de Team Heateor – 3.3.54 StopBadBots: de Bill Minozzi – 9.13 Ultimate FAQ - WordPress FAQ and Accordion Plugin: de Etoile Web Design – 2.2.9 WooCommerce: de Automattic – 8.2.1 Yoast SEO: de Echipa Yoast – 21.4 WP Crontrol: de John Blackbourn & crontributors – 1.16.0 WP-Optimize - Clean, Compress, Cache: de David Anderson Ruhani Rabin Echipa Updraft – 3.2.21 Smush: de WPMU DEV – 3.14.2 WPS Hide Login: de WPServeur NicolasKulka wpformation – 1.9.9 Inactive Plugins (2) Euplatesc Donation Module: de Zamfir Vladimir – 9.1 Meks Quick Plugin Disabler: de Meks – 1.0 Dropin Plugins (1) db.php: Query Monitor Database Class (Drop-in) Settings API Enabled: – Force SSL: – Currency: RON (lei) 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: – Enforce Approved Product Download Directories: ? HPOS feature screen enabled: – HPOS feature enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: – WC Pages Baz? magazin: #23778 - /magazin Co?: #23779 - /cos Finalizare: #23780 - /finalizare Contul meu: #23781 - /contul-meu Termeni ?i condi?ii: ? Pagin? nesetat? Theme Name: Ashe Version: 2.192 (este disponibil? actualizarea la versiunea 2.218) Author URL: https://wp-royal.com/ Child Theme: ? – Dac? modifici WooCommerce ?ntr-o tem? p?rinte pe care nu ai construit-o personal recomand?m folosirea unei teme copil. Vezi: Cum creezi o tem? copil WooCommerce Support: ? Templates Overrides: ashe/woocommerce/emails/customer-completed-order.php ashe/woocommerce/order/order-downloads.php Admin Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks product-variation-management remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: customize-store minified-js new-product-management-experience settings async-product-editor-category-field Daily Cron: ? Next scheduled: 2023-10-24 10:29:16 +03:00 Options: ? Notes: 57 Onboarding: completed Action Scheduler Finalizeaz?: 34 Oldest: 2023-10-20 16:01:31 +0300 Newest: 2023-10-23 17:12:27 +0300 ?n a?teptare: 2 Oldest: 2023-10-24 06:00:00 +0300 Newest: 2023-10-24 10:53:30 +0300 Status report information Generated at: 2023-10-23 17:21:57 +03:00 `I am also seeing these errors..
[23-Oct-2023 14:37:53 UTC] Javascript Message: Script error. – URL: – Line: 0
———–x————
———–y————-
[23-Oct-2023 14:18:05 UTC] WordPress database error Duplicate entry ‘t_f3090d373f5471717061c25482854a’ for key ‘session_key’ for query ALTER TABLE wp_woocommerce_sessions ADD UNIQUE KEYsession_key(session_key) made by do_action(‘woocommerce_page_wc-status’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Admin_Menus->status_page, WC_Admin_Status::output, include_once(‘/plugins/woocommerce/includes/admin/views/html-admin-page-status.php’), WC_Admin_Status::status_tools, WC_REST_System_Status_Tools_V2_Controller->execute_tool, WC_Install::verify_base_tables, WC_Install::create_tables, dbDelta, QM_DB->query
———–y————
———–y————-
[23-Oct-2023 14:18:05 UTC] WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query ALTER TABLE wp_woocommerce_sessions ADD PRIMARY KEY (session_id) made by do_action(‘woocommerce_page_wc-status’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Admin_Menus->status_page, WC_Admin_Status::output, include_once(‘/plugins/woocommerce/includes/admin/views/html-admin-page-status.php’), WC_Admin_Status::status_tools, WC_REST_System_Status_Tools_V2_Controller->execute_tool, WC_Install::verify_base_tables, WC_Install::create_tables, dbDelta, QM_DB->query
———–y————
———–y————-
[23-Oct-2023 14:18:04 UTC] WordPress database error Can’t DROP INDEXPRIMARY; check that it exists for query ALTER TABLEwp_woocommerce_sessionsDROP PRIMARY KEY, DROP KEYsession_id, ADD PRIMARY KEY(session_id), ADD UNIQUE KEY(session_key) made by do_action(‘woocommerce_page_wc-status’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Admin_Menus->status_page, WC_Admin_Status::output, include_once(‘/plugins/woocommerce/includes/admin/views/html-admin-page-status.php’), WC_Admin_Status::status_tools, WC_REST_System_Status_Tools_V2_Controller->execute_tool, WC_Install::verify_base_tables, WC_Install::create_tables, QM_DB->query
———–y————I started having these problems after moving my wordpress/woocommerce to a new hosting company.
I fixed the structure of wp_woocommerce_sessions.
Now the only problem left is the Fatal error: Uncaught RuntimeException: Unable to release actions from claim id 0.
Hello @xmsmmgrs,
Glad to know there’s some progress! :?)Now the only problem left is the Fatal error: Uncaught RuntimeException: Unable to release actions from claim id 0.
It seems like the PHP Time Limit of your server might be causing a bottleneck.
Just to clarify, the PHP Time Limit is the maximum amount of time that PHP scripts are allowed to run. If any script runs longer than the set time, PHP will stop it and flag an error. You can adjust this by tweaking the
max_execution_timein your PHP configuration file. Your hosting provider should be able to help you with this.Let us know how it goes!
max_execution_time is 360
max_execution_time is 360
I can see that in your system status, kindly try to increase it to somewhere between 1000 – 1200. :?)
Sorry for not mentioning this in my previous reply.
Let us know how it goes!Unfortunately that did not fix my issue..
After some time of looking closely at all the error messages, I realized that the problem was generated by not having autoincrement on the wp_actionscheduler_claims table. After I added it, the problem went away.
Hey @xmsmmgrs ,
After some time of looking closely at all the error messages, I realized that the problem was generated by not having autoincrement on the?wp_actionscheduler_claims?table. After I added it, the problem went away.
It looks like you managed to get this sorted on your end – nice work!
I’ll go ahead and mark this as resolved, however, feel free to create a new topic?should you need any further help ??
Also, if you have a few minutes, we’d love it if you could leave us a review:
https://www.ads-software.com/support/plugin/woocommerce/reviews/
Cheers!
- The topic ‘Problem updating database’ is closed to new replies.
