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