Larger ID numbers for posts

  • Resolved Lee Wallis

    (@fatwombat)


    9 years, 8 months ago

    Hi there,

    I am creating a directory listing site, and rather than have listing ID’s of 3, 40, 80, 123, 788 etc… I wanted a large number that will be a consistent size, e.g. 808811434.

    I tried changing the auto increment in the wp_posts table but that seem to cause issues when trying to add pages/posts etc… saying it was editing some post or something. It was doing weird things like when clicking save redirecting to the posts admin page rather than back to the pages admin page.

    Anyone ever done this or recommend how to do this?

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Lee Wallis

    (@fatwombat)

    FYI anyone that does look at this, I have run an auto increment adjustment over the posts table.

    ALTER TABLE wp_users AUTO_INCREMENT=808811434

    And then I get this message on posts and pages and it won’t let me create new ones.

    You are currently editing the page that shows your latest posts.

    Thread Starter Lee Wallis

    (@fatwombat)

    OK wow. Worked it out myself.

    It appears WP does not like MySQL using numbers of such a large length. Even though the DB schema is setup as BIGINT(20) it cannot take a number 10 digits long.

    Am I missing something here? I thought it would take a 10 digit number?

    Close this if needed.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Larger ID numbers for posts’ is closed to new replies.