• Resolved traqbar

    (@traqbar)


    Hello,

    I have been cleaning my database and dropping some tables – issue is that my site is now crashing as aour plugin continues to try to run quieries on table that do not exist. I have tried clearing all the caches – deleting cache folders on the server but I do not know where the db chaces are being stored. I am geeting the below error message for example.

    • Why is this not clearing when I select to purge all?
    • How can I get this done now eg: manually?

    Thanks

    AH01071: Got error ‘PHP message: WordPress database error Table ‘production.wp_8_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_8_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘/var/www/production/shared/wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), 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_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query;

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

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hello @traqbar

    Thank you for reaching out and I am happy to help!
    Can you please sahre which caching method you are using for the Database Caching in the General settings?

    If you are using DIsk, you should avoid it and if your server configuration and plan allows, you should use Redis or Memcached as memory-based cahcing solution for Database Caching instead of the Disk.

    Thanks!

    Thread Starter traqbar

    (@traqbar)

    Hello,

    I recently switched to Memcache as I installed it on my server.

    Thanks

    Thread Starter traqbar

    (@traqbar)

    I see that there is an option to store transients in the database – is this a source of continued actions even when the plugin is disabled?

    Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hello @traqbar

    Thank you for your feedback.
    No, once the plugin is disabled or any module within the plugin, any sub-options for that specific module are no longer being utilized.

    Thanks!

    Thread Starter traqbar

    (@traqbar)

    Okay, thanks for the info. I think that corresponds to my investigations.

    Can you let me know how to manually remove the current cache as it does not work when I purge all.

    Can you confirm if there is an issue with clearing the database caching?

    Thanks.

    Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hello @traqbar

    Thank you for your feedback.
    There is no issue with clearing the DB cache. From what I see, the issue is with the Action_Scheduler Are you using the Action Scheduler plugin?

    If so, can you please disable this plugin and see if the problem persists?

    Thanks!

    Thread Starter traqbar

    (@traqbar)

    Hello,

    The Action Scheduler has been removed, but it does not remove its tables on deletion. I removed them manually but then I had these errors happen.

    Is this actually Action Scheduler still trying to run even though I have uninstalled it?

    Thanks

    Thread Starter traqbar

    (@traqbar)

    Right, I see, Okay I have to contact them at Automatic for how to get rid of this plugin.

    Thanks

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

The topic ‘Not cleariing database cache’ is closed to new replies.