Database errors after update from version 12

Hi there,
I have updated my WordPress version from 4.9 to 5.5, and Yoast SEO from 12.0 to 14.9 and now to 15.0.

My main problem is that the only table created by Yoast SEO 14 has been the wp_yoast_seo_meta, the other tables have dissapeared. I have discovered because the amount of database errors make my logs file get almost 30 gigas, and crashed my whole VPS.

After seeing that, I tried to replicate the YOAST tables of my old 12 version, tables like: wpisa_yoast_indexable, wpisa_yoast_indexable_hierarchy, etc… But it worked only partially, as I was still having databases errors.

I tried to install again, but I got errors as well in the new installation.

Then I tried to use Yoast Helper following these steps but it did not fixed my issue,
actually the Reset Indexables tables deleted again all the tables I created by hand.

1) Install the Yoast Test Helper plugin, found here https://www.ads-software.com/plugins/yoast-test-helper/
2) Go to Tools → Yoast Test
3) Click the Reset Indexables tables & migrations button.
4) Go to SEO → Tools.
5) Click the Start processing and speed up your site now button and let it complete.

I have created the tables by hand again, but I’m receiving errors like this one:

Error Unknown column 'indexable_id' in 'field list' de la base de datos de WordPress para la consulta 

INSERT INTO <code>wpisa_yoast_seo_links</code> (<code>url</code>, <code>type</code>, <code>indexable_id</code>, <code>post_id</code>) 

VALUES ('website.com/sobre-mi/', 'internal', NULL, '9289') realizada por do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Admin\Admin_Columns_Cache_Integration->fill_cache, Yoast\WP\SEO\Repositories\Indexable_Repository->find_by_multiple_ids_and_type, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_id_and_type, Yoast\WP\SEO\Builders\Indexable_Post_Builder->build, Yoast\WP\SEO\Builders\Indexable_Link_Builder->build, Yoast\WP\SEO\Builders\Indexable_Link_Builder->update_related_indexables, Yoast\WP\Lib\Model->save, Yoast\WP\Lib\ORM->save, Yoast\WP\Lib\ORM::execute

So, I have create the indexable_id filed in the database, but now I’m receiving the following error:

Error Column 'indexable_id' cannot be null de la base de datos de WordPress para la consulta INSERT INTOwpisa_yoast_seo_links(url,type,indexable_id,post_id) VALUES ('website.com/wp-content/uploads/2016/04/mermelada.jpg', 'internal', NULL, '9289') realizada por do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Admin\Admin_Columns_Cache_Integration->fill_cache, Yoast\WP\SEO\Repositories\Indexable_Repository->find_by_multiple_ids_and_type, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_id_and_type, Yoast\WP\SEO\Builders\Indexable_Post_Builder->build, Yoast\WP\SEO\Builders\Indexable_Link_Builder->build, Yoast\WP\SEO\Builders\Indexable_Link_Builder->update_related_indexables, Yoast\WP\Lib\Model->save, Yoast\WP\Lib\ORM->save, Yoast\WP\Lib\ORM::execute

PLEASE HELP!!

I have seen that my database has privileges for ALTER, CREATE, SELECT, INDEX, DROP, EXECUTE, INSERT & UPDATE.

I’m completely stuck, and I do not know how to fix all these errors, because Yoast SEO is not working nor creating the links even installing again.

BTW, If I remove completely from my site, will I lose all the serps I have created for each post?

IMPORTANT! I’m using Maria DB 10.3, and the codification of the database is utf8mb4_unicode_520_ci of all the tables.

Any ideas about how to fix it, because the helper did not help me at all!!

Thanks in advance!

• This topic was modified 4 years, 1 month ago by luismoyano.