ID count problem

  • huphtur

    (@huphtur)


    17 years, 11 months 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?

Viewing 1 replies (of 1 total)
  • irakrakow

    (@irakrakow)

    17 years, 11 months 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.

Viewing 1 replies (of 1 total)
  • The topic ‘ID count problem’ is closed to new replies.

Tags