Title: WordPress Database Error: Duplicate Entry IP?
Last modified: September 21, 2018

---

# WordPress Database Error: Duplicate Entry IP?

 *  Resolved [MTUser2012](https://wordpress.org/support/users/mtuser2012/)
 * (@mtuser2012)
 * [7 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-ip/)
 * When I click through all the menu items in the plugin, I see the following error
   at the top of each page:
 * WordPress database error: [Duplicate key name ‘ip’]
    ALTER TABLE `mkv13_redirection_404`
   ADD INDEX `ip` (`ip`)
 * I tried searching and cannot find any info on this error or fix.

Viewing 1 replies (of 1 total)

 *  Plugin Author [John Godley](https://wordpress.org/support/users/johnny5/)
 * (@johnny5)
 * [7 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-ip/#post-10713399)
 * It seems you’ve got the plugin in a strange state. Probably the easiest way to
   recover is to export all your redirects as JSON, press the ‘delete plugin’ on
   the plugin options page, and then re-activate it. This will clear all your Redirection
   database tables and you can then re-import your redirects and start over again.

Viewing 1 replies (of 1 total)

The topic ‘WordPress Database Error: Duplicate Entry IP?’ is closed to new replies.

 * ![](https://ps.w.org/redirection/assets/icon-256x256.jpg?rev=983639)
 * [Redirection](https://wordpress.org/plugins/redirection/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/redirection/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/redirection/)
 * [Active Topics](https://wordpress.org/support/plugin/redirection/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/redirection/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/redirection/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [John Godley](https://wordpress.org/support/users/johnny5/)
 * Last activity: [7 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-ip/#post-10713399)
 * Status: resolved