• Resolved anvilhouse

    (@anvilhouse)


    We started getting a multitude of wpdb errors for All in one seo plugin after updating to the latest version distributed. We have made no major website changes since the last update aside from removing some old unused media files (images:jpg,png)

    Any help with this would be wonderful

    an 26, 10:59:44

    WordPress database error Table 'engine_wp.wp_aioseo_terms' doesn't exist for query SELECT COUNT(*) as childProductAttributes
    FROM wp_term_taxonomy AS tt
    JOIN wp_woocommerce_attribute_taxonomies AS wat ON tt.taxonomy = CONCAT('pa_', wat.attribute_name)
    LEFT JOIN wp_aioseo_terms AS at ON tt.term_id = at.term_id
    WHERE wat.attribute_public = 1

    AND tt.count > 0
    ; 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\Root->indexes, AIOSEO\Plugin\Common\Sitemap\Content->productAttributes, AIOSEO\Plugin\Common\Utils\Database->execute, 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

    Jan 26, 10:59:44

    Fatal error: Uncaught TypeError: mysqli_num_fields(): Argument #1 ($result) must be of type mysqli_result, bool given in /home/engine/public_html/wp-includes/class-wpdb.php:3859
    Stack Trace
    1. mysqli_num_fields(false)/home/engine/public_html/wp-includes/class-wpdb.php:3859
    2. wpdb->load_col_info()/home/engine/public_html/wp-includes/class-wpdb.php:780
    3. wpdb->__get('col_info')/home/engine/public_html/wp-content/plugins/w3-total-cache/DbCache_WpdbInjection_QueryCaching.php:227
    4. W3TC\DbCache_WpdbInjection_QueryCaching->query('SELECT COUNT(*)...')/home/engine/public_html/wp-content/plugins/w3-total-cache/DbCache_WpdbNew.php:122
    5. W3TC\DbCache_WpdbNew->query('SELECT COUNT(*)...')/home/engine/public_html/wp-includes/class-wpdb.php:3142
    6. wpdb->get_results('SELECT COUNT(*)...', 'OBJECT')/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Utils/Database.php:1493
    7. AIOSEO\Plugin\Common\Utils\Database->execute('SELECT COUNT(*)...', true)/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Sitemap/Content.php:875
    8. AIOSEO\Plugin\Common\Sitemap\Content->productAttributes(true)/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Sitemap/Root.php:149
    9. AIOSEO\Plugin\Common\Sitemap\Root->indexes()/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Sitemap/Content.php:48
    10. AIOSEO\Plugin\Common\Sitemap\Content->get()/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Sitemap/Sitemap.php:338
    11. AIOSEO\Plugin\Common\Sitemap\Sitemap->generate()/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Sitemap/RequestParser.php:119
    12. AIOSEO\Plugin\Common\Sitemap\RequestParser->checkForGeneralSitemap()/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Sitemap/RequestParser.php:71
    13. AIOSEO\Plugin\Common\Sitemap\RequestParser->checkRequest(Object(WP))/home/engine/public_html/wp-includes/class-wp-hook.php:324
    16. do_action_ref_array('parse_request', Array)/home/engine/public_html/wp-includes/class-wp.php:418
    17. WP->parse_request('')/home/engine/public_html/wp-includes/class-wp.php:813
    18. WP->main('')/home/engine/public_html/wp-includes/functions.php:1336
    20. require('/home/engine/pu...')/home/engine/public_html/index.php:17
    21. {main}
    thrown in /home/engine/public_html/wp-includes/class-wpdb.php on line 3859
    Show 3 more

    Jan 26, 10:59:56

    WordPress database error Table 'engine_wp.wp_aioseo_terms' doesn't exist for query SELECT COUNT(*) as childProductAttributes
    FROM wp_term_taxonomy AS tt
    JOIN wp_woocommerce_attribute_taxonomies AS wat ON tt.taxonomy = CONCAT('pa_', wat.attribute_name)
    LEFT JOIN wp_aioseo_terms AS at ON tt.term_id = at.term_id
    WHERE wat.attribute_public = 1

    AND tt.count > 0
    ; 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\Root->indexes, AIOSEO\Plugin\Common\Sitemap\Content->productAttributes, AIOSEO\Plugin\Common\Utils\Database->execute, 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
    Mark as fixed | Ignore

    Jan 26, 10:59:56

    Fatal error: Uncaught TypeError: mysqli_num_fields(): Argument #1 ($result) must be of type mysqli_result, bool given in /home/engine/public_html/wp-includes/class-wpdb.php:3859
    Stack Trace
    1. mysqli_num_fields(false)/home/engine/public_html/wp-includes/class-wpdb.php:3859
    2. wpdb->load_col_info()/home/engine/public_html/wp-includes/class-wpdb.php:780
    3. wpdb->__get('col_info')/home/engine/public_html/wp-content/plugins/w3-total-cache/DbCache_WpdbInjection_QueryCaching.php:227
    4. W3TC\DbCache_WpdbInjection_QueryCaching->query('SELECT COUNT(*)...')/home/engine/public_html/wp-content/plugins/w3-total-cache/DbCache_WpdbNew.php:122
    5. W3TC\DbCache_WpdbNew->query('SELECT COUNT(*)...')/home/engine/public_html/wp-includes/class-wpdb.php:3142
    6. wpdb->get_results('SELECT COUNT(*)...', 'OBJECT')/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Utils/Database.php:1493
    7. AIOSEO\Plugin\Common\Utils\Database->execute('SELECT COUNT(*)...', true)/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Sitemap/Content.php:875
    8. AIOSEO\Plugin\Common\Sitemap\Content->productAttributes(true)/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Sitemap/Root.php:149
    9. AIOSEO\Plugin\Common\Sitemap\Root->indexes()/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Sitemap/Content.php:48
    10. AIOSEO\Plugin\Common\Sitemap\Content->get()/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Sitemap/Sitemap.php:338
    11. AIOSEO\Plugin\Common\Sitemap\Sitemap->generate()/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Sitemap/RequestParser.php:119
    12. AIOSEO\Plugin\Common\Sitemap\RequestParser->checkForGeneralSitemap()/home/engine/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Sitemap/RequestParser.php:71
    13. AIOSEO\Plugin\Common\Sitemap\RequestParser->checkRequest(Object(WP))/home/engine/public_html/wp-includes/class-wp-hook.php:324
    16. do_action_ref_array('parse_request', Array)/home/engine/public_html/wp-includes/class-wp.php:418
    17. WP->parse_request('')/home/engine/public_html/wp-includes/class-wp.php:813
    18. WP->main('')/home/engine/public_html/wp-includes/functions.php:1336
    20. require('/home/engine/pu...')/home/engine/public_html/index.php:17
    21. {main}
    thrown in /home/engine/public_html/wp-includes/class-wpdb.php on line 3859
    Show 3 morees/class-wpdb.php on line 3859
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.