Posted on: 10/23/01 05:07am
By: Anonymous (gnuyen)
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: 11/06/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: 11/06/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: 02/03/02 11:45am
By: Anonymous (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: 02/04/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: 03/02/02 03:00am
By: Anonymous (Anonymous)
ALTER TABLE \'tbl_name\' AUTO_INCREMENT = 1 will set the autoincrement number to the current maximum of the table.