Latest version producing database errors post updating
-
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 wonderfulan 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.