Double Wordfence tables and Duplicator

  • Resolved dickprovoost

    (@dickprovoosthotmailcom)


    9 years ago

    After developing locale i delete my Wordfence-plugins en reinstall the plugin after publishing to my production-site. Using Duplicator i had a lot of problems with unpacking the zip-package. I figured out this was because of double Wordfence tables, 1 with lowercase-name and 1 with camel-case-name. Only after deleting the lowercase-named-Wordfence-tables Duplicator worked as it shoot. How is it possible that those double Wordfence-tables existed??

    https://www.ads-software.com/plugins/wordfence/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author WFMattR

    (@wfmattr)

    Double tables are usually caused by developing on a Windows platform while the live site is on Linux (which supports mixed-case table names, while Windows does not). Windows isn’t officially supported, but a number of users have reported that it works — but when switching between Windows and Linux, the table names become an issue.

    The best option is to remove the Wordfence tables on the development site before copying the live site to it, or before copying the dev site back to the live site.

    You can do that using the option “Delete Wordfence tables and data on deactivation” on the dev site, and then deactivating the plugin, or you can do it manually in your database on the dev site.

    We have a feature request open to see if this can be improved in the future, but I do not know if or when it may be implemented. The reference number for that request is FB1078, and I’ve added this post to it.

    Let me know if this helps, or if you have any other questions!

    -Matt R

    Thread Starter dickprovoost

    (@dickprovoosthotmailcom)

    Hello Matt,

    Thanks for your reply, did not see it 6 months ago and having same sort of problem now. Your reaction is truly helpfull!!

    Thanks.

    Greetings:

    It seems that I am not the only person that has challenges using WF with Duplicator.

    The Duplicator error I receive when scanning to make a package is

    **********

    Overview:
    The thresholds that trigger warnings for individual tables are 10MB OR 100,000 records OR tables names with upper-case characters. The larger the table the more time it takes to process and execute. This can cause issues with budget hosts that have cpu/memory limits, and timeout constraints.

    Options:
    1. Run a Repair and Optimization on the table to improve the overall size and performance.

    2. Remove stale date from tables such as logging, statistical or other non-critical data.

    3. For table name case sensitivity issues either rename the table with lower case characters or be pre-paired to work with the lower_case_table_names system variable setting.

    **********

    I found the following WF tables associated with the error:

    wp_wfBadLeechers
    Case:1
    Rows:0
    Size:16KB
    wp_wfBlockedIPLog
    Case:1
    Rows:0
    Size:16KB
    wp_wfBlocks
    Case:1
    Rows:0
    Size:32KB
    wp_wfBlocksAdv
    Case:1
    Rows:0
    Size:16KB
    wp_wfConfig
    Case:1
    Rows:131
    Size:16KB
    wp_wfCrawlers
    Case:1
    Rows:16
    Size:16KB
    wp_wfFileMods
    Case:1
    Rows:5,332
    Size:1.52MB
    wp_wfHits
    Case:1
    Rows:1,699
    Size:1.22MB
    wp_wfHoover
    Case:1
    Rows:212,051
    Size:39.08MB
    wp_wfIssues
    Case:1
    Rows:0
    Size:16KB
    wp_wfLeechers
    Case:1
    Rows:1,214
    Size:112KB
    wp_wfLockedOut
    Case:1
    Rows:0
    Size:16KB
    wp_wfLocs
    Case:1
    Rows:0
    Size:16KB
    wp_wfLogins
    Case:1
    Rows:31
    Size:48KB
    wp_wfNet404s
    Case:1
    Rows:0
    Size:32KB
    wp_wfReverseCache
    Case:1
    Rows:0
    Size:16KB
    wp_wfScanners
    Case:1
    Rows:0
    Size:16KB
    wp_wfStatus
    Case:1
    Rows:980
    Size:256KB
    wp_wfThrottleLog
    Case:1
    Rows:0
    Size:32KB
    wp_wfVulnScanners
    Case:1
    Rows:0
    Size:16KB

    What suggestions do you have other than removing WF before running Duplicator? Is there a fix coming soon?

    Thanks!
    fred
    https://www.tech-wise.services

    @fprasuhn: This is not your topic. It is also 7 months old & references an old version of WordPress. If you require assistance then, as per the Forum Welcome, please post your own topic.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Double Wordfence tables and Duplicator’ is closed to new replies.