Removing site redirect does not remove database entry.

[jmwindler]

Summary

When removing Site Redirect, browsers show "Error: too many redirects".

Steps to reproduce

We had another site entered in the field "Relocate to domain:" for a period, and then removed the site from that field in order to discontinue the site redirect. After this browsers were displaying "Error too many redirects" when visiting the root URL.

I tried disabling the Redirection plugin both from within the Wordpress Admin, and also using the temporary solution that you recommend via "wp-config.php" and in both cases disabling redirection removed the issue.

I investigated the database and discovered that, when clearing the field "Relocate to domain:", this leaves a persistent entry in the database table "wp_redirection_items" with column "url" = "/" and column "action_data" = "/".

Deleting that row from the database cleared the issue. Removing an entry from the field "Relocate to domain:" ought to remove the entry from the database rather than replacing with "/".

[johngodley]

The relocation to domain option does not create a redirect entry in the database. If you have an entry there then it is from something else.