Support » Fixing WordPress » database error Duplicate entry ‘0’ for key 1 for query INSERT INTO wp_posts

  • This error is created in my logs everytime time I try and post or create a page.

    MY host says it’s missing the auto_increment table, where is this located in the database ?

    Full error below:

    [Thu Apr 17 21:24:42 2008] [error] [client 89.137.123.138] WordPress database error Duplicate entry ‘0’ for key 1 for query INSERT INTO wp_posts (post_author,post_date,post_date_gmt,post_content,post_content_filtered,post_title,post_excerpt,post_status,post_type,comment_status,ping_status,post_password,to_ping,pinged,post_modified,post_modified_gmt,post_parent,menu_order,guid,post_mime_type) VALUES (‘1′,’0000-00-00 00:00:00′,’0000-00-00 00:00:00′,”,”,’Testing’,’undefined’,’draft’,’page’,’open’,’open’,”,”,”,’2008-04-17 21:24:42′,’2008-04-17 20:24:42′,’0′,’0′,”,”) made by wp_insert_post, referer: http://www.gatwick-villa.com/wp-admin/page-new.php
    [Thu Apr 17 21:24:46 2008] [error] [client 89.137.123.138] WordPress database error Duplicate entry ‘0’ for key 1 for query INSERT INTO wp_posts (post_author,post_date,post_date_gmt,post_content,post_content_filtered,post_title,post_excerpt,post_status,post_type,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_parent,menu_order,guid,post_mime_type) VALUES (‘1′,’0000-00-00 00:00:00′,’0000-00-00 00:00:00′,’123′,”,’Testing’,”,’draft’,’page’,’open’,’open’,”,”,”,”,’2008-04-17 21:24:46′,’2008-04-17 20:24:46′,’0′,’0′,”,”) made by wp_insert_post, referer: http://www.gatwick-villa.com/wp-admin/page-new.php

    This is when i try to post a page.

    This is when i try to write a post:

    [Thu Apr 17 21:21:41 2008] [error] [client 89.137.123.138] WordPress database error Duplicate entry ‘0’ for key 1 for query INSERT INTO wp_posts (post_author,post_date,post_date_gmt,post_content,post_content_filtered,post_title,post_excerpt,post_status,post_type,comment_status,ping_status,post_password,to_ping,pinged,post_modified,post_modified_gmt,post_parent,menu_order,guid,post_mime_type) VALUES (‘1′,’0000-00-00 00:00:00′,’0000-00-00 00:00:00′,”,”,’testing’,’undefined’,’draft’,’post’,’closed’,’closed’,”,”,”,’2008-04-17 21:21:41′,’2008-04-17 20:21:41′,’0′,’0′,”,”) made by wp_insert_post, referer: http://www.gatwick-villa.com/wp-admin/post-new.php
    [Thu Apr 17 21:21:52 2008] [error] [client 89.137.123.138] WordPress database error Duplicate entry ‘0’ for key 1 for query INSERT INTO wp_posts (post_author,post_date,post_date_gmt,post_content,post_content_filtered,post_title,post_excerpt,post_status,post_type,comment_status,ping_status,post_password,to_ping,pinged,post_modified,post_modified_gmt,post_parent,menu_order,guid,post_mime_type) VALUES (‘1′,’0000-00-00 00:00:00′,’0000-00-00 00:00:00′,’123′,”,’testing’,”,’draft’,’post’,’closed’,’closed’,”,”,”,’2008-04-17 21:21:52′,’2008-04-17 20:21:52′,’0′,’0′,”,”) made by wp_insert_post, referer: http://www.gatwick-villa.com/wp-admin/post-new.php

    Anyone have any ideas? it was working fine then all of a sudden. bang !

  • The topic ‘database error Duplicate entry ‘0’ for key 1 for query INSERT INTO wp_posts’ is closed to new replies.