WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Error with restored database (3 posts)

  1. igorx81
    Member
    Posted 7 years ago #

    I tried to make the update to 2.0.6, but I wasn't able to complete it (I will try again later), so I deleted all files in the directory and restored all original files and database.

    Now, after first visit, slimstat is no more able to count them, and I'm able to post only one comment; with the second I get:

    WordPress database error: [Duplicate entry '0' for key 1]

    ....

    Warning: Cannot modify header information - headers already sent by (output started at
    ..../wp-includes/wp-db.php:102)
    in ..../wp-includes/pluggable-functions.php on line 290

    For what I understood, first comment get ID 0 instead of "343" and second one gets again 0 as ID, and there will be this problem with articles too I suppose.

    Following instructions, I didn't deactivate plugins before backing up, so I find them active when I first access the admin panel.
    I used the hosting function to backup and then restore database. What can be the error?

    Thanks a lot

  2. MichaelH
    Member
    Posted 7 years ago #

    So if you have a good backup, then DROP the database tables and restore the database.

    Delete the wordpress files and reupload the WordPress files.

  3. igorx81
    Member
    Posted 7 years ago #

    The backup wasn't good. :-)
    All ID key was missing the AUTO INCREMENT value. I added it and now everything is working.

Topic Closed

This topic has been closed to new replies.

About this Topic