Geeklog Forums

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.

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.

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.

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