{"id":18143081,"date":"2024-11-18T10:53:42","date_gmt":"2024-11-18T10:53:42","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-error-414\/"},"modified":"2024-11-18T10:53:42","modified_gmt":"2024-11-18T10:53:42","slug":"database-error-414","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-error-414\/","title":{"rendered":"database error"},"content":{"rendered":"\n

Hi, I received this log entry a couple of days ago, and it’s occurring every few hours. Please note that I’ve replaced sensitive information with placeholders for security reasons. This plugin worked without any issues for the past two years. Here is the log:

<\/p>\n\n\n\n

[17-Nov-2024 22:25:13 UTC] WordPress database error Table ‘database_name.wp_table_name’ doesn’t exist for query SELECT
t.term_id
FROM custom_prefix_terms as t
LEFT JOIN custom_prefix_term_taxonomy as tt ON tt.term_id = t.term_id
WHERE 1 = 1 AND<\/p>\n\n\n\n

        ( t.term_id IN\n            (\n                SELECT tt.term_id\n                FROM custom_prefix_term_taxonomy as tt\n                WHERE tt.taxonomy = 'category'\n                AND \n                    (\n                        tt.count > 0 OR\n                        EXISTS (\n                            SELECT 1\n                            FROM wp_table_name as tt2\n                            WHERE tt2.parent = tt.term_id \n                            AND tt2.count > 0\n                        )\n                    )\n            )\n        )<\/code><\/pre>\n\n\n\n
ORDER BY t.term_id ASC
LIMIT 0, 1000
\/* 1 = 1 *\/ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\\Plugin\\Common\\Sitemap\\RequestParser->checkRequest, AIOSEO\\Plugin\\Common\\Sitemap\\RequestParser->checkForGeneralSitemap, AIOSEO\\Plugin\\Common\\Sitemap\\Sitemap->generate, AIOSEO\\Plugin\\Common\\Sitemap\\Content->get, AIOSEO\\Plugin\\Common\\Sitemap\\Content->terms, AIOSEO\\Plugin\\Common\\Sitemap\\Query->terms, AIOSEO\\Plugin\\Common\\Utils\\Database->run
[17-Nov-2024 22:25:13 UTC] WordPress database error Table ‘database_name.wp_table_name’ doesn’t exist for query SELECT
count(t.term_id) as total
FROM custom_prefix_terms as t
LEFT JOIN custom_prefix_term_taxonomy as tt ON tt.term_id = t.term_id
WHERE 1 = 1 AND<\/p>\n\n\n\n
        ( t.term_id IN\n            (\n                SELECT tt.term_id\n                FROM custom_prefix_term_taxonomy as tt\n                WHERE tt.taxonomy = 'category'\n                AND \n                    (\n                        tt.count > 0 OR\n                        EXISTS (\n                            SELECT 1\n                            FROM wp_table_name as tt2\n                            WHERE tt2.parent = tt.term_id \n                            AND tt2.count > 0\n                        )\n                    )\n            )\n        )<\/code><\/pre>\n\n\n\n
\/* 1 = 1 *\/ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\\Plugin\\Common\\Sitemap\\RequestParser->checkRequest, AIOSEO\\Plugin\\Common\\Sitemap\\RequestParser->checkForGeneralSitemap, AIOSEO\\Plugin\\Common\\Sitemap\\Sitemap->generate, AIOSEO\\Plugin\\Common\\Sitemap\\Content->getTotal, AIOSEO\\Plugin\\Common\\Sitemap\\Query->terms, AIOSEO\\Plugin\\Common\\Utils\\Database->run<\/p>\n\n\n\n

<\/p>\n","protected":false},"template":"","class_list":["post-18143081","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18143081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18143081\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=18143081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}