Database errors reported on update to version 3.3.0

  • Resolved Aharon

    (@spaceling)


    1 month, 2 weeks ago

    After updating to v.3.3.0, we began to see recurring WordPress database errors in our degub.log. (We’ve since gone back to v.3.2.2.) Our environment is WP 6.9.4,  PHP 8.4.18, and 10.11.16-MariaDB. Below is an example from the debug.log (with redacted database/table name details):

    [18-Mar-2026 01:53:57 UTC] WordPress database error Table 'xxx_xxxx.wp_xxxxx_abj404_view_cache' doesn't exist for query DELETE FROM wp_xxxxx_abj404_view_cache WHERE 1=1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, abj404_404listener, ABJ_404_Solution_WordPress_Connector->process404, ABJ_404_Solution_FrontendRequestPipeline->process404, ABJ_404_Solution_PluginLogic->sendTo404Page, ABJ_404_Solution_DataAccess->setupRedirect, ABJ_404_Solution_DataAccess->invalidateStatusCountsCache, ABJ_404_Solution_DataAccess->invalidateViewSnapshotCache, ABJ_404_Solution_DataAccess->queryAndGetResults

    Thank you for your excellent plugin. Hoping this report provides a helpful lead for you.

    • This topic was modified 1 month, 2 weeks ago by Aharon.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Aaron

    (@aaron13100)

    1 month, 2 weeks ago

    Hey Aharon,

    I really appreciate the feedback. I’m working on a fix right now! I guess it will be ready later today.

    Plugin Author Aaron

    (@aaron13100)

    1 month, 2 weeks ago

    Hey,

    Hopefully everything is fixed now. I did a quick release of 3.3.1 yesterday and now there should be more stable version of 3.3.3 available to download. Let me know if you have any more issues.

    thanks

    Plugin Author Aaron

    (@aaron13100)

    1 month, 1 week ago

    Hopefully everything is fixed in the most recent version 3.3.7.

    Thread Starter Aharon

    (@spaceling)

    1 month, 1 week ago

    We did see messages in the debug.log after each update, but nothing like the flood after 3.3.0. I think we may also be seeing a couple messages getting reported after the plugin has something scheduled in cron. It’s hard to tell since it’s only been around a day. Here are the messages in case they are helpful (our site seems to be operating normally).

    [21-Mar-2026 05:17:22 UTC] WordPress database error Table 'xxxxx_xxxxx.wp_abj404_redirects' doesn't exist for query 
    /* ------------------ /home/xxxxx/public_html/xxxxx/wp-content/plugins/404-solution/includes/sql/getOrphanedAutoRedirects.sql BEGIN ----- */ 

    SELECT r.id, r.url, r.final_dest
    FROM wp_abj404_redirects r
    LEFT JOIN wp_posts p ON r.final_dest = p.ID
    WHERE r.status = 2
      AND r.disabled = 0
      AND r.type = 1
      AND (p.ID IS NULL OR p.post_status NOT IN ('publish', 'inherit'))

    /* ------------------ /home/xxxxx/public_html/xxxxx/wp-content/plugins/404-solution/includes/sql/getOrphanedAutoRedirects.sql END ----- */ 
     made by do_action_ref_array('abj404_cleanupCronAction'), WP_Hook->do_action, WP_Hook->apply_filters, abj404_dailyMaintenanceCronJobListener, ABJ_404_Solution_DataAccess->deleteOldRedirectsCron, ABJ_404_Solution_DataAccess->cleanupOrphanedAutoRedirects, ABJ_404_Solution_DataAccess->queryAndGetResults

    [21-Mar-2026 05:17:22 UTC] WordPress database error Table 'xxxxx_xxxxx.wp_abj404_redirects' doesn't exist for query 
    /* ------------------ /home/xxxxx/public_html/xxxxx/wp-content/plugins/404-solution/includes/sql/getOrphanedAutoRedirects.sql BEGIN ----- */ 

    SELECT r.id, r.url, r.final_dest
    FROM wp_abj404_redirects r
    LEFT JOIN wp_posts p ON r.final_dest = p.ID
    WHERE r.status = 2
      AND r.disabled = 0
      AND r.type = 1
      AND (p.ID IS NULL OR p.post_status NOT IN ('publish', 'inherit'))

    /* ------------------ /home/xxxxx/public_html/xxxxx/wp-content/plugins/404-solution/includes/sql/getOrphanedAutoRedirects.sql END ----- */ 
     made by do_action_ref_array('abj404_cleanupCronAction'), WP_Hook->do_action, WP_Hook->apply_filters, abj404_dailyMaintenanceCronJobListener, ABJ_404_Solution_DataAccess->deleteOldRedirectsCron, ABJ_404_Solution_DataAccess->cleanupOrphanedAutoRedirects, ABJ_404_Solution_DataAccess->queryAndGetResults, ABJ_404_Solution_DataAccess->attemptMissingTableRepairAndRetry
    Plugin Author Aaron

    (@aaron13100)

    1 month, 1 week ago

    Thanks. The exact logs are helpful. Most issues have been resolved. I’m still monitoring the debug feedback logs that people can opt in to.

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

You must be logged in to reply to this topic.