Hi. I've recently upgraded to geeklog 1.2.5-1 but unfortunately, I cannot seem to get user additions working properly. I ran 1.1 with 3.23 and that screwed up the users stuff royally. Now that i've upgraded and ran the anonymous_fix_thinggy.php and deleted records w/ uid 8388607, it still tries to make users starting at 8388607. How can I reset the auto_increment fields to start at a sane number?

Thanks

Well the best way is do a dump of the user table. Drop the table and rereate it (this will reset the autoindex) and import the data back.

---

You are all a bunch of freaks!

Jason's right...every so often I've had this happen and it's a pain in the a$$ once it starts. recreate the table and life will be good.

---

The reason people blame things on previous generations is that there's only one other choice.

i am having the same problem with www.Jiggin.net

I get a error each time a new user is trying to create an account. I tried dumping database and recreating tables...but no luck.....

any other suggestions....

Matt

Have any of you ran the anonymous user fix in CVS? I believe it's in the 1.2 tree. That will help. However, you *may* need to drop and recreate the table after you run the script.

-----
The reason people blame things on previous generations is that there's only one other choice.

---

The reason people blame things on previous generations is that there's only one other choice.

ALTER TABLE \'tbl_name\' AUTO_INCREMENT = 1 will set the autoincrement number to the current maximum of the table.