Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
Kilch
Hangin' Around


Joined: Feb 05, 2006
Posts: 29

PostPosted: Fri Mar 10, 2006 10:40 am Reply with quote

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
 
View user's profile Send private message
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Fri Mar 10, 2006 12:07 pm Reply with quote

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

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Kilch
PostPosted: Fri Mar 10, 2006 12:32 pm Reply with quote

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

Image
 
evaders99
PostPosted: Fri Mar 10, 2006 12:55 pm Reply with quote

Check under Operations
 
Kilch
PostPosted: Fri Mar 10, 2006 1:05 pm Reply with quote

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

Image

Kilch
 
Kilch
PostPosted: Fri Mar 10, 2006 1:17 pm Reply with quote

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
 
Kilch
PostPosted: Fri Mar 10, 2006 1:20 pm Reply with quote

Well, I made the change, but it will not take. It keeps showing up as "2147483647". Now I am getting annoyed.
 
Kilch
PostPosted: Fri Mar 10, 2006 1:36 pm Reply with quote

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?????
 
evaders99
PostPosted: Fri Mar 10, 2006 10:49 pm Reply with quote

Check and make sure the anonyous user_id is 1, not -1
 
Kilch
PostPosted: Sat Mar 11, 2006 6:27 am Reply with quote

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
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©