all hits show 'An unknown location at IP false'

Usually this means that your database user needs permission to use the “ALTER” statement. On most WordPress installations, the database user will have all privileges, so you may want to check other permissions, as well.

If this isn’t it, let me know and I’ll check some other options.

the database user will have all privileges, so you may want to check other permissions, as well

The user is the same as before and still has all privileges. I do not know what “other permissions” you might have in mind, but folder and file permissions are also the same as prior to the new database and installation of Wordfence. Wordfence had not been able to get an API on my first try, but then had no problem after I had temporarily disabled my NinjaFirewall. The ‘Visitor Maps and Who’s Online’ plugin has no trouble with IPs, but I know nothing about how either plugin gets them.

When you uninstalled and reinstalled Wordfence, did you use the option “Delete Wordfence tables and data on deactivation” near the bottom of the Wordfence Options page?

As long as the database permissions are ok, that is usually the best way to reset a Wordfence installation — if you have any settings or blocked IPs that you want to keep, you can use the “Export” button at the bottom of the Options page, and save the token that it gives you before uninstalling — then after reinstalling, you can paste the token in the Import box, to bring your settings back.

This could help especially if you had updated Wordfence on the development server, if you copied the wp-content files to the live server, but not the database tables — it could skip the normal upgrade process that would have updated some of the tables, even if table privileges were ok.

I will do the uninstall/re-install drill in the morning and let you know!

Great plugin.

…use the option “Delete Wordfence tables and data on deactivation” near the bottom of the Wordfence Options page…

…usually the best way to reset a Wordfence installation.

That worked perfectly, and I thank you very much.

This could help especially if you had updated Wordfence on the development server, if you copied the wp-content files to the live server, but not the database tables — it could skip the normal upgrade process that would have updated some of the tables, even if table privileges were ok.

I was using the “live” /wp-content/ since I had never brought /wp-content/ along to local, and Wordfence had never been activated locally. But then by the time I copied the local database back to “live”, Wordfence had been updated without the eventual database in place. So, it seems this you had mentioned had been my problem:

it could skip the normal upgrade process that would have updated some of the tables

Oops, I missed “Resolved”…

Many thanks! I have NinjaFirewall outside the compound, BulletProof Security at all the doors and Wordfence taking care of everything else. The three all play nicely together as a team and get all work done well and efficiently without ever breaking anything!

Great, glad to hear it’s all working again!