Duplicator and Wordfence

I’ve got this issue too. I’m excluding the wordfence tables for now. Still get a 404 error after some time though. Relying on updraft for now.

Hi fprasuhn,

This appears to be an error within the Duplicator plugin. Have you tried posting on their forum?

“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.”

The Wordfence database table names do have capital letters. I am not sure why Duplicator would have a problem with this naming convention but that seems to be the issue here.

Please post on the Duplicator forum and ask if there is an option or setting to resolve this.

This is NOT “an error within the Duplicator plugin”.

This is a WARNING from Duplicator of a dangerous practice by WordFence that MAY cause trouble if moving between systems that have different settings or file systems. It has caused duplicate tables many times.

https://www.ads-software.com/support/topic/double-wordfence-tables-and-duplicator?replies=5

It is always best practice to create table names in lower case.

Duplicator is 100% right to warn people of things that may cause trouble during a deployment or migration. Kudos to Duplicator for the warning.

FOrtunately WF people are considering correcting this problem.

Hi Sonja,

Thanks for the link. That is a great explanation from Matt. In summary, database case sensitivity is based on the underlying file system.

I have transferred many WordPress sites with Wordfence installed and never had a problem with the camelCase naming convention on database tables. With that said, I rarely deal with WordPress on Windows. We currently do not support Windows and Windows seems to be related to the majority of the duplicate table issues reported to us. It is possible to have this problem on a non-Windows server, but chances are much lower.

I appreciate you mentioning this message being a warning. The OP stated it as an error, did not mention duplicate tables, or link to the similar thread where he had previously posted.

@fprasuhn please try to be more specific in your post next time around. ??

I did verify that table renaming is in the queue. You will more than likely be seeing this change in the future.

Very glad to hear that it is in the queue.

We have been big fans of yours until we discovered this and honestly had begun looking at the competition.

Any idea how soon we may see it?

I know a number of people that have been hit with duplicate tables. Some members of our team develop on windows, some macs.

We have also discovered incoming clients who had duplicate table and did not know it. I suspect there are many people who do not know that they have duplicates. Unless one looks at the database or runs a newer version of Duplicator, it would not be obvious.

Also, for the record, it can be either the OS and/or the “lower_case_table_names” setting. Some hosts set this and/or do not give access to this and other database settings on more “economical” hosting plans.

Also might be a good idea to suggest workarounds until a fix is out.

For now, we are telling our team to just delete WordFence before migration and reinstall after.

In case it helps, I’ve seen the issue twice, on Linux platforms with a respected host both times. It may be a coincidence, but on the other hand the issue may not be primarily Windows, as you think.

I never had any issue with moving sites using Duplicator. Yesterday I moved my first site with wordfence residue in the database….its a complete nightmare.

These lines dont even make sense, even worse; they dont correctly end using the “, throwing all kinds of unexpected errors during the proces….

/* INSERT TABLE DATA: wp_wffilemods */
INSERT INTO wp_wffilemods VALUES(“???%
?X?;?j?, “MyFontsWebfontsKit.css”, “0”, “S???????s??, “S???????s??);
INSERT INTO wp_wffilemods VALUES(“???.?Loe??f???”, “googlea911729d5a0ecf47f.html”, “0”, “??P??j?0?j3?”, “??P??j?0?j3?”);
INSERT INTO wp_wffilemods VALUES(“????Z??8?(3”, “iirf.ini”, “0”, “Nu??????Q4?”, “Nu??????Q4?”);
INSERT INTO wp_wffilemods VALUES(“??\0???+OW+?”, “index.php”, “1”, “\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0”, “?%0;?s??Dm\\?:[“);
INSERT INTO wp_wffilemods VALUES(“????/?9}?`:w?”, “license.txt”, “1”, “\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0”, “??e?1???x????”);
INSERT INTO wp_wffilemods VALUES(“m?2+F?m?vb??U?”, “readme.dd2deae2dba06c02079a25590escdfc31.html”, “0”, “?0?\Z?s^-8??”, “?0?\Z?s^-8??”);
INSERT INTO wp_wffilemods VALUES(“?? =?????J”, “web.config”, “0”, “???1z?Tl???l”, “???1z?Tl???l”);
INSERT INTO wp_wffilemods VALUES(“b7??4???o??, “webfonts/.DS_Store”, “0”, “Ew?????q?P,L”, “Ew?????q?P,L”);
INSERT INTO wp_wffilemods VALUES(“y???A#???”, “webfonts/2FB2BD_0_0.eot”, “0”, “?VZT??\’????6 “, “?VZT??\’????6 “);
INSERT INTO wp_wffilemods VALUES(“Y??nT5???n?, “webfonts/2FB2BD_0_0.ttf”, “0”, “?hpo?5? ???$”, “?hpo?5? ???$”);

Hope I save someone a lot of time, just remove anything that starts with wp_wfXXXX when your install keeps failing!

• This reply was modified 8 years, 2 months ago by Ramzii.
• This reply was modified 8 years, 2 months ago by Ramzii.
• This reply was modified 8 years, 2 months ago by Ramzii.

I did verify that table renaming is in the queue. You will more than likely be seeing this change in the future.

8 months in the que.. are you for real wflandon

Being a security plugin this does not talk very good about you regardless of how much i appreciate your work and your plugin, this is insanely crazy it is taking you longer than 8 months to launch this silly small fix on your table names.

11 Months and still the same problem is coming up.

What a piece of crap!