error occurred while installing your license key (Free)

Hi @trex2303, thanks for reaching out.

Diagnostics showing?Basic config writing?and?Serialized config writing?are failing can often be solved by deactivating and reactivating the plugin again, or you may need to do a clean Wordfence installation.

We sometimes see this when a migration is being performed due to certain differences between the previous setup and the new one (like mixed-case table names), but that may not be the case here.

If a reactivation or fresh installation doesn’t solve the messages, use the Wordfence > Tools menu to send us the diagnostic report so we can take a closer look at the other settings. You can send that to us at wftest @ wordfence . com. Click on “Send Report by Email”. Please add your forum username where indicated and respond here after you have sent it.

NOTE: It should look as follows – Screenshot of Tools > Diagnostic > Send by Email

Thanks,
Peter.

Deactivated/reactivated – uninstalled (deleted everything) and Reinstalled, and still receiving the error message. I have went to Tools – Diagnostic > Send by Email and sent it through

Hi @trex2303, thanks for sending that over.

I can see there is a database connection as I suspected, but it’s actually the tables are missing altogether. This is a strange one because absolutely everything else (including all required database permissions) are reporting back as “OK”.

When installing Wordfence, do you receive any on-screen messages within WordPress that might suggest there was a problem creating the database tables? If so, it might give a reason that we can work with. Sometimes a cause for this is migrating your site from a Windows machine (including local environments), or that there is database caching present that needs to be cleared.

Let me know if any of that is/was the case,
Peter.

No, there was no error messages when installing WordFence. I goto Plugins > Add new Plugin > search for “WordFence” and install/activate Wordfence Security – Firewall, Malware Scan, and Login Security. And it just installs and then I click Activate.. No error messages or anything. Just the License message pops up

@wfpeter
Do you have something that I could try adding the missing tables? And see if that fixes anything? Seeings It’s my server, I have access to everything on the server itself.

Hi @trex2303,

If the database user has access to multiple databases, it turns out our diagnostics will (currently) report privileges for any databases that user has access to. In this case, the database user might not have full access to all databases or all tables.

I’d recommend checking that the database user has “all privileges” on the server.

If you can run the query below as the same user in the database as the one your site uses, it will show what privileges it has on which databases: show grants for current_user();

Thanks,
Peter.

User has All Privileges.

(username/password removed for security)

Your SQL query has been executed successfully.

show grants for current_user();

GRANT USAGE ON *.* TO '(user)'@'localhost' IDENTIFIED BY PASSWORD 'Password removed'
GRANT ALL PRIVILEGES ON (sameuser)\_%.* TO '(sameuser)'@'localhost'