Viewing 7 replies - 1 through 7 (of 7 total)
  • Hey Neil,

    Is the table from the options table?

    Thanks~

    Thread Starter neilgee

    (@neilgee)

    Hi Cory – yes it was and the error was repeated multiple times

    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….

    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.

    Hey @meamrussian,

    As Neil mentioned above the latest did fix the problem for him…

    @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/
    -> 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

    I also somehow misread the original post about it working, thanks for the response. Will try the other version next time.

    Thanks.

    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.