• Resolved cenay

    (@cenay)


    There’s a lot to unpack because I’ve been dealing with this issue for a few weeks. Just like @wpuser1234 at https://www.ads-software.com/support/topic/unable-to-update-database-6-6-1-6-7/ — I’ve tried all the various “solutions” like deleting the transients, expired transients, solving various other small issues with plugins, running the database update from the top notification, and from WooCommerce tools directly, etc.

    Despite all that, here’s where I am now:
    1) I have verified with the hosting company (LiquidWeb/Nexcess) that the WP-CRON is running correctly and accurately, every 5 minutes.
    2) I have manually triggered the database update in WooCommerce Tools multiple times. The woocommerce_db_version option in wp_options, still says 6.6.1
    3) Clicking on the “Update database” option, created 5 (sometimes 6) new “pending” items that never go away. I currently have 924 pending entries.
    4) I’ve put in a ticket at Nexcess to get help (pretty much worthless as they keep referring me to WooCommerce) which I am including the content of below as I see no way to include the TXT file I put together for you.

    In the video I did for Nexcess (https://www.screencast.com/t/QYdZIZfix49J) I stated I didn’t believe the CRON jobs are running, and they’ve sent verified they are. I now suspect that CRON is failing, even though nothing is showing up in the logs about that failure.

    ANY HELP you can provide would be great appreciated. Again, I can’t find where to insert my system report, but I stand ready to send that if you can tell me how.

    THEIR “RESOLUTION” TO THE TICKET ENDED WITH:
    This issue seems to be that Woocommerce is stuck updating the database, until that process completes or is successful.

    Cenay’

    ————[ Transcript of support with Nexcess including my videos showing the issue
    Ticket: 11075368
    CRON Jobs don’t appear to be running correctly

    Until the WooCommerce database update completes, it will keep on displaying them as pending. This is why they are showing as pending.

    WooCommerce database update
    WooCommerce is updating the database in the background. The database update process may take a little while, so please be patient. View progress →

    Reviewing your WordPress cron, we are showing jobs are being scheduled.

    +————————————————-+———————+———————–+—————+
    | hook | next_run_gmt | next_run_relative | recurrence |
    +————————————————-+———————+———————–+—————+
    | action_scheduler_run_queue | 2022-09-28 01:09:15 | now | 1 minute |
    | learndash_woocommerce_cron | 2022-09-28 01:09:25 | now | 1 minute |
    | gravityforms_cron | 2022-09-28 01:10:03 | 29 seconds | 1 day |
    | nfsecupdates | 2022-09-28 01:15:21 | 5 minutes 47 seconds | 30 minutes |
    | rediscache_discard_metrics | 2022-09-28 01:43:16 | 33 minutes 42 seconds | 1 hour |
    | nfwgccron | 2022-09-28 01:45:06 | 35 minutes 32 seconds | 1 hour |
    | cache_enabler_clear_expired_cache | 2022-09-28 01:45:48 | 36 minutes 14 seconds | 1 hour |
    | wc_admin_process_orders_milestone | 2022-09-28 01:52:16 | 42 minutes 42 seconds | 1 hour |
    | ip2location_country_blocker_hourly_event | 2022-09-28 01:59:42 | 50 minutes 8 seconds | 1 hour |
    | wp_privacy_delete_old_export_files | 2022-09-28 02:01:00 | 51 minutes 26 seconds | 1 hour |
    | wc_admin_unsnooze_admin_notes | 2022-09-28 02:03:09 | 53 minutes 35 seconds | 1 hour |
    | backupbuddy_cron | 2022-09-28 03:19:00 | 2 hours 9 minutes | 1 day |
    | backupbuddy_cron | 2022-09-28 03:29:00 | 2 hours 19 minutes | 1 day |
    | learndash_notifications_cron | 2022-09-28 04:00:24 | 2 hours 50 minutes | 12 hours |
    | cptch_call_twicedaily_action_hook | 2022-09-28 04:02:14 | 2 hours 52 minutes | 12 hours |
    | wp_update_user_counts | 2022-09-28 04:20:36 | 3 hours 11 minutes | 12 hours |
    | antispam_bee_daily_cronjob | 2022-09-28 05:33:23 | 4 hours 23 minutes | 1 day |
    | updraft_backup | 2022-09-28 05:55:00 | 4 hours 45 minutes | 12 hours |
    | updraft_backup_database | 2022-09-28 05:55:00 | 4 hours 45 minutes | 12 hours |
    | fs_data_sync_erropix-hydrogen-pack | 2022-09-28 06:44:19 | 5 hours 34 minutes | 1 day |
    | wp_version_check | 2022-09-28 06:54:10 | 5 hours 44 minutes | 12 hours |
    | wp_update_plugins | 2022-09-28 06:54:10 | 5 hours 44 minutes | 12 hours |
    | wp_update_themes | 2022-09-28 06:54:10 | 5 hours 44 minutes | 12 hours |
    | woocommerce_scheduled_sales | 2022-09-28 07:00:00 | 5 hours 50 minutes | 1 day |
    | nfdailyreport | 2022-09-28 07:00:05 | 5 hours 50 minutes | 1 day |
    | check_plugin_updates-woo-product-bundle-premium | 2022-09-28 08:10:43 | 7 hours 1 minute | 12 hours |
    | wp_https_detection | 2022-09-28 08:16:40 | 7 hours 7 minutes | 12 hours |
    | pm_request_lighthouse_reports | 2022-09-28 08:27:18 | 7 hours 17 minutes | 1 day |
    | sync_all_fb_products_using_feed | 2022-09-28 08:37:00 | 7 hours 27 minutes | 1 day |
    | woocommerce_cleanup_sessions | 2022-09-28 11:09:14 | 9 hours 59 minutes | 12 hours |
    | backwpup_check_cleanup | 2022-09-28 11:14:54 | 10 hours 5 minutes | 12 hours |
    | gform_userregistration_cron | 2022-09-28 12:11:22 | 11 hours 1 minute | 12 hours |
    | puc_cron_check_updates-wpcodebox | 2022-09-28 12:49:44 | 11 hours 40 minutes | 12 hours |
    | wp_mainwp_stream_auto_purge | 2022-09-28 12:53:04 | 11 hours 43 minutes | 12 hours |
    | recovery_mode_clean_expired_keys | 2022-09-28 15:26:33 | 14 hours 16 minutes | 1 day |
    | woocommerce_cleanup_personal_data | 2022-09-28 17:09:24 | 15 hours 59 minutes | 1 day |
    | woocommerce_tracker_send_event | 2022-09-28 17:09:24 | 15 hours 59 minutes | 1 day |
    | wordfence_daily_cron | 2022-09-28 17:46:22 | 16 hours 36 minutes | 1 day |
    | check_plugin_updates-updraftplus | 2022-09-28 18:06:39 | 16 hours 57 minutes | 1 day |
    | nexcess_mapps_daily_maintenance | 2022-09-28 18:09:48 | 17 hours | 1 day |
    | wpseo-reindex-links | 2022-09-28 18:16:38 | 17 hours 7 minutes | 1 day |
    | wp_scheduled_delete | 2022-09-28 18:54:22 | 17 hours 44 minutes | 1 day |
    | fs_data_sync_erropix-hydrogen-pack | 2022-09-28 18:54:57 | 17 hours 45 minutes | 1 day |
    | backupbuddy_cron | 2022-09-28 19:01:19 | 17 hours 51 minutes | 1 day |
    | backupbuddy_cron | 2022-09-28 19:01:44 | 17 hours 52 minutes | 1 day |
    | wp_scheduled_auto_draft_delete | 2022-09-28 19:39:01 | 18 hours 29 minutes | 1 day |
    | woocommerce_cleanup_logs | 2022-09-28 20:09:14 | 18 hours 59 minutes | 1 day |
    | woocommerce_cleanup_rate_limits | 2022-09-28 20:09:14 | 18 hours 59 minutes | 1 day |
    | delete_expired_transients | 2022-09-28 20:35:20 | 19 hours 25 minutes | 1 day |
    | wc_admin_daily | 2022-09-28 20:35:23 | 19 hours 25 minutes | 1 day |
    | akismet_scheduled_delete | 2022-09-28 20:41:08 | 19 hours 31 minutes | 1 day |
    | tribe_common_log_cleanup | 2022-09-28 21:29:49 | 20 hours 20 minutes | 1 day |
    | wpseo_permalink_structure_check | 2022-09-28 21:35:28 | 20 hours 25 minutes | 1 day |
    | wpseo-premium-prominent-words-recalculate | 2022-09-28 21:42:02 | 20 hours 32 minutes | 1 day |
    | wpseo-reindex | 2022-09-28 21:43:08 | 20 hours 33 minutes | 1 day |
    | backupbuddy_cron | 2022-09-28 22:27:00 | 21 hours 17 minutes | 1 day |
    | analytify_cleanup_logs | 2022-09-28 23:34:19 | 22 hours 24 minutes | 1 day |
    | nexcess_mapps_usage_tracking | 2022-09-28 23:41:48 | 22 hours 32 minutes | 1 day |
    | cc_woo_check_expired_carts | 2022-09-29 00:00:00 | 22 hours 50 minutes | 1 day |
    | wp_site_health_scheduled_check | 2022-09-29 16:55:02 | 1 day 15 hours | 1 week |
    | nexcess_mapps_weekly_maintenance | 2022-10-03 18:34:48 | 5 days 17 hours | 1 week |
    | woo_product_slider_pro_weekly_scheduled_events | 2022-10-03 20:04:11 | 5 days 18 hours | 1 week |
    | wcdn_ts_tracker_send_event | 2022-10-04 02:57:50 | 6 days 1 hour | 1 week |
    | woocommerce_geoip_updater | 2022-10-06 17:10:14 | 1 week 1 day | 2 weeks 1 day |
    | backwpup_cron | 2022-10-20 10:00:00 | 3 weeks 1 day | Non-repeating |
    | 1441563194 | | now | Non-repeating |
    | 1441563196 | | now | Non-repeating |
    | 1441563197 | | now | Non-repeating |
    | 1441563207 | | now | Non-repeating |
    | 1441563209 | | now | Non-repeating |
    | 1441563211 | | now | Non-repeating |
    | 1441563271 | | now | Non-repeating |
    +————————————————-+———————+———————–+—————+

    This issue seems to be that Woocommerce is stuck updating the database, until that process completes or is successful. You will continue to see jobs that need to be manually updated.

    Thank you.

    —————————–
    Matthew McGehrin
    Sep 27, 2022 5:36 PM
    Hello.

    We are looking into this issue and I will provide an update once we have finished.

    Thank you.

    Matthew
    ref:_00D30pmDy._5003a1Hi8Q3:ref

    ——————————-
    Eric Brotman – [email protected]
    Sep 27, 2022 12:40 PM
    FYI, still no email delivered to me to let me know there was an update.

    Recorded what the results were, and the fact that the “jobs” still are not running. See this video for my ongoing issues: https://www.screencast.com/t/UI2Di2Z93L

    Adding myself as a watcher AGAIN, please cc [email protected]

    ——————————-
    Alex Freeman
    Sep 24, 2022 1:17 AM
    Hello,

    Reviewing it appears that the email address [email protected] was not CC to this ticket, however we have ensured that the email address was added to this support ticket case.

    Reviewing the server cron logs we can see that the cron is triggering every five minutes and the cron appears to be configured correctly:

    2022-09-24T07:10:01.484952+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[22781]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)

    2022-09-24T07:15:01.630361+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[29371]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)

    2022-09-24T07:20:01.423963+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[28059]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)

    2022-09-24T07:25:02.271604+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[1487]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)

    2022-09-24T07:30:01.724413+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[32616]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)

    2022-09-24T07:35:02.240556+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[10117]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)

    2022-09-24T07:40:01.766612+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[12471]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)

    2022-09-24T07:45:01.326645+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[18135]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)

    2022-09-24T07:50:01.625984+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[16765]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)

    2022-09-24T07:55:01.910499+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[22617]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)

    2022-09-24T08:00:02.216320+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[21741]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)

    2022-09-24T08:05:01.544080+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[31076]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)

    Has the mentioned 8 old cron jobs have not ran and where is this being seen ( Admin Panel )?

    Since the cron was previously updated are the cron jobs now running normally?

    Please let us know if we can be of any further assistance.

    ——————————-
    Eric Brotman – [email protected]
    Sep 22, 2022 2:03 PM
    Thanks for checking. Just FYI, even though I requested notifications to my email address ([email protected]) not a single email has been received. Yes, checked SPAM. I have special filters that allow support tickets from designated providers through.

    Having said that, I checked and I still have 8 jobs more than 24 hours old that haven’t run yet.

    ——————————-
    Arunlal Ravindran
    Sep 22, 2022 11:39 AM
    Hello,

    We have updated the cron job now. Could you please check the same? and let us know the result.

    Regards,

    Arunlal Ravindran

    ——————————-
    Arunlal Ravindran
    Sep 22, 2022 11:15 AM
    Hello,

    Thank you for contacting support.

    My name is Arunlal, and I have taken over your case. Please allow me some time to look into your request and I will have an update for you as soon as possible.

    Regards,

    Arunlal Ravindran

    ——————————-
    Sep 21, 2022 12:09 PM
    Cenay here, with another question (webmaster for Eric Brotman)

    I don’t believe the WordPress CRON jobs are running correctly since the migration from LiquidWeb to Nexcess. Please see this video for my issues and concerns.

    Thanks in advance for any help you can provide. Please ensure you include me on the email chain so I get a notification of the reply.`

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Saif

    (@babylon1999)

    Hello @cenay,

    We’re going to need more information to understand this.

    • 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.
    • Also, please check the fatal error logs (if any) from WooCommerce > Status > Logs and choose from the drop-down menu the fatal-errors.log`
    • You can also download this plugin to make sure Cron is working properly.
    Thread Starter cenay

    (@cenay)

    1) System status below.
    2) I’ve checked the fatal errors log and there appears to be nothing related to Woo in there. (I did find a couple of errors related to my backup plugin which I am working to resolve.
    3) I’ve verified the CRON jobs are firing correctly with the host. They run every 5 minutes.

    System Status info:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://psi-ceu.com
    Site address (URL): https://psi-ceu.com
    WC Version: 6.9.4
    REST API Version: ? 6.9.4
    WC Blocks Version: ? 8.3.3
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.0.2
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: ?
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.30
    PHP Post Max Size: 100 MB
    PHP Time Limit: 600
    PHP Max Input Vars: 3000
    cURL Version: 7.29.0
    NSS/3.53.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.5.16-MariaDB
    Max Upload Size: 100 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 6.6.1
    WC Database Prefix: wp_
    Total Database Size: 1187.66MB
    Database Data Size: 829.94MB
    Database Index Size: 357.72MB
    wp_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.13MB + Index: 0.36MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 1.52MB + Index: 0.38MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 16.52MB + Index: 10.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.19MB + Index: 0.23MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 1.52MB + Index: 1.23MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 1.52MB + Index: 0.73MB + Engine InnoDB
    wp_cc_abandoned_carts: Data: 1.52MB + Index: 0.02MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 2.52MB + Index: 1.20MB + Engine InnoDB
    wp_em_bookings: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_em_events: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
    wp_em_locations: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_em_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_em_tickets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_em_tickets_bookings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_fooevents_check_in: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gfei_import_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gf_addon_feed: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_gf_addon_payment_callback: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_addon_payment_transaction: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_entry: Data: 5.52MB + Index: 1.92MB + Engine InnoDB
    wp_gf_entry_meta: Data: 16.55MB + Index: 24.59MB + Engine InnoDB
    wp_gf_entry_notes: Data: 3.52MB + Index: 0.56MB + Engine InnoDB
    wp_gf_form: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_meta: Data: 22.52MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_revisions: Data: 0.13MB + Index: 0.03MB + Engine InnoDB
    wp_gf_form_view: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
    wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_huge_it_videogallery_galleries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_huge_it_videogallery_videos: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    wp_ld_notifications_delayed_emails: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_learndash_pro_quiz_category: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_learndash_pro_quiz_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_learndash_pro_quiz_lock: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
    wp_learndash_pro_quiz_master: Data: 0.43MB + Index: 0.01MB + Engine MyISAM
    wp_learndash_pro_quiz_prerequisite: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_learndash_pro_quiz_question: Data: 11.33MB + Index: 0.28MB + Engine MyISAM
    wp_learndash_pro_quiz_statistic: Data: 52.24MB + Index: 21.99MB + Engine MyISAM
    wp_learndash_pro_quiz_statistic_ref: Data: 4.75MB + Index: 6.70MB + Engine MyISAM
    wp_learndash_pro_quiz_template: Data: 0.45MB + Index: 0.00MB + Engine MyISAM
    wp_learndash_pro_quiz_toplist: Data: 1.84MB + Index: 0.38MB + Engine MyISAM
    wp_learndash_user_activity: Data: 32.41MB + Index: 62.09MB + Engine MyISAM
    wp_learndash_user_activity_meta: Data: 150.14MB + Index: 137.55MB + Engine MyISAM
    wp_linkcategorymeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_links: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_links_extrainfo: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_mainwp_stream: Data: 1.38MB + Index: 1.13MB + Engine InnoDB
    wp_mainwp_stream_meta: Data: 2.02MB + Index: 5.13MB + Engine InnoDB
    wp_options: Data: 10.36MB + Index: 0.27MB + Engine InnoDB
    wp_postmeta: Data: 93.56MB + Index: 33.13MB + Engine InnoDB
    wp_posts: Data: 195.56MB + Index: 8.06MB + Engine InnoDB
    wp_pp_login_builder: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_pp_password_reset_builder: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_pp_registration_builder: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_prli_clicks: Data: 0.02MB + Index: 0.19MB + Engine InnoDB
    wp_prli_links: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
    wp_prli_link_metas: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_sc_analytics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_redirection_404: Data: 0.13MB + Index: 0.05MB + Engine InnoDB
    wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_responsive_video_gallery_plus_responsive_lightbox: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_richreviews: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rtafar_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_shortpixel_folders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_shortpixel_meta: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_shortpixel_postmeta: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_shortpixel_queue: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_surveys_answer: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_surveys_question: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_surveys_result: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_surveys_result_answer: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_surveys_survey: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_terms: Data: 0.13MB + Index: 0.17MB + Engine InnoDB
    wp_term_relationships: Data: 0.33MB + Index: 0.25MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.14MB + Index: 0.17MB + Engine InnoDB
    wp_ualp_user_activity: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_uap_action_log: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_uap_action_logs_view: Data: 0.00MB + Index: 0.00MB + Engine
    wp_uap_action_log_meta: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_uap_closure_log: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_uap_closure_log_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_uap_recipe_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_uap_recipe_logs_view: Data: 0.00MB + Index: 0.00MB + Engine
    wp_uap_trigger_log: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_uap_trigger_logs_view: Data: 0.00MB + Index: 0.00MB + Engine
    wp_uap_trigger_log_meta: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_usermeta: Data: 169.56MB + Index: 21.06MB + Engine InnoDB
    wp_users: Data: 0.47MB + Index: 0.42MB + Engine InnoDB
    wp_user_registration_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.27MB + Index: 0.22MB + Engine InnoDB
    wp_wc_download_log: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 2.52MB + Index: 3.70MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.36MB + Index: 0.33MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_zapier_history: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    wp_wfblockediplog: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    wp_wfblocks7: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
    wp_wfconfig: Data: 0.48MB + Index: 0.00MB + Engine InnoDB
    wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wffilemods: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
    wp_wfhits: Data: 1.52MB + Index: 0.23MB + Engine InnoDB
    wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfknownfilelist: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wflogins: Data: 0.22MB + Index: 0.06MB + Engine InnoDB
    wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpb2d_processed_dbtables: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpforms_entry_fields: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wpforms_entry_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpss_answers_30: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpss_fields_30: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpss_questions_30: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpss_quizzes_30: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpss_results_30: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpss_routes_30: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wt_abandonment_coupon: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_yoast_indexable: Data: 4.52MB + Index: 7.00MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 0.22MB + Index: 0.30MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_prominent_words: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
    wp_yoast_seo_links: Data: 2.52MB + Index: 1.88MB + Engine InnoDB
    wp_yoast_seo_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    acf-field: 7
    acf-field-group: 2
    amchart: 1
    attachment: 1878
    awesome-surveys: 12
    bsf-sidebar: 2
    coursenote: 62
    ct_template: 10
    custom_css: 1
    encyclopedia: 1
    event_magic_tickets: 1118
    faq: 1
    glossary: 2
    ld-notification: 3
    link_library_links: 240
    nav_menu_item: 42
    oembed_cache: 97
    page: 52
    pm_insight: 2245
    pm_page: 1141
    pm_report: 130
    pm_site_change: 108
    post: 23
    postman_sent_mail: 250
    product: 141
    revision: 21624
    sfwd-certificates: 40
    sfwd-courses: 35
    sfwd-essays: 73
    sfwd-lessons: 1412
    sfwd-question: 5228
    sfwd-quiz: 662
    sfwd-topic: 30
    shop_coupon: 4
    shop_order: 3318
    shop_order_refund: 76
    sidebar: 1
    sp_wps_shortcodes: 2
    tablepress_table: 100
    tribe_events: 2
    tribe_venue: 1
    ufaq: 26
    ultimate_slider: 1
    uo-trigger: 1
    user_registration: 1
    visualizer: 2
    wcps: 2
    woo_discount: 2
    woo_mb_template: 10
    wpcb_snippet_post: 4
    wpes_answers: 5
    wpes_survey: 1
    wpforms: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (61) ###
    
    Product Customer List for WooCommerce: by Kokomo – 3.1.1
    Action Scheduler - Disable Default Queue Runner: by Prospress Inc. – 1.0.0
    Add Assets: by Cenay Nailor – 1.1.5
    Advanced Custom Fields PRO: by WP Engine – 6.0.2
    Antispam Bee: by pluginkollektiv – 2.11.1
    BackWPup: by Inpsyde GmbH – 3.10.0
    Classic Editor: by WordPress Contributors – 1.6.2
    Custom Post Type UI: by WebDevStudios – 1.13.1
    Hydrogen Pack: by Clean Plugins – 1.4.0
    ES Woocommerce ActiveCampaign: by EqualServing.com – 2.0.3
    EWD Premium Helper: by Etoile Web Design – 0.0.22
    Flexible Checkout Fields: by WP Desk – 3.4.2
    FooEvents for WooCommerce: by FooEvents – 1.15.12
    FooEvents Custom Attendee Fields: by FooEvents – 1.6.22
    FooEvents Multi-Day: by FooEvents – 1.6.2
    FooEvents PDF Tickets: by FooEvents – 1.9.19
    Gallery - Video Gallery: by Huge-IT – 2.2.3
    Gravity Forms: by Gravity Forms – 2.6.7
    Gravity Forms ActiveCampaign Add-On: by Gravity Forms – 2.0
    Gravity Forms Signature Add-On: by Gravity Forms – 4.3
    Gravity Forms Stripe Add-On: by Gravity Forms – 4.2
    Gravity Forms Survey Add-On: by Gravity Forms – 3.7
    Gravity Forms User Registration Add-On: by Gravity Forms – 5.0
    LearnDash Licensing & Management: by LearnDash – 1.1.2
    LearnDash LMS - Notifications: by LearnDash – 1.5.3
    LearnDash LMS - ProPanel: by LearnDash – 2.1.4.1
    LearnDash LMS - WooCommerce Integration: by LearnDash – 1.9.4.1
    Woo Login Redirect Pro: by wpdoctor – 2.2.2
    Maintenance: by WebFactory Ltd – 4.06
    MainWP Child Reports: by MainWP – 2.0.8
    MainWP Child: by MainWP – 4.2.6
    NinjaFirewall (WP+): by The Ninja Technologies Network – 4.5.4
    Oxygen Elements for WooCommerce: by Soflyy – 2.0
    Oxygen: by Soflyy – 4.0.4
    Better Find and Replace: by CodeSolz – 1.4.1
    Redis Object Cache: by Till Krüss – 2.2.0
    Reveal IDs: by Oliver Schl?be – 1.5.4
    Rich Reviews by Starfish: by Starfish Reviews – 1.9.14
    LearnDash LMS: by LearnDash – 4.3.1.2
    ShortPixel Image Optimizer: by ShortPixel – 5.0.9
    Sidebar Manager: by Brainstorm Force – 1.1.7
    Simple Google reCAPTCHA: by Michal Novák – 4.0
    TablePress: by Tobias B?thge – 1.14
    Tawk.to Live Chat: by Tawkto – 0.7.2
    Ultimate FAQ - WordPress FAQ and Accordion Plugin: by  – 2.1.17
    Uncanny Toolkit for LearnDash: by Uncanny Owl – 3.6.3
    Uncanny Toolkit Pro for LearnDash: by Uncanny Owl – 3.9.1
    User Activity Log: by Solwin Infotech – 1.4.9
    User Switching: by John Blackbourn & contributors – 1.7.0
    Product Subtitle For WooCommerce: by Varun Sridharan – 4.6.2
    Woo Login Redirect: by WP Doctor – 2.2.4
    WPC Product Bundles for WooCommerce (Premium): by WPClever – 6.2.1
    Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 4.6.5
    WooCommerce First Data Payeezy Gateway: by SkyVerge – 4.9.0
    WooCommerce Order Status Control: by SkyVerge – 1.14.1
    WooCommerce Social Login: by SkyVerge – 2.11.2
    WooCommerce Zapier: by OM4 Software – 2.3.0
    WooCommerce: by Automattic – 6.9.4
    Yoast SEO: by Team Yoast – 19.7.1
    WPCodeBox: by WPCodeBox – 1.4.1
    WPCodeBox: by WPCodeBox – 1.4.1
    
    ### Inactive Plugins (2) ###
    
    LearnDash Content Cloner: by WisdmLabs – 1.2.9.3
    Redirection: by John Godley – 5.3.4
    
    ### Dropin Plugins (2) ###
    
    fatal-error-handler.php: fatal-error-handler.php
    object-cache.php: Redis Object Cache Drop-In
    
    ### Must Use Plugins (3) ###
    
    0-ninjafirewall.php: by The Ninja Technologies Network – 1.0
    LearnDash LMS Multisite: by LearnDash – 1.0.0
    Nexcess Managed Apps: by Nexcess – 1.32.0
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: course (course)
    external (external)
    grouped (grouped)
    phive_booking (phive_booking)
    simple (simple)
    variable (variable)
    woosb (woosb)
    
    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: –
    
    ### WC Pages ###
    
    Shop base: #40547 - /shop/
    Cart: #40057 - /cart/
    Checkout: #40052 - /checkout/
    My account: #40077 - /woo-account/
    Terms and conditions: #43249 - /terms/
    
    ### Theme ###
    
    Name: Twenty Twenty
    Version: 2.0
    Author URL: https://www.ads-software.com/
    Child Theme: ?
    Parent Theme Name: Twenty Twenty
    Parent Theme Version: 2.0
    Parent Theme Author URL: https://www.ads-software.com/
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-content/plugins/add-assets/child-theme/woocommerce/cart/cart-empty.php
    /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-content/plugins/add-assets/child-theme/woocommerce/cart/cart.php
    /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-content/plugins/add-assets/child-theme/woocommerce/checkout/form-checkout.php
    /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-content/plugins/add-assets/child-theme/woocommerce/checkout/terms.php
    /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-content/plugins/add-assets/child-theme/woocommerce/checkout/thankyou.php
    /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-content/plugins/add-assets/child-theme/woocommerce/emails/admin-new-order.php
    /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-content/plugins/add-assets/child-theme/woocommerce/emails/customer-completed-order.php
    /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-content/plugins/add-assets/child-theme/woocommerce/emails/customer-invoice.php
    /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-content/plugins/add-assets/child-theme/woocommerce/emails/customer-reset-password.php
    /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-content/plugins/add-assets/child-theme/woocommerce/single-product/short-description.php
    /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-content/plugins/add-assets/child-theme/woocommerce/single-product/tabs/description.php
    
    ### Payeezy Gateway Credit Card ###
    
    Environment: Production
    Tokenization Enabled: 
    Debug Mode: Off
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    experimental-product-tour
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    wc-pay-promotion
    wc-pay-welcome-page
    
    Disabled Features: minified-js
    new-product-management-experience
    settings
    
    Daily Cron: ? Next scheduled: 2022-10-01 20:35:23 -07:00
    Options: ?
    Notes: 27
    Onboarding: completed
    
    ### Social Login ###
    
    Facebook: ? Available
    Twitter: Disabled
    Google: ? Available
    Amazon: Disabled
    Linkedin: Disabled
    Paypal: Disabled
    Disqus: Disabled
    Yahoo: Disabled
    Vkontakte: Disabled
    
    ### Action Scheduler ###
    
    Complete: 3,937
    Oldest: 2022-04-22 08:26:43 -0700
    Newest: 2022-09-28 21:05:03 -0700
    
    Pending: 951
    Oldest: 2022-06-06 13:42:08 -0700
    Newest: 2022-09-30 11:28:10 -0700
    
    ### WooCommerce Zapier ###
    
    Database Version: ? 14
    Detailed Logging Enabled: No
    Legacy Mode Disabled: ? Yes
    SSL: ? Yes
    REST API Authentication Key(s): ? 0
    Task History Record Count: ? 446
    Webhook #45: WooCommerce Zapier
    - Status: active
    - Trigger: order.paid
    - Delivery Count: 306
    Deleted Webhook Delivery Count: 140
    
    ### Status report information ###
    
    Generated at: 2022-09-30 13:44:58 -07:00
    
    Saif

    (@babylon1999)

    I didn’t notice anything that could cause such a problem. This could be just a plugin or theme conflict.
    ?
    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 the conflict. You can find a more detailed explanation of how to do a conflict test here.

    Let us know your findings!

    Thread Starter cenay

    (@cenay)

    It took a while to debug this, but for any looking into this issue as well.. I did as suggested and one at a time deactivated plugins and tried the database update between each one. I eventually found the one that was blocking me, and the database updated.

    PITA if you ask me. Thanks for all the help.

    CLOSED

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Unable to update database 6.6.1 -> 6.9.2’ is closed to new replies.