ddhr.org - Comments problem

ddhr.org

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
Linked: WordPress 2.0.2

Comments

#1	Dave	Mar 28, 2006
	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.

#2	Dave	Mar 28, 2006
	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.