php_errorlog issues with Yoast

Resolved greaterchicago
(@greaterchicago)

5 years, 4 months ago

I am getting consistent “WordPress database error Table” errors from the Yoast SEO plugin. That plugin and WP Forms Lite blew up my php_errorlog file today. I removed both plugins, and the errors stopped. I added the Yoast SEO plugin back, and I continued to receive these errors.

Here’s an example of the 20 errors I received:

[06-Jan-2021 14:57:19 UTC] WordPress database error Table ‘db63f5rmqfyngc.97a_yoast_indexable’ doesn’t exist for query SELECT * FROM 97a_yoast_indexable WHERE object_id = ‘4’ AND object_type = ‘post’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/Divi/page.php’), get_header, locate_template, load_template, require_once(‘/themes/Divi/header.php’), wp_head, do_action(‘wp_head’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->call_wpseo_head, do_action(‘wpseo_head’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->present_head, Yoast\WP\SEO\Memoizers\Meta_Tags_Context_Memoizer->for_current_page, Yoast\WP\SEO\Repositories\Indexable_Repository->for_current_page, Yoast\WP\SEO\Repositories\Indexable_Repository->find_by_id_and_type, Yoast\WP\Lib\ORM->find_one, Yoast\WP\Lib\ORM->run, Yoast\WP\Lib\ORM::execute

The page I need help with: [log in to see the link]

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

Rumejan
(@onlyincebu)

5 years, 4 months ago

Hello!

Sorry for the trouble. First of all, can you please make sure you’re running the latest version of WordPress (5.6), Yoast SEO (15.5), and the latest version of your theme and ALL other plugins?

Thread Starter greaterchicago
(@greaterchicago)

5 years, 4 months ago

@onlyincebu Thank you for your swift response. I am for sure. Everything is completely up-to-date. I’ve eliminated all unused plugins and themes too. I have Yoast SEO uninstalled currently. I can reinstall it again, realizing that it will start to throw php_errorlog entries into the file again.

Suwash Kunwar
(@suascat_wp)

5 years, 4 months ago

@greaterchicago The error you are seeing occurs when the {prefix}_yoast_indexabletable doesn’t exist. So, can you please confirm whether you have performed the SEO data optimization from the SEO → Tools page? If not, please run the SEO data optimization to see whether this resolves the issue for you.

However, if you have already performed the SEO data optimization and the issue persists, we recommend you please create the relevant table manually by following the steps given here. Error: Yoast SEO cannot create database tables

Thread Starter greaterchicago
(@greaterchicago)

5 years, 4 months ago

Thanks for that @suascat_wp I did run that optimization as you recommended.

After clearing my cache, I received this error in the header in the WP Dashboard:

Warning: array_map(): Expected parameter 2 to be an array, bool given in /home/customer/www/playersguitarshop.com/public_html/wp-content/plugins/wordpress-seo/inc/class-wpseo-meta.php on line 1017

My php_errorlog again populated with at least 20 lines of errors similar to this: [07-Jan-2021 07:02:31 UTC] WordPress database error Table ‘db63f5rmqfyngc.97a_yoast_indexable’ doesn’t exist for query SELECT * FROM 97a_yoast_indexable WHERE object_id = ‘4’ AND object_type = ‘post’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/Divi/includes/builder/frontend-builder/bfb-template.php’), wp_head, do_action(‘wp_head’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->call_wpseo_head, do_action(‘wpseo_head’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->present_head, Yoast\WP\SEO\Memoizers\Meta_Tags_Context_Memoizer->for_current_page, Yoast\WP\SEO\Repositories\Indexable_Repository->for_current_page, Yoast\WP\SEO\Repositories\Indexable_Repository->find_by_id_and_type, Yoast\WP\Lib\ORM->find_one, Yoast\WP\Lib\ORM->run, Yoast\WP\Lib\ORM::execute
Md Mazedul Islam Khan
(@mazedulislamkhan)

5 years, 4 months ago
We are sorry to hear that you’re still having trouble with our plugin. It looks like Yoast SEO failing to create the {prefix}_yoast_indexable table on the database of your website and as such, the error log keeps populating with the same errors.

To investigate the issue further, we recommend you please disable all the 3rd party plugins and switch to the default 2020 theme on your site. If you don’t wish to disable everything except Yoast SEO on your production website, you can use the Health Check plugin troubleshooting mode for this to make sure that no one else affected by this. You can find the relevant guide here https://yoast.com/help/how-to-check-for-plugin-conflicts/.

Once you are in the troubleshooting mode, we recommend you please install and activate the Yoast Test Helper plugin to reset the Yoast SEO Indexables tables and migrations by following the steps given below:
- Install and activate Yoast Test Helper plugin;
- Go to Tools → Yoast Test → Yoast SEO → Reset Indexables tables & migrations options to reset it;
- Run the SEO data optimization from the SEO → Tools page.
Once you perform all the above steps, please check whether this resolves the issue for you.
Thread Starter greaterchicago
(@greaterchicago)

5 years, 4 months ago

Thank you. I installed the Health Check plugin. There are no conflicts. However, it does state that the minimum PHP value isn’t available.

I’ll try runnin the Yoast Test Helper plugin next. I’m still getting this error on all Pages in the Dashboard:

Warning: array_map(): Expected parameter 2 to be an array, bool given in /home/customer/www/playersguitarshop.com/public_html/wp-content/plugins/wordpress-seo/inc/class-wpseo-meta.php on line 1017

And I’m still getting php_errorlog entries.

Thread Starter greaterchicago
(@greaterchicago)

5 years, 4 months ago

When I installed and activated the Yoast Test Helper plugin and ran Tools → Yoast Test → Yoast SEO → Reset Indexables tables & migrations options to reset it, I received the following error:

Fatal error: Uncaught Error: Class ‘WPSEO_Options’ not found in /home/customer/www/playersguitarshop.com/public_html/wp-content/plugins/yoast-test-helper/src/wordpress-plugins/yoast-seo.php:152 Stack trace: #0 /home/customer/www/playersguitarshop.com/public_html/wp-content/plugins/yoast-test-helper/src/wordpress-plugins/yoast-seo.php(221): Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_prominent_words_calculation() #1 /home/customer/www/playersguitarshop.com/public_html/wp-content/plugins/yoast-test-helper/src/wordpress-plugins/yoast-seo.php(102): Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_indexables() #2 /home/customer/www/playersguitarshop.com/public_html/wp-content/plugins/yoast-test-helper/src/wordpress-plugin-features.php(142): Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_feature(‘reset_indexable…’) #3 /home/customer/www/playersguitarshop.com/public_html/wp-content/plugins/yoast-test-helper/src/wordpress-plugin-features.php(104): Yoast\WP\Test_Helper\WordPress_Plugin_Features->reset in /home/customer/www/playersguitarshop.com/public_html/wp-content/plugins/yoast-test-helper/src/wordpress-plugins/yoast-seo.php on line 152

Plugin Support Michael Tiña
(@mikes41720)

5 years, 4 months ago

Hi,

We’re sorry to hear you encountered a fatal error when attempting to reset the indexables tables & migrations options using the Yoast Test Helper plugin.

Just to clarify, could you also check if you are meeting all of the necessary plugin requirements — https://yoast.com/help/plugin-requirements/

Also, did you enable troubleshooting mode of the Health Check & Troubleshooting plugin (and then reverting to a default theme and only Yoast SEO and Yoast Test Helper enabled) before attempting to reset the indexables?

devnihil
(@devnihil)

5 years, 4 months ago

We are going ahead and marking this issue as resolved due to inactivity. If you require any further assistance please create a new issue.