hey everybody, here's what i'm trying to do:

i had a pre-launch blog going on to be able to test templates, formats, etc. i deleted that one, deleting its entries and archives first, and started a brand new and possibly final blog.

however the entries kept counting on. the first entry on the new blog was generated as 000013.html, not 00001.html as i would've thought.

so ok, i went ahead and deleted all the files manually from the server thru ftp (all entry files such as 00001.html and so on and the date-based archives like 2003_07.html).

that didn't work either. after rebuilds, logins and logouts, etc., it continues to behave the same way. my last resort was gonna be to trash the mysql database, which in my mind is the only thing that could have any information on those entries, right?

how do i reset this thing! =) any clues anyone?

reference link: http://www.silvasonic.com/index_temp.html

As far as I know, there is no way to reset the entry count unless you do a new install. I'm not sure about the MySQL version though..possibly clearing the database will work too?

And keep in mind that if you eventually have more than 1 blog on the same installation of MT, they share entry IDs. So in the end, even if you start at 000001.html, things might get all mixed up again.

You might use phpMyAdmin to poke around in the mt_entry record, particularly the id field, see if you can reset it there. I've never looked into this, so I don't really know what you'll discover.

If you go to the mt_entry table in phpMyAdmin and then click on the red "Empty" link, it's going to delete all records and reset the next ID to 1.

BTW, you only want to do this if the table is already empty - i.e. you first deleted all the entries using the MovableType interface. Otherwise you might get stuck with orphaned records (in mt_placement, mt_comment, etc.).

hey guys thanks for helping me out with the "reset sql" question. i gave that i try, but i poked some much all over all the fields that nothing worked after all =) i couldn't even log back into MT after my little clumsy attempt. i ended up rebuilding the blog from scratch and being a little more secure about the final result. the site is up and running right now. check it out at: http://www.silvasonic.com

I had the same prob and I poked around mt_entry (not w/o having a backup ready ;-).

Here is my working solution:

Go into phpMyAdmin, choose mt-entry at the left and look for "Options" (3rd from right). There is a field with "auto_increment" behind. Simply set this to whatever number you like and press OK. Now all entry starting with the number you put in.

I deleted ALL archived files not even through MT but from the server directly BEFORE. Otherwise it will count these files and set the number to this sum.

In the same way, you can change the trackback etc etc.

Backing up before poking is always best.