Duplicate Entry plugin (2 posts)

  1. duncan
    Posted 9 years ago #

    I've dug around the fourms but can't find an answer.

    I've recently moved a number of WP blogs from one host to a new host, and on the WP2.0 installs I'm getting this error when going to post:

    WordPress database error: [Duplicate entry '0' for key 1]
    INSERT INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_mime_type) VALUES ('1',]

    and it continues after this. Odd thing is though, it's only the WP 2.0 blogs, not the WP 1.5 blogs???

    any ideas. I've checked .htaccess, it's writable and the permalinks structure is setup to include the date etc to avoid duplicates.

  2. ledermann
    Posted 9 years ago #

    Check (all) the tables in MySQL. I bet the "auto_increment" setting is lost.

Topic Closed

This topic has been closed to new replies.

About this Topic