Title: Duplicate column name 'permanent'
Last modified: August 30, 2016

---

# Duplicate column name 'permanent'

 *  Resolved [SoN9ne](https://wordpress.org/support/users/son9ne/)
 * (@son9ne)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/duplicate-column-name-permanent/)
 * I just updated WordFence (from version 5.3.11) and I am now getting a lot of 
   MySQL errors:
 * `Duplicate column name 'permanent'`
 * Hope this helps
 * [https://wordpress.org/plugins/wordfence/](https://wordpress.org/plugins/wordfence/)

Viewing 4 replies - 1 through 4 (of 4 total)

 *  [WFBrian](https://wordpress.org/support/users/wfbrian/)
 * (@wfbrian)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/duplicate-column-name-permanent/#post-6245670)
 * Hi,
 * If you have access and are familiar with the process you can try running a repair
   on your MySQL database. If not, check with your hosting provider and they should
   be able to run the repair tool on your tables.
 * -Brian
 *  Thread Starter [SoN9ne](https://wordpress.org/support/users/son9ne/)
 * (@son9ne)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/duplicate-column-name-permanent/#post-6245714)
 * Thanks for your suggestion. I tried to repair the table and I get the message:
 * `The storage engine for the table doesn't support repair.`
 * The table structure is:
 *     ```
       CREATE TABLE IF NOT EXISTS wp_wfBlocks (
         IP binary(16) NOT NULL DEFAULT '',
         blockedTime bigint(20) NOT NULL,
         reason varchar(255) NOT NULL,
         lastAttempt int(10) unsigned DEFAULT '0',
         blockedHits int(10) unsigned DEFAULT '0',
         wfsn tinyint(3) unsigned DEFAULT '0',
         permanent tinyint(3) unsigned DEFAULT '0',
         PRIMARY KEY (IP),
         KEY k1 (wfsn)
       ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
       ```
   
 * Further investigation shows that the error is getting triggered at wordfenceClass.
   php line 333 in the runInstall method.
 * `$db->queryWriteIgnoreError("alter table $prefix"."wfBlocks add column permanent
   tinyint UNSIGNED default 0");`
 * I also notices a few tables in wordfence that are using `latin1_swedish_ci` instead
   of `utf8_general_ci`. Is that by design?
 * These tables are:
    - `wp_wfBadLeechers`
    - `wp_wfCrawlers`
    - `wp_wfHits`
    - `wp_wfLeechers`
    - `wp_wfReverseCache`
    - `wp_wfScanners`
 * I’m going to try removing the plugin and re-installing it. Hopefully this will
   solve the issue.
 *  Thread Starter [SoN9ne](https://wordpress.org/support/users/son9ne/)
 * (@son9ne)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/duplicate-column-name-permanent/#post-6245715)
 * Found the issue! Luckily, there’s nothing wrong with WordFence. The issue was
   due to caching. I purged my caches and now I get no errors… I swear, sometimes
   cache is more of a problem than a solution.
 * Still interested in the tables charset.
 *  [WFSupport](https://wordpress.org/support/users/wfsupport/)
 * (@wfsupport)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/duplicate-column-name-permanent/#post-6245818)
 * The charset is not important, according to what I know.
 * tim

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Duplicate column name 'permanent'’ 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

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * 4 replies
 * 3 participants
 * Last reply from: [WFSupport](https://wordpress.org/support/users/wfsupport/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/duplicate-column-name-permanent/#post-6245818)
 * Status: resolved