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.phpThis 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.phpAnyone 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.