Title: **ERROR** database error write &#039;Duplicate entry &#039;&#039; for key &#039;option_name&#039;&amp;#0
Last modified: August 21, 2016

---

# **ERROR** database error write 'Duplicate entry '' for key 'option_name'&#0

 *  Resolved [neilgee](https://wordpress.org/support/users/neilgee/)
 * (@neilgee)
 * [11 years, 12 months ago](https://wordpress.org/support/topic/error-database-error-write-duplicate-entry-for-key-option_name-sql/)
 * Just to verify I also started getting this error and install failed.
 * Using 0.5.3 does indeed fix the issue
 * [https://wordpress.org/plugins/duplicator/](https://wordpress.org/plugins/duplicator/)

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

 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [11 years, 12 months ago](https://wordpress.org/support/topic/error-database-error-write-duplicate-entry-for-key-option_name-sql/#post-4920770)
 * Hey Neil,
 * Is the table from the options table?
 * Thanks~
 *  Thread Starter [neilgee](https://wordpress.org/support/users/neilgee/)
 * (@neilgee)
 * [11 years, 12 months ago](https://wordpress.org/support/topic/error-database-error-write-duplicate-entry-for-key-option_name-sql/#post-4920804)
 * Hi Cory – yes it was and the error was repeated multiple times
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [11 years, 12 months ago](https://wordpress.org/support/topic/error-database-error-write-duplicate-entry-for-key-option_name-sql/#post-4920819)
 * I have never seen the error to be honest and I’m not sure how that can happen
   unless somehow the database you connected to wasn’t empty. The sql script is 
   a dump of database1.options_table to database2.options_table so something happened
   along the way that generated the same entry in the the database table….
 *  [meamrussian](https://wordpress.org/support/users/meamrussian/)
 * (@meamrussian)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/error-database-error-write-duplicate-entry-for-key-option_name-sql/#post-4920853)
 * Same problem here. Getting hundreds of these in the error log (all exactly the
   same):
 * **ERROR** database error write ‘Duplicate entry ” for key ‘option_name” – [sql
   =INSERT INTO `wp_options` VALUES(“”, “”, “”, “”)…]
 * Fewer of each of these:
    **ERROR** database error write ‘Duplicate entry ‘0-0’
   for key ‘PRIMARY” – [sql=INSERT INTO `wp_term_relationships` VALUES(“”, “”, “”)…]**
   ERROR** database error write ‘Duplicate entry ” for key ‘slug” – [sql=INSERT 
   INTO `wp_terms` VALUES(“”, “”, “”, “”)…] **ERROR** database error write ‘Duplicate
   entry ‘0’ for key ‘PRIMARY” – [sql=INSERT INTO `wp_wppa_photos` VALUES(“”, “”,“”,“”,“”,“”,“”,“”,“”,“”,…]
 * I didn’t have any such problems before WordPress 1.9.1 (maybe even 1.9?) came
   out.
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/error-database-error-write-duplicate-entry-for-key-option_name-sql/#post-4920862)
 * Hey [@meamrussian](https://wordpress.org/support/users/meamrussian/),
 * As Neil mentioned above the latest did fix the problem for him…
 * [@neilgee](https://wordpress.org/support/users/neilgee/), sorry for any confusion…
   I actually miss-read your original post about it working…
 * If you can give the developer version a try it may have your fixes for the issue
   your seeing. The very latest version (0.5.3) can be found by following these 
   instructions:
 *  -> Browse to [http://wordpress.org/extend/plugins/duplicator/developers/](http://wordpress.org/extend/plugins/duplicator/developers/)
   -
   > Look for the section “Other Versions” -> Click on “Development Version” and
   download the zip plugin file -> Uninstall your current version and install this
   one -> Note: This is a development line version so please test in your sandbox
   first to make sure you have no issues…
 * Let me know if this solves your issue…
 * Thanks
 *  [meamrussian](https://wordpress.org/support/users/meamrussian/)
 * (@meamrussian)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/error-database-error-write-duplicate-entry-for-key-option_name-sql/#post-4920865)
 * I also somehow misread the original post about it working, thanks for the response.
   Will try the other version next time.
 * Thanks.
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/error-database-error-write-duplicate-entry-for-key-option_name-sql/#post-4920870)
 * No problem… It should resolve your overall issue…

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

The topic ‘**ERROR** database error write 'Duplicate entry '' for key 'option_name'&#
0’ is closed to new replies.

 * ![](https://ps.w.org/duplicator/assets/icon-256x256.png?rev=2906985)
 * [Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More](https://wordpress.org/plugins/duplicator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/duplicator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/duplicator/)
 * [Active Topics](https://wordpress.org/support/plugin/duplicator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/duplicator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/duplicator/reviews/)

 * 7 replies
 * 3 participants
 * Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * Last activity: [11 years, 11 months ago](https://wordpress.org/support/topic/error-database-error-write-duplicate-entry-for-key-option_name-sql/#post-4920870)
 * Status: resolved