Title: WordFence database problems.
Last modified: August 21, 2016

---

# WordFence database problems.

 *  [Andre van Rooyen](https://wordpress.org/support/users/andrevr/)
 * (@andrevr)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/wordfence-database-problems/)
 * I’m having some issues with one of the (many) Wordfence installs I admin.
    (Related:
   Props for an OUTSTANDING tool. Really, thank you)
 * It’s a recent addition to this particular site, and install went (seemed to, 
   anyway) without errors, but immediately after the first scan, I received this
   message:
    _DataTables warning (table id = ‘wfissuesTable\_new’): Added data (
   size undefined) does not match known number of columns (2)_ The mail fired off
   just fine. Examining the table showed no data, despite 47 problems reported (
   mostly weak user passwords) Long story short, uninstalled plugin, dropped tables,
   installed fresh copy of plugin, setup options, saved (NB, in that it went well),
   ran scan. Same error. (DataTable warning) On examination table has data (44, 
   I fixed some issues after run 1)
 * Left it to run, while I think about what’s going on. Had a lot of (all) mail-
   me-when options ticked. This morning went to uncheck some, and notice that the
   save options spinner does not end. After a couple of minutes, refreshed page 
   to find changes not saved. Clearly other tables are damaged and the “save options”
   operation is not as well error-trapped as it could be 🙂
 * So, the question: Are there known instances of a pre-existing malware infection
   protecting itself against a new Wordfence install? Mashing the tables seems like
   a likely target for such a defence effort, yes? Not too stealthy, but…
 * Or am I just dealing with a set of data that may have been “stepped on” once 
   too many on the past? Solution: Create new duplicate database, import data (risking
   importing the breaks) and switch the install over?
 * Any suggestions welcome. Ta.
 * [https://wordpress.org/plugins/wordfence/](https://wordpress.org/plugins/wordfence/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Mark Maunder](https://wordpress.org/support/users/mmaunder/)
 * (@mmaunder)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/wordfence-database-problems/#post-4717835)
 * Hi,
 * No, I dont think this is related to an infection. The error:
 * “DataTables warning (table id…”
 * is interesting. You’re using some sort of DataTables database plugin? Looks like
   that is what is throwing that error, it’s not WordPress or Wordfence or PHP or
   MySQL. But that is maybe just a symptom of table corruption.
 * I’d start by running a full check table on all tables in your WP database using
   some sort of MySQL client.
 * Regards,
 * Mark.

Viewing 1 replies (of 1 total)

The topic ‘WordFence database problems.’ is closed to new replies.

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)

 * 1 reply
 * 2 participants
 * Last reply from: [Mark Maunder](https://wordpress.org/support/users/mmaunder/)
 * Last activity: [12 years, 2 months ago](https://wordpress.org/support/topic/wordfence-database-problems/#post-4717835)
 * Status: not resolved