Someone fixed this for me by repairing wp_post2cat table
after changing hosts, and upgrading wordpress to 2.2.1, i get the following error any time i edit a post:
WordPress database error: [Duplicate entry ‘0’ for key 1]
INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (’23’,’_pingme’,’1′)
WordPress database error: [Duplicate entry ‘0’ for key 1]
INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (’23’,’_encloseme’,’1′)
Warning: Cannot modify header information – headers already sent by (output started at /home/blgzorgb/public_html/robotesq/wp-includes/wp-db.php:133) in /home/blgzorgb/public_html/robotesq/wp-includes/pluggable.php on line 331
please help!
I have the same error, anyone know how to fix this?
———–
WordPress database error: [Duplicate entry ‘0’ for key 1]
INSERT INTO wp_post2cat (post_id, category_id) VALUES (’68’, ‘1’)
WordPress database error: [Duplicate entry ‘0’ for key 1]
INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (’68’,’_wp_page_template’,’default’)
Warning: Cannot modify header information – headers already sent by (output started at /home/lemonlan/public_html/wp-includes/wp-db.php:133) in /home/lemonlan/public_html/wp-includes/pluggable.php on line 331
———–
I’ve done this:
http://wordpress.org/support/topic/107994?replies=12
and this:
http://wordpress.org/support/topic/129725?replies=23
and deactivated all of my plugins.
This problem showed up after I moved to a new server.
url: lemonland.org
With a WordPress 2.1.2 , an user tried to upload a file.doc and then it appeared the same error message (duplicate entry 2500).
I have explored the last register in “wp_comments” table, ans I’ve seen in the “comment_ID” field a “2499” value.
Then I edited that value to set it a “2501” value.
People can now add comments again without problem.