search

woocommerce / action-scheduler

A scalable, traceable job queue for background processing large queues of tasks in WordPress. Specifically designed for distribution in WordPress plugins (and themes) - no server access required.
https://actionscheduler.org
GNU General Public License v3.0
627 stars 113 forks source link

Action Scheduler migration in progress. The list of scheduled actions may be incomplete. #467

Closed neilgee closed 4 years ago

neilgee commented 4 years ago

I have this warning in the Dashboard Action Scheduler migration in progress. The list of scheduled actions may be incomplete.

I see a ref here, but not too sure how to troubleshoot.

WIth wp_debug enabled I am also seeing this error.

[18-Feb-2020 04:43:01 UTC] WordPress database error Table 'synthesi_ayb.a' doesn't exist for query SELECT a.action_id FROM  a WHERE a.hook='action_scheduler/migration_hook' AND a.status='in-progress' ORDER BY scheduled_date_gmt DESC LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_HybridStore->find_action, ActionScheduler_DBStore->find_action
[18-Feb-2020 04:43:01 UTC] WordPress database error Table 'synthesi_ayb.a' doesn't exist for query SELECT a.action_id FROM  a WHERE a.hook='action_scheduler/migration_hook' AND a.status='pending' ORDER BY scheduled_date_gmt ASC LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_HybridStore->find_action, ActionScheduler_DBStore->find_action
[18-Feb-2020 04:43:01 UTC] WordPress database error Table 'synthesi_ayb.a' doesn't exist for query SELECT a.action_id FROM  a WHERE a.hook='action_scheduler/migration_hook' AND a.status='in-progress' ORDER BY scheduled_date_gmt DESC LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_next_scheduled_action, ActionScheduler_HybridStore->find_action, ActionScheduler_DBStore->find_action
[18-Feb-2020 04:43:01 UTC] WordPress database error Table 'synthesi_ayb.a' doesn't exist for query SELECT a.action_id FROM  a WHERE a.hook='action_scheduler/migration_hook' AND a.status='pending' ORDER BY scheduled_date_gmt ASC LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_next_scheduled_action, ActionScheduler_HybridStore->find_action, ActionScheduler_DBStore->find_action
[18-Feb-2020 04:43:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE slug='action-scheduler-migration'' at line 1 for query SELECT group_id FROM  WHERE slug='action-scheduler-migration' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->get_group_id
[18-Feb-2020 04:43:01 UTC] WordPress database error Incorrect table name '' for query SHOW FULL COLUMNS FROM `` made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->get_group_id, ActionScheduler_DBStore->create_group
[18-Feb-2020 04:43:01 UTC] WordPress database error Incorrect table name '' for query SHOW FULL COLUMNS FROM `` made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action

System details

### WordPress Environment ###

WordPress address (URL): https://www.synthesisorganics.com
Site address (URL): https://www.synthesisorganics.com
WC Version: 3.8.1
REST API Version: ✔ 1.0.2
Log Directory Writable: ✔
WP Version: 5.3.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: ✔
WP Cron: ✔
Language: en_AU
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.2.27
PHP Post Max Size: 40 MB
PHP Time Limit: 0
PHP Max Input Vars: 1000
cURL Version: 7.62.0
OpenSSL/1.0.2k

SUHOSIN Installed: –
MySQL Version: 5.6.47-cll-lve
Max Upload Size: 32 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 3.8.1
WC Database Prefix: wrd_
Total Database Size: 396.19MB
Database Data Size: 309.59MB
Database Index Size: 86.60MB
wrd_woocommerce_sessions: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
wrd_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wrd_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wrd_woocommerce_order_items: Data: 0.15MB + Index: 0.07MB + Engine MyISAM
wrd_woocommerce_order_itemmeta: Data: 0.93MB + Index: 0.59MB + Engine MyISAM
wrd_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wrd_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wrd_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
igwidget_global_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
igwidget_widget: Data: 0.11MB + Index: 0.00MB + Engine MyISAM
wrd_actionscheduler_actions: Data: 29.56MB + Index: 15.48MB + Engine InnoDB
wrd_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_actionscheduler_logs: Data: 53.59MB + Index: 26.06MB + Engine InnoDB
wrd_affiliate_wp_affiliatemeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wrd_affiliate_wp_affiliates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_affiliate_wp_campaigns: Data: 0.00MB + Index: 0.00MB + Engine
wrd_affiliate_wp_creatives: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_affiliate_wp_customermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wrd_affiliate_wp_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wrd_affiliate_wp_mlm_connections: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wrd_affiliate_wp_payouts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_affiliate_wp_referralmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wrd_affiliate_wp_referrals: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_affiliate_wp_rest_consumers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_affiliate_wp_visits: Data: 0.10MB + Index: 0.03MB + Engine MyISAM
wrd_amwscp_amazon_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_amwscp_amazon_feeds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_amwscp_amazon_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_amwscp_feeds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_amwscp_feed_product_record: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_amwscp_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_amwscp_template_values: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_aryo_activity_log: Data: 112.63MB + Index: 0.00MB + Engine InnoDB
wrd_commentmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wrd_comments: Data: 34.06MB + Index: 20.16MB + Engine MyISAM
wrd_duplicator_packages: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wrd_eum_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_gf_entry: Data: 0.20MB + Index: 0.03MB + Engine InnoDB
wrd_gf_entry_meta: Data: 1.52MB + Index: 0.42MB + Engine InnoDB
wrd_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wrd_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gf_form_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wrd_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wrd_gf_form_view: Data: 0.17MB + Index: 0.16MB + Engine InnoDB
wrd_gg_cdn: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_gg_folders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gg_galleries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gg_galleries_excluded: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gg_galleries_resources: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gg_image_optimize: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_gg_membership_presets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gg_photos: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gg_photos_pos: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gg_photos_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gg_settings_presets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gg_settings_sets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gg_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_gg_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_groups_capability: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wrd_groups_group: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_groups_group_capability: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_groups_user_capability: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_groups_user_group: Data: 0.11MB + Index: 0.30MB + Engine MyISAM
wrd_huge_it_videogallery_galleries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_huge_it_videogallery_videos: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_instapage_debug: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_instapage_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_instapage_pages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_layerslider: Data: 0.16MB + Index: 0.00MB + Engine MyISAM
wrd_learnpress_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_learnpress_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_learnpress_question_answers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_learnpress_quiz_questions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_learnpress_review_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_learnpress_sections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_learnpress_section_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_learnpress_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_learnpress_user_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_learnpress_user_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_litespeed_img_optm: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wrd_litespeed_optimizer: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wrd_llm: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_login_redirects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_mailchimp_carts: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wrd_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_mainwp_stream: Data: 0.43MB + Index: 0.25MB + Engine MyISAM
wrd_mainwp_stream_context: Data: 0.12MB + Index: 0.07MB + Engine MyISAM
wrd_mainwp_stream_meta: Data: 1.14MB + Index: 0.61MB + Engine MyISAM
wrd_namaste_certificates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_namaste_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_namaste_homeworks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_namaste_homework_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_namaste_payments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_namaste_student_certificates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_namaste_student_courses: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_namaste_student_homeworks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_namaste_student_lessons: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_namaste_student_modules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_namaste_visits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_optinrev: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wrd_optins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wrd_optin_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wrd_options: Data: 2.61MB + Index: 0.13MB + Engine MyISAM
wrd_pay_options: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_pay_option_subs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_pay_transactions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_plugmatter_ab_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_plugmatter_ab_test: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_plugmatter_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_pmxe_exports: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wrd_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wrd_pmxe_posts: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
wrd_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_pmxi_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_pmxi_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_pmxi_imports: Data: 0.25MB + Index: 0.00MB + Engine MyISAM
wrd_pmxi_posts: Data: 0.08MB + Index: 0.03MB + Engine MyISAM
wrd_pmxi_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_popover_ip_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_postmeta: Data: 27.16MB + Index: 6.87MB + Engine MyISAM
wrd_posts: Data: 21.56MB + Index: 8.23MB + Engine MyISAM
wrd_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_redirection_404: Data: 1.52MB + Index: 0.66MB + Engine InnoDB
wrd_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wrd_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wrd_redirection_logs: Data: 0.06MB + Index: 0.08MB + Engine InnoDB
wrd_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_responsive_video_gallery_plus_responsive_lightbox: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_responsive_video_grid: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rg_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_rg_form_meta: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wrd_rg_form_view: Data: 0.11MB + Index: 0.07MB + Engine MyISAM
wrd_rg_incomplete_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_rg_lead: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
wrd_rg_lead_detail: Data: 0.11MB + Index: 0.07MB + Engine MyISAM
wrd_rg_lead_detail_long: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wrd_rg_lead_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_rg_lead_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_richreviews: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_rich_web_video_slider_effects_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_video_slider_font_family: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_video_slider_id: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_video_slider_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_video_slider_videos: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_vs_effect_1: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_vs_effect_2: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_vs_effect_3: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_vs_effect_4: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_vs_effect_5: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_vs_effect_6: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_vs_effect_7: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_vs_effect_8: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_rich_web_vs_effect_9: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_sbi_instagram_posts: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
wrd_studypress_activity: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_configuration: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_course: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_course_category: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_course_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_domain: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_gcourse: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_propositions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_questions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_quiz_result: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_rate_domain: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_rate_quality: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_slide: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_studypress_visite: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_teo_offer_email_views_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_teo_offer_recipients: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_teo_offer_scheduled_emails: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_termmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wrd_terms: Data: 0.01MB + Index: 0.03MB + Engine MyISAM
wrd_term_relationships: Data: 0.03MB + Index: 0.06MB + Engine MyISAM
wrd_term_taxonomy: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wrd_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wrd_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_totalsoft_fonts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_totalsoft_galleryv_ctpg: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_totalsoft_galleryv_dbt: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_totalsoft_galleryv_fg: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_totalsoft_galleryv_gvg: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_totalsoft_galleryv_hlg: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_totalsoft_galleryv_id: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_totalsoft_galleryv_lvg: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_totalsoft_galleryv_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_totalsoft_galleryv_sg: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_totalsoft_galleryv_ttvg: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_totalsoft_galleryv_videos: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_usermeta: Data: 7.55MB + Index: 3.94MB + Engine MyISAM
wrd_users: Data: 0.77MB + Index: 0.58MB + Engine MyISAM
wrd_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wrd_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Engine InnoDB
wrd_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_wfBlockedIPLog: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wrd_wfBlocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wrd_wfConfig: Data: 2.31MB + Index: 0.01MB + Engine MyISAM
wrd_wfCrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_wfFileChanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_wfFileMods: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
wrd_wfHits: Data: 0.38MB + Index: 0.10MB + Engine MyISAM
wrd_wfHoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_wfIssues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wrd_wfKnownFileList: Data: 1.47MB + Index: 0.18MB + Engine MyISAM
wrd_wfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_wfLocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_wfLogins: Data: 0.09MB + Index: 0.02MB + Engine MyISAM
wrd_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wrd_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_wfNotifications: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wrd_wfPendingIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wrd_wfReverseCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_wfSNIPCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_wfStatus: Data: 0.07MB + Index: 0.03MB + Engine MyISAM
wrd_wfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_wpgdprc_access_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_wpgdprc_consents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_wpgdprc_delete_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_wpgdprc_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wrd_yikes_easy_mc_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wrd_yoast_seo_links: Data: 0.17MB + Index: 0.06MB + Engine InnoDB
wrd_yoast_seo_meta: Data: 3.50MB + Index: 0.00MB + Engine InnoDB

### Security ###

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔

### Active Plugins (77) ###

ManageWP - Worker: by GoDaddy – 4.9.3
Gravity Forms: by rocketgenius – 2.4.17
Add Meta Tags: by George Notaras – 2.11.3
AffiliateWP: by Sandhills Development
LLC – 2.4.4

AffiliateWP - Affiliate Product Rates: by Pippin Williamson and Andrew Munro – 1.0.5.1
AffiliateWP MLM: by Christian Freeman and The Perfect Plugin Team – 1.0
AffiliateWP - Show Affiliate Coupons: by AffiliateWP – 1.0.7
AfterShip - WooCommerce Tracking: by AfterShip – 1.9.15 – Not tested with the active version of WooCommerce
Akismet Anti-Spam: by Automattic – 4.1.3
All in one Favicon: by Arne Franken – 4.7
Another MailChimp Widget: by MotoPress – 2.0.8
Better Font Awesome: by Mickey Kay – 1.7.1
PublishPress Capabilities: by PublishPress – 1.9
Cyclone Slider: by Nico Amarilla – 3.2.0
Display Widgets: by Strategy11 – 2.7
Google Tag Manager for Wordpress: by Thomas Geiger – 1.11.2
Elementor: by Elementor.com – 2.9.2
301 Redirects: by WebFactory Ltd – 2.45
Facebook for WooCommerce: by Facebook – 1.9.15 – Not tested with the active version of WooCommerce
Widget for Social Page Feeds: by Milap Patel – 6.0
Forget About Shortcode Buttons: by Designs & Code – 2.1.2
Gallery - Video Gallery: by Huge-IT – 2.2.2
Genesis eNews Extended: by Brandon Kraft – 2.1.1
Genesis Featured Page Advanced: by Nick Diego – 1.9.7
Genesis Responsive Slider: by StudioPress – 1.0.1
Genesis Simple Edits: by StudioPress – 2.3.0
Genesis Simple Share: by StudioPress – 1.1.5
Genesis Simple Sidebars: by StudioPress – 2.2.1
Genesis Title Toggle: by Bill Erickson – 1.9.0
Google Analytics Dashboard for WP (GADWP): by ExactMetrics – 5.3.10
Groups WooCommerce: by itthinx – 1.17.0 – Not tested with the active version of WooCommerce
Groups: by itthinx – 2.9.0
Smash Balloon Instagram Feed: by Smash Balloon – 2.1.5
Instapage Plugin: by Instapage – 3.2.13
LeadDyno WordPress Plugin: by LeadDyno – 1.9.2
LiteSpeed Cache: by LiteSpeed Technologies – 2.9.9.2
Mailchimp for WooCommerce: by Mailchimp – 2.3.2
MC4WP: Mailchimp for WordPress: by ibericode – 4.7.5
MC4WP: Mailchimp User Sync: by ibericode – 1.8.1
MailMunch - Grow Your Email List: by MailMunch – 3.1.2
New Facebook Pixel with Standard Events for WooCommerce: by GhostMonitor – 1.4.0 – Not tested with the active version of WooCommerce
Peter's Login Redirect: by Peter Keung – 2.9.4
PixelYourSite: by PixelYourSite – 7.1.4
Redirection: by John Godley – 4.7
Simple Custom CSS: by John Regan
Danny Van Kooten – 4.0.3

Google Tag Manager: by Justin Rains – 1.0.5
Simple Page Sidebars: by Cedaro – 1.2.1
Simple Social Icons: by StudioPress – 3.0.1
Easy Updates Manager: by Easy Updates Manager Team – 9.0.1
Testimonial Rotator: by Hal Gatewood – 3.0.2
Tracking Code Manager: by IntellyWP – 1.12.1
TWB Woocommerce Reviews: by Abu Bakar – 1.7.3 – Not tested with the active version of WooCommerce
UpdraftPlus - Backup/Restore: by UpdraftPlus.com
DavidAnderson – 1.16.21

User Submitted Posts: by Jeff Starr – 20191110
WooCommerce Product Feed: by WebAppick – 3.3.0
Widget CSS Classes: by C.M. Kendrick – 1.5.4
Woo Custom Emails: by wp3sixty – 2.2 – Not tested with the active version of WooCommerce
Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.1
WooCommerce Email Test: by RaiserWeb – 1.8 – Not tested with the active version of WooCommerce
WP WooCommerce Mailchimp: by Saint Systems – 2.3.9
WooCommerce PDF Invoices: by Bas Elbers – 3.0.11 – Not tested with the active version of WooCommerce
WooCommerce Quantity Increment: by Automattic
WooThemes – 1.1.0 – Not tested with the active version of WooCommerce

Woocommerce Remove SKU: by Prem Tiwari – 1.3 – Not tested with the active version of WooCommerce
WooCommerce: by Automattic – 3.8.1 – 3.9.2 is available
WooCommerce Helper: by WooCommerce – 1.7.2 – Not tested with the active version of WooCommerce – Network enabled
Wordfence Security: by Wordfence – 7.4.6
Yoast SEO: by Team Yoast – 13.0
WP All Export: by Soflyy – 1.2.5
WP All Import Pro: by Soflyy – 4.5.9
WP Crontrol: by John Blackbourn & crontributors – 1.7.1
WP File Manager: by mndpsingh287 – 5.7
WP GDPR Compliance: by Van Ons – 1.5.2
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.0.16

WP-Sweep: by Lester 'GaMerZ' Chan – 1.1.1
WP All Import - WooCommerce Add-On Pro: by Soflyy – 3.1.1
Custom Product Tabs for WooCommerce: by YIKES
Inc. – 1.6.13

YITH WooCommerce Advanced Reviews: by YITH – 1.4.3

### Inactive Plugins (25) ###

Activity Log: by Activity Log Team – 2.5.2
AffiliateWP - Affiliate Forms For Gravity Forms: by Pippin Williamson and Andrew Munro – 1.0.5
Afterpay Gateway for WooCommerce: by Afterpay – 2.1.3
Beeketing For WooCommerce: by Beeketing – 3.8.16 – Not tested with the active version of WooCommerce
Booster for WooCommerce: by Algoritmika Ltd – 4.7.1
Duplicator: by Snap Creek – 1.3.28
Easy Review Reminders: by Rymera Web Co – 1.2.4 – Not tested with the active version of WooCommerce
ExportFeed: WooCommerce data feed for Amazon Marketplace: by ExportFeed.com – 3.1.0.6
Export Users to CSV: by Matt Cromwell – 1.1.1
Google Analyticator: by SumoMe – 6.5.4
MailChimp Widget: by James Lafferty – 0.8.12
Refer A Friend for WooCommerce by WPGens: by Goran Jakovljevic – 1.1.9 – Not tested with the active version of WooCommerce
Reward Points For Woocommerce: by phoeniixx – 3.4
Show Current Template: by JOTAKI Taisuke – 0.3.3
Testimonials: by WooThemes – 1.5.4
WooCommerce Google Analytics Integration: by WooCommerce – 1.4.17
WooCommerce Shippit: by Shippit Pty Ltd – 1.5.3 – Not tested with the active version of WooCommerce
Woocommerce show terms and conditions: by Skomfare2 – 1.1 – Not tested with the active version of WooCommerce
WooCommerce Simply Order Export: by Ankit Gade – 3.0.13 – Not tested with the active version of WooCommerce
WooCommerce Starshipment Order: by  – 3.2.2 – Not tested with the active version of WooCommerce
WooCommerce Wholesale Order Form: by Rymera Web Co – 1.8.4 – Not tested with the active version of WooCommerce
WooCommerce Wholesale Prices: by Rymera Web Co – 1.10 – Not tested with the active version of WooCommerce
WooCommerce Wholesale Prices Premium: by Rymera Web Co – 1.16.4 – Not tested with the active version of WooCommerce
WooSwipe: by Thrive Website Design – 1.1.8.6
YITH WooCommerce Recover Abandoned Cart: by YITH – 1.4.0

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Must Use Plugins (1) ###

ManageWP - Worker Loader: by GoDaddy –

### Settings ###

API Enabled: ✔
Force SSL: –
Currency: AUD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: ✔

### WC Pages ###

Shop base: #654 - /shop/organic-skin-care-shop/
Cart: #178 - /shop/my-account/cart/
Checkout: #179 - /shop/my-account/checkout/
My account: #181 - /shop/my-account/
Terms and conditions: #433 - /award-winning-organic-skin-care/terms-condition/

### Theme ###

Name: Flourish Theme
Version: 1.0.0
Author URL: http://www.restored316designs.com/
Child Theme: ✔
Parent Theme Name: Genesis
Parent Theme Version: 3.2.1
Parent Theme Author URL: https://www.studiopress.com/
WooCommerce Support: ✔

### Templates ###

Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: /home/synthesi/public_html/wp-content/plugins/yith-woocommerce-advanced-reviews//templates/ywar-rating.php

### Action Scheduler ###

Complete: 82,433
Oldest: 2020-01-18 15:21:04 +1100
Newest: 2020-02-18 15:21:16 +1100

Pending: 2
Oldest: 2020-02-18 15:21:16 +1100
Newest: 2020-02-23 23:02:27 +1100

Failed: 12,979
Oldest: 2018-11-04 20:26:32 +1100
Newest: 2020-02-18 14:52:00 +1100

Canceled: 15,760
Oldest: 2020-02-04 03:16:34 +1100
Newest: -0001-11-30 10:00:00 +1000
rrennick commented 4 years ago

Our instructions for conflict testing are https://docs.woocommerce.com/document/how-to-test-for-conflicts/

neilgee commented 4 years ago

Think it was Activity Log plugin, the warning disappeared after I removed the plugin.

Also there was a huge amount of ActionScheduler comments in _wpcomments - removing that plugins table removed those too.