Forums

#1062 - Duplicate entry '5' for key 1 - restore blog database (1 post)

  1. VivBounty
    Member
    Posted 2 years ago #

    Hello,
    For 4 days now I have been trying to restore my blog database using my PHP. I keep getting the same error message and cannot seem to get around it.

    It appears to be a comments key problem, but I have no idea how to fix it. I've tried asking in forums but don't understand mySQL so I wonder if anyone has a short easy English explanation to fix this problem please?

    SQL query:

    -- -- Dumping data for table wp_comments -- INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES (5, 1, 'VivBounty', 'vivbounty@gmail.com', '', '156.34.41.87', '2009-11-18 13:49:17', '2009-11-18 17:49:17', 'Jim Stone, I thank you for being my first commentator on my new pet blog. So glad you like it. I am very happy with it too.\r\n\r\nThank you Crystal Spring for your comment and for keeping up with my blog. I hope you find the products as effective as I do!\r\n\r\nTrudyVan thank you for your comment. I do know that you love your pets. That is why I just had to put your parrot blog on my blogroll.', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/3.0.195.33 Safari/532.0', '', 0,[...]

    MySQL said: Documentation
    #1062 - Duplicate entry '5' for key 1

Topic Closed

This topic has been closed to new replies.

About this Topic