ddhr.org | 2006 | 03 | 28 about | archives | comments | rss

Comments problem (2) Tue, 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

Dave Tue, 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.

Dave Tue, 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.

← older post 586 of 3123 newer →