Comments problem (2)
|
Mar 28, 2006
|
I've having some problems with the commenting functionality on my site. I'm getting an error that says, "WordPress database error: [Duplicate entry '0' for key 1]". I'm not sure what it means or how to fix it, so I'm looking into things. #technology
|
Comments:
2006-03-28 12:16:54
Ok it's fixed. The problem was that a comment got entered and was assigned a commend_ID of 0, though I'm not sure how it happened. I changed the value to 1 because the smallest value currently being used was 2. I have no idea how or why this happened, but everything should work now.
2006-03-28 12:19:51
More details on the problem: The database structure of comment_ID said that there was a default value of 0, so I changed that to have no default value and made sure "Extra" said "auto_increment". I'm still not sure how this happened, but apparently something corrupted my database. It was probably a plugin.
|