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,