Repair invisible SEO and database maintenance

What it is

Utility is one page with everything you need on the day the SEO has to move, be saved or be repaired. It is a single grid of cards, laid out so that each one is as tall as its own content and the short ones do not leave holes, in the order you are most likely to need them: SEO data transfer / sync, SEO data backup / restore, Settings import / export, LIVE SEO preview, Database cleanup, Fix SEO database, Repair invisible SEO (Yoast), Error log, Optimization history. With the Premium component there is also an Automation card, right after the transfer. Two of these cards are the repair tools, and they are the subject of this article.

Repair invisible SEO (Yoast) — from Yoast 14 the frontend serves SEO from an internal cache, the wp_yoast_indexable table, and not from the fields you see in the editor. After an import, a migration, or switching WPML on, that cache goes stale: the SEO is set but does not show on the page, nor in the rotation preview. The tool counts the affected items and rebuilds the cache by deleting the stale indexable rows, and the orphaned hierarchy rows with them; Yoast rebuilds them from the post meta on the next visit and the SEO becomes visible again. The card appears only when Yoast is the active SEO plugin, because the table is a Yoast thing.

Fix SEO database — finds and repairs SEO fields left dirty by imports or migrations: broken tokens such as %tegory%%, separators orphaned at the end of a title, double spaces. It also clears out legacy options and orphaned cron entries. Valid tokens like %%sitename%% are preserved, and the previous values stay restorable with an Undo button.

Where to find it

AISA → Utility. Both cards are in the lower half of the grid: Fix SEO database after Database cleanup, and Repair invisible SEO (Yoast) immediately after it, before the error log.

Requirements & tier

Free, with the administrator capability (manage_options). Repair invisible SEO needs Yoast active and its indexable table present. Neither tool makes any external call: they read and write your own database.

How to use

Open AISA → Utility and scroll to the two repair cards.
Each card first tells you how much there is to do: how many items have SEO that Yoast is not showing, how many fields look dirty. If the number is zero there is nothing to run.
Press the repair button and read the result, which is a count, not a “done”.
For Fix SEO database, check a couple of the affected titles. If the outcome is not what you wanted, use Undo — the previous values are kept.
For Repair invisible SEO, reload a page on the frontend: the SEO should be there. It is also worth running after any large import.

Questions people ask

The SEO is filled in the editor but does not appear on the page — why? With Yoast 14 and later the page is served from the stale indexable cache. Run Repair invisible SEO. Going forward AISA also refreshes the indexable whenever it writes SEO, so newly generated values show up without a manual repair.
Is Fix SEO database safe? Yes. It keeps valid variable tokens and saves the previous values, so one click puts them back.
Why can I not see the Repair invisible SEO card? It only shows when Yoast is the active SEO plugin, since the indexable table belongs to Yoast.
Where did the Automation page go? It is no longer a menu item: scheduled regeneration is now a card on this same page, right after the transfer card, with its status and its “run now in the background” button. It comes with the Premium component, so on the free version the card is simply not there.
Do these tools touch my content? No. They work on SEO fields and on caches; the body of your pages is never rewritten here.

SEO is set but not visible (Yoast)
Backup and Restore SEO
SEO data transfer / sync: move your SEO between AISA and your SEO plugin
Scheduled SEO regeneration (Scheduler)