• Resolved ffeingol

    (@ffeingol)


    Hello,

    We have a site running php 7.2.x, MySQL 5.7.x, WordPress 5.2.x and WordFence 7.4.x. We’re getting the following error:

    WordPress database error Table ‘###.wp_wfHits’ doesn’t exist for query

    The table exits, but in the database it’s all lower case. Is there any way to correct this issue?

    Thanks

Viewing 1 replies (of 1 total)
  • WFAdam

    (@wfadam)

    Hello @ffeingol and thanks for reaching out to us!

    I have seen this issue before where the tables have capitals in the error message when they should all be lower case. The older versions of Wordfence used some uppercase letters, but they are all standard lowercase now.

    Somethings that helped people in the past:
    1) Clear all your caching plugins as sometimes they store the old table names.
    2) You could try resetting Wordfence to correct the issue. Though all your settings will be erased unless you use wordfence central templates.

    If you decide to go the reset route:
    You can backup your Wordfence settings via the Export option. Navigate to Wordfence > Tools > Import/Export Options and click Export. You can also take note of the current Whitelisted URLs you have in Wordfence > Firewall > All Firewall Options > Whitelisted URLs as these are NOT included in the Import/Export, and will be lost during the re-install.
    Here is what is exported: https://www.wordfence.com/help/tools/import-export/
    During the export, you will be given a long string of text. Keep this safe, you’ll need it in a few minutes.

    After that, enable the option to Delete Wordfence tables and data on deactivation in All Options > General Wordfence Options. You will want to remember to disable this after you reinstall Wordfence again.

    After you enable that option, you can deactivate Wordfence from the Plugins area of your site, then delete it. Next, from the plugins area, search for and re-install Wordfence like normal.

    It will be like setting Wordfence up for the first time. You will need to enter an email address, and then go into Tools > Import/Export Options and paste that string of text into the Import Wordfence Options field and click the button there.

    The firewall will be in Learning Mode by default for 7 days. I would recommend switching this to Enabled and Protected as soon as possible.

    Let me know if this helps!

    Thanks!

Viewing 1 replies (of 1 total)

The topic ‘Case sensitve table names wfConfig’ is closed to new replies.