The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

Resetting post ID number (3 posts)

  1. kaa
    Posted 11 years ago #

    Not a major problem, more of a mild annoyance.

    Basocally I've been putting up a few test posts on the site while designing the layout and all that. I've now deleted these test posts and am ready to start posting properly, but the post ID number is now 14 because of all the test posts I made before.

    Is there any way to reset this number back to 1 again? Or should I just leave it?

  2. Kafkaesqui

    Posted 11 years ago #

    In most cases it's smarter to leave it, but if it's bugging you, you can change them through the database by manually editing the ID for records in the posts table.

    To reset where ID-ing starts from you'll have to change your posts table's auto-increment value. The SQL query for that is:


    The X should be the value for the next available ID. Edit the posts table prefix if not using the default.

    Note: Always back up (export) your database before making changes to it.

  3. kaa
    Posted 11 years ago #

    Ah right, I guess I'll leave it then :P

    Thanks for the help!

Topic Closed

This topic has been closed to new replies.

About this Topic