Subject: Mysql 3.23 autoindex and upgrading to 1.2.2 from 1.1

Posted on: 23/10/01 05:07am
By: Anonymous

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

Opps

Posted on: 06/11/01 10:12am
By: Jason

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.

Opps

Posted on: 06/11/01 10:52am
By: Tony

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.

Opps

Posted on: 03/02/02 11:45am
By: Anonymous

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

Opps

Posted on: 04/02/02 05:48pm
By: Tony

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.

Opps

Posted on: 02/03/02 03:00am
By: Anonymous

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

Geeklog - Forum
https://www.geeklog.net/forum/viewtopic.php?showtopic=9802