UserId Maxed out

Hangin' Around Joined: Feb 05, 2006 Posts: 29

I tried signing upa dummy account and was able todo w/oo any issues. So, I tried another dummy account and I am still in the "Waiting Users" section after trying to activate. What I found out when I went into my MySQL, is that the first dummy account's UserId seems to be maxed out at 2,147,483,647 which tell me the UserId is maxed out, therefore, no more account will be created. Correct? Now, I only have just over 550 members currently. How can I change this setting in my MySQL settings to incremate from the last user?

Thanks.

Kilch

registered · Posted: Fri Mar 10, 2006 12:07 pm

You'll need to use phpMyAdmin to change the auto_increment number on the users table

Posted: Fri Mar 10, 2006 12:32 pm

Yea, I was looking at that, but what do I change it to. As of right now, it looks like this:

Thanks evaders99 , someday I'll get the hang of this. LOL Smile

Posted: Fri Mar 10, 2006 12:55 pm

Check under Operations

Posted: Fri Mar 10, 2006 1:05 pm

evaders99 wrote:

Check under Operations

OK, I am asuming that I do not do anything in A1. Now, in the A2 section, do make that blank? Or, do I put the next incremented number? Se pic

Kilch

Posted: Fri Mar 10, 2006 1:17 pm

Kilch wrote:

evaders99 wrote:

Check under Operations

OK, I am asuming that I do not do anything in A1. Now, in the A2 section, do make that blank? Or, do I put the next incremented number? Se pic

Kilch

Ok, I think I have it. According to the SQL file, I should be auto_incrementing at a rate of 4. Is the correct? I have made the change and I think I'll go with it unless I hear different from you.

You're the best and I like the way you do not come out and tell what needs to be done. You make me think about it. I like that as it makes me learn.

Have a great weekend.

Thanks,

Kilch

Posted: Fri Mar 10, 2006 1:20 pm

Well, I made the change, but it will not take. It keeps showing up as "2147483647". Now I am getting annoyed.

Posted: Fri Mar 10, 2006 1:36 pm

ha, I just removed the nuke_users table and re-installed with the "4" after the auto_increment (like in the sql), and it still will not change. Where else is this not allowing the change?

Do I need to empty the nuke_users_temp table first?????

Posted: Fri Mar 10, 2006 10:49 pm

Check and make sure the anonyous user_id is 1, not -1

Posted: Sat Mar 11, 2006 6:27 am

evaders99 wrote:

Check and make sure the anonyous user_id is 1, not -1

thanks, that was it. I just tried out 3 new accounts and works flawlessly.

Thanks again and have a great weekend.

Kilch