• Resolved majaxlt

    (@majaxlt)


    Hi,

    I used WP-Optimize to optimize DB, delete unused tables. It worked great, performance improved significantly. But after I deactivate this plugin, my site breaks. Looks like other plugins can’t connect to database or something like that. MonsterInsights breaks, front end popup login stops working etc.

    If I reactivate WP-Optimize it won’t fix problems and even WP-Optimize won’t show DB tables anymore. Only way to fix this is to restore website via cpanel. Thanks God I made a restore point before optimizing.

    It’s hard to explain so I made a video – https://www.loom.com/share/3f89bc24ce42438c8cc42aaadccacd75

Viewing 6 replies - 1 through 6 (of 6 total)
  • Hi there,

    An error 500 is a fatal error on the server, which should be logged.
    Can you check your PHP error logs?

    Marc.

    Thread Starter majaxlt

    (@majaxlt)

    Hi Marc,

    I just restored my website. Give me 10 minutes to optimize again.

    Thread Starter majaxlt

    (@majaxlt)

    #1 /home/xxx/public_html/wp-content/plugins/invoicing/includes/libraries/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
    #2 /home/xxx/public_html/wp-content/plugins/invoicing/includes/libraries/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
    #3 /home/xxx/public_html/wp-content/plugins/invoicing/incl in /home/xxx/public_html/wp-content/plugins/invoicing/includes/libraries/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_actions' doesn't exist for query SELECT a.action_id FROM wp_actionscheduler_actions 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
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_actions' doesn't exist for query SELECT a.action_id FROM wp_actionscheduler_actions 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
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_actions' doesn't exist for query SELECT a.action_id FROM wp_actionscheduler_actions 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
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_actions' doesn't exist for query SELECT a.action_id FROM wp_actionscheduler_actions 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
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_groups' doesn't exist for query SELECT group_id FROM wp_actionscheduler_groups 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
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_groups' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_actionscheduler_groups</code> 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
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_actions' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_actionscheduler_actions</code> 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
    [16-May-2020 09:11:09 UTC] PHP Fatal error:  Uncaught RuntimeException: Error saving action: Error saving action: Table 'xxx.wp_actionscheduler_actions' doesn't exist in /home/xxx/public_html/wp-content/plugins/invoicing/includes/libraries/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
    Stack trace:
    #0 /home/xxx/public_html/wp-content/plugins/invoicing/includes/libraries/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(225): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
    #1 /home/xxx/public_html/wp-content/plugins/invoicing/includes/libraries/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
    #2 /home/xxx/public_html/wp-content/plugins/invoicing/includes/libraries/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
    #3 /home/xxx/public_html/wp-content/plugins/invoicing/incl in /home/xxx/public_html/wp-content/plugins/invoicing/includes/libraries/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_actions' doesn't exist for query SELECT a.action_id FROM wp_actionscheduler_actions 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
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_actions' doesn't exist for query SELECT a.action_id FROM wp_actionscheduler_actions 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
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_actions' doesn't exist for query SELECT a.action_id FROM wp_actionscheduler_actions 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
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_actions' doesn't exist for query SELECT a.action_id FROM wp_actionscheduler_actions 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
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_groups' doesn't exist for query SELECT group_id FROM wp_actionscheduler_groups 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
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_groups' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_actionscheduler_groups</code> 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
    [16-May-2020 09:11:09 UTC] WordPress database error Table 'xxx.wp_actionscheduler_actions' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_actionscheduler_actions</code> 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
    [16-May-2020 09:11:09 UTC] PHP Fatal error:  Uncaught RuntimeException: Error saving action: Error saving action: Table 'xxx.wp_actionscheduler_actions' doesn't exist in /home/xxx/public_html/wp-content/plugins/invoicing/includes/libraries/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
    Stack trace:
    • This reply was modified 6 years ago by majaxlt.

    You say you deleted unused tables. Did you delete “ActionScheduler” tables? If so, it seems that would cause the issue.

    Thread Starter majaxlt

    (@majaxlt)

    Yea looks I deleted that. But I don’t use woo commerce so why it brings an error?

    https://ibb.co/84hmPHs

    In some cases, it is possible that WP-Optimize has missing information about some plugins.

    Which is why it is always advised to backup the database before doing any operation on the database, and why there is a warning when deleting tables:

    screenshot

    Marc.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Deactivating plugin breaks site’ is closed to new replies.