Breaks on Reset Indexables tables & Migrations

[maganap]

Please give us a description of what happened.

After migrating our site from development to production (to a different URL), the canonical URLs included in the header of all pages is wrong.

Similar to this problem:
https://wp-staging.com/docs/yoast-canonical-urls-are-wrong-after-site-migration/

So we installed this plugin, ran "Reset Indexables tables & Migrations", and an error occurred (Fatal error was shown on screen).

Error log is this:

[error] 1670#0: *8685 FastCGI sent in stderr: "PHP message: WordPress database error Table 'wp_depaning3.wp_yoast_prominent_words' doesn't exist for query TRUNCATE TABLE wp_yoast_prominent_words made by do_action('admin_post_wordpress-seo-feature-reset'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\Test_Helper\WordPress_Plugin_Features->handle_reset_feature, Yoast\WP\Test_Helper\WordPress_Plugin_Features->reset_feature, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_feature, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_indexables, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_prominent_words_calculationPHP message: PHP Fatal error:  Uncaught YoastSEO_Vendor\Symfony\Component\DependencyInjection\Exception\ServiceNotFoundException: You have requested a non-existent service "Yoast\WP\SEO\Helpers\Indexing_Helper". Did you mean one of these: "Yoast\WP\SEO\Builders\Indexable_Builder", "Yoast\WP\SEO\Helpers\Blocks_Helper", "Yoast\WP\SEO\Helpers\Current_Page_Helper", "Yoast\WP\SEO\Helpers\Date_Helper", "Yoast\WP\SEO\Helpers\Home_Url_Helper", "Yoast\WP\SEO\Helpers\Image_Helper", "Yoast\WP\SEO\Helpers\Meta_Helper", "Yoast\WP\SEO\Helpers\Options_Helper", "Yoast\WP\SEO\Helpers\Pagination_Helper", "Yoast\WP\SEO\Helpers\Post_Helper", "Yoast\WP\SEO\Helpers\Post_Type_Helper", "Yoast\WP\SEO\Helpers\Primary_Term_Helper", "Yoast\WP\SEO\Helpers\Product_Helper", "Yoast\WP\SEO\Helpers\Redirect_Helper", "Yoast\WP\SEO\Helpers\Robots_Helper", "Yoast\WP\SEO\Helpers\Schema\Article_Helper", "Yoast\WP\SEO\Helpers\Schema\HTML_Helper", "Yoast\WP\SEO\Helpers\Schema\ID_Helper", "Yoast\WP\SEO\Helpers\Schema\Image_Helper", "Yoast\WP\SEO\" while reading response header from upstream, client: 130.211.1.54, server: www.depaning.fr, request: "POST /wp-admin/admin-post.php HTTP/1.1", upstream: "fastcgi://unix:/opt/bitnami/php/var/run/www.sock:", host: "www.depaning.fr", referrer: "https://www.depaning.fr/wp-admin/tools.php?page=yoast-test-helper"

Please describe what you expected to happen and why.

The "Reset Indexables tables & Migrations" should have fixed the problem about the canonical URLs being outdated.

How can we reproduce this behavior?

As explained above as per our current configuration.

Additional information:

Yoast Test Helper: v1.10
Yoast SEO: v14.1.

These are the current tables related to yoast:

| wp_yoast_indexable           |
| wp_yoast_indexable_hierarchy |
| wp_yoast_migrations          |
| wp_yoast_primary_term        |
| wp_yoast_seo_links           |
| wp_yoast_seo_meta            |

So, should wp_yoast_prominent_words exist? Or should this plugin consider it may not exist?

[studiodeep77]

I have the same problem!!
Im still looking how I can fix it!

[kirc0de]

I couldn't find a solution. But I installed 1.9 version of yoast-helper and it works without error.
You can find it here: https://github.com/Yoast/yoast-test-helper/releases/tag/1.9.0.
Dont' forget to exec composer install command after importing plugin zip and before installing it.

[Qrzysio]

Facing the same issue.