DB error (1146): swcfpc_logs doesn’t exist

  • Resolved alx359

    (@alx359)


    3 years, 10 months ago

    Just noticed this error with Query Monitor, and the latest version of the plugin:

    DELETE
FROM wp_79ff9100ca_swcfpc_logs
WHERE date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY))	+
SWCFPC_Logs->delete_logs_older_than_days()
Plugin: wp-cloudflare-page-cache	
Table 'wp-domain-wp-yU2iUxrB.wp_79ff9100ca_swcfpc_logs' doesn't exist	
Error Code: 1146
Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter alx359

    (@alx359)

    3 years, 10 months ago

    Tried deleting swcfpc_logs meta_field in wp_otions as suggested in this post, but didn’t help.

    Tried deactivating, deleting, and installing the plugin again, but now this new error (3 times) was reported by QM:

    DESCRIBE IF;	+
SWCFPC_Installer->create_mysql_tables()
Plugin: wp-cloudflare-page-cache	
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 'IF' at line 1	
Error Code: 1064
    Thread Starter alx359

    (@alx359)

    3 years, 10 months ago

    Actually, those errors above fill the debug.log with more info:

    [15-Jun-2020 15:05:27 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query DELETE FROM wp_79ff9200ca_swcfpc_logs WHERE date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, SW_CLOUDFLARE_PAGECACHE->__construct, SW_CLOUDFLARE_PAGECACHE->include_libs, SWCFPC_Logs->__construct, SWCFPC_Logs->delete_logs_older_than_days, QM_DB->query
[15-Jun-2020 15:05:32 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query DELETE FROM wp_79ff9200ca_swcfpc_logs WHERE date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, SW_CLOUDFLARE_PAGECACHE->__construct, SW_CLOUDFLARE_PAGECACHE->include_libs, SWCFPC_Logs->__construct, SWCFPC_Logs->delete_logs_older_than_days, QM_DB->query
[15-Jun-2020 15:05:40 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query DELETE FROM wp_79ff9200ca_swcfpc_logs WHERE date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, SW_CLOUDFLARE_PAGECACHE->__construct, SW_CLOUDFLARE_PAGECACHE->include_libs, SWCFPC_Logs->__construct, SWCFPC_Logs->delete_logs_older_than_days, QM_DB->query
[15-Jun-2020 15:05:46 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query DELETE FROM wp_79ff9200ca_swcfpc_logs WHERE date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, SW_CLOUDFLARE_PAGECACHE->__construct, SW_CLOUDFLARE_PAGECACHE->include_libs, SWCFPC_Logs->__construct, SWCFPC_Logs->delete_logs_older_than_days, QM_DB->query
[15-Jun-2020 15:06:02 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query DELETE FROM wp_79ff9200ca_swcfpc_logs WHERE date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, SW_CLOUDFLARE_PAGECACHE->__construct, SW_CLOUDFLARE_PAGECACHE->include_libs, SWCFPC_Logs->__construct, SWCFPC_Logs->delete_logs_older_than_days
[15-Jun-2020 15:06:32 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query DELETE FROM wp_79ff9200ca_swcfpc_logs WHERE date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, SW_CLOUDFLARE_PAGECACHE->__construct, SW_CLOUDFLARE_PAGECACHE->include_libs, SWCFPC_Logs->__construct, SWCFPC_Logs->delete_logs_older_than_days, QM_DB->query
[15-Jun-2020 15:06:33 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_79ff9200ca_swcfpc_logs</code> made by require_once('wp-admin/admin.php'), do_action('settings_page_wp-cloudflare-super-page-cache-index'), WP_Hook->do_action, WP_Hook->apply_filters, SWCFPC_Backend->admin_menu_page_index, SWCFPC_Cloudflare->get_zone_id_list, SWCFPC_Logs->add_log, QM_DB->query
[15-Jun-2020 15:06:33 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_79ff9200ca_swcfpc_logs</code> made by require_once('wp-admin/admin.php'), do_action('settings_page_wp-cloudflare-super-page-cache-index'), WP_Hook->do_action, WP_Hook->apply_filters, SWCFPC_Backend->admin_menu_page_index, SWCFPC_Cloudflare->get_zone_id_list, SWCFPC_Logs->add_log, QM_DB->query
[15-Jun-2020 15:06:39 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query DELETE FROM wp_79ff9200ca_swcfpc_logs WHERE date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, SW_CLOUDFLARE_PAGECACHE->__construct, SW_CLOUDFLARE_PAGECACHE->include_libs, SWCFPC_Logs->__construct, SWCFPC_Logs->delete_logs_older_than_days, QM_DB->query
[15-Jun-2020 15:06:51 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query DELETE FROM wp_79ff9200ca_swcfpc_logs WHERE date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, SW_CLOUDFLARE_PAGECACHE->__construct, SW_CLOUDFLARE_PAGECACHE->include_libs, SWCFPC_Logs->__construct, SWCFPC_Logs->delete_logs_older_than_days
[15-Jun-2020 15:06:52 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query DELETE FROM wp_79ff9200ca_swcfpc_logs WHERE date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, SW_CLOUDFLARE_PAGECACHE->__construct, SW_CLOUDFLARE_PAGECACHE->include_libs, SWCFPC_Logs->__construct, SWCFPC_Logs->delete_logs_older_than_days, QM_DB->query
[15-Jun-2020 15:06:52 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_79ff9200ca_swcfpc_logs</code> made by require_once('wp-admin/admin.php'), do_action('settings_page_wp-cloudflare-super-page-cache-index'), WP_Hook->do_action, WP_Hook->apply_filters, SWCFPC_Backend->admin_menu_page_index, SWCFPC_Cloudflare->get_zone_id_list, SWCFPC_Logs->add_log, QM_DB->query
[15-Jun-2020 15:06:53 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_79ff9200ca_swcfpc_logs</code> made by require_once('wp-admin/admin.php'), do_action('settings_page_wp-cloudflare-super-page-cache-index'), WP_Hook->do_action, WP_Hook->apply_filters, SWCFPC_Backend->admin_menu_page_index, SWCFPC_Cloudflare->get_zone_id_list, SWCFPC_Logs->add_log, QM_DB->query
[15-Jun-2020 15:06:56 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query DELETE FROM wp_79ff9200ca_swcfpc_logs WHERE date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, SW_CLOUDFLARE_PAGECACHE->__construct, SW_CLOUDFLARE_PAGECACHE->include_libs, SWCFPC_Logs->__construct, SWCFPC_Logs->delete_logs_older_than_days, QM_DB->query
[15-Jun-2020 15:06:56 UTC] WordPress database error Table 'wp-domain-wp-yU2iUxrB.wp_79ff9200ca_swcfpc_logs' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_79ff9200ca_swcfpc_logs</code> made by do_action('wp_ajax_swcfpc_enable_page_cache'), WP_Hook->do_action, WP_Hook->apply_filters, SWCFPC_Cloudflare->ajax_enable_page_cache, SWCFPC_Cloudflare->get_current_browser_cache_ttl, SWCFPC_Logs->add_log, QM_DB->query
    Plugin Contributor Salvatore Fresta

    (@salvatorefresta)

    3 years, 10 months ago

    Hi,
    you have to delete swcfpc_version from wp_options, not swcfpc_logs

    All of the database errors related to logs has been fixed on next version I will release soon.

    Let me know

    Thread Starter alx359

    (@alx359)

    3 years, 10 months ago

    Okay thanks, will do, but please mind the other errors upon installation, too.

    Plugin Contributor Salvatore Fresta

    (@salvatorefresta)

    3 years, 10 months ago

    What other errors do you encounter during installation? If you don’t mind, send me an email to replicate them on my environment and fix them

    Thread Starter alx359

    (@alx359)

    3 years, 10 months ago

    This one of 2nd post above:

    Tried deactivating, deleting, and installing the plugin again, but now this new error (3 times) was reported by QM:

    DESCRIBE IF;	+
SWCFPC_Installer->create_mysql_tables()
Plugin: wp-cloudflare-page-cache	
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 'IF' at line 1	
Error Code: 1064

    I catched it with Query Monitor and debug=1 after installation, but disappears right after page reload. Hope it’s replicable.

    Plugin Contributor Salvatore Fresta

    (@salvatorefresta)

    3 years, 10 months ago

    Ok but on next release this table will be deleted. A file will be used for the logs, so this is a temporary problem of this version

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘DB error (1146): swcfpc_logs doesn’t exist’ is closed to new replies.