Subject: Mysql 3.23 autoindex and upgrading to 1.2.2 from 1.1
Posted on: 23/10/01 05:07am
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?
Posted on: 06/11/01 10:12am
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.
Posted on: 06/11/01 10:52am
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.
Posted on: 03/02/02 11:45am
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....
Posted on: 04/02/02 05:48pm
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.
Posted on: 02/03/02 03:00am
ALTER TABLE \'tbl_name\' AUTO_INCREMENT = 1 will set the autoincrement number to the current maximum of the table.
Geeklog - Forum