Welcome to Geeklog, Anonymous Friday, July 11 2025 @ 04:52 pm EDT

Geeklog Forums

Mysql 3.23 autoindex and upgrading to 1.2.2 from 1.1


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
 Quote

Status: offline
Forum User
Newbie
Registered: 12/17/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.
 Quote

Status: offline
Site Admin
Admin
Registered: 12/17/01
Posts: 405
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.
 Quote

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
 Quote

Status: offline
Site Admin
Admin
Registered: 12/17/01
Posts: 405
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.
 Quote

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

All times are EDT. The time is now 04:52 pm.

  • 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