WordPress.org

Ready to get started?Download WordPress

Forums

ID count problem (2 posts)

  1. huphtur
    Member
    Posted 8 years ago #

    I recently switched hosting and moved wp database via a mysql export (had to export using an old version since it gave me incompatibility errors). Once moved, I upgraded WP to latest build 2.0.2.

    Now when I create a new post, the ID of the post is set to 0, instead of the next sequential number (in my case: 278). This gives all kinds of mysql errors when I do a draft post. Any idea how I can fix this?

  2. irakrakow
    Member
    Posted 8 years ago #

    You need to set the auto_increment value to 278 in wp_posts (assuming your database has the default prefix wp_. If not use the prefix for your blog.

    The following SQL will set your auto_increment to 278:

    SQL>ALTER TABLE wp_posts AUTO_INCREMENT = 278

    See auto_increment documentation for more information.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags