Welcome to Geeklog Monday, October 14 2019 @ 02:52 am EDT

Geeklog Forums

Mysql 3.23 autoindex and upgrading to 1.2.2 from 1.1


gnuyen

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

Status: offline

Jason

Forum User
Newbie
Registered: 17/12/01
Posts: 14
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!

Status: offline

Tony

Site Admin
Admin
Registered: 17/12/01
Posts: 405
Location:Urbandale, Iowa
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.

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

Status: offline

Tony

Site Admin
Admin
Registered: 17/12/01
Posts: 405
Location:Urbandale, Iowa
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.

Anonymous

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

All times are EDT. The time is now 02:52 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content