gatwick-villa

I have been onto my VSP provider and this is what he has come up with:

Hello,

This entry if from your error log located at Plesk > domain.com > Log Manager > error_log

[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

So it seems the problem is the auto_increment field missing from the DB.

Best Regards,