Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Post Installation Help
Author Message
eak
New Member
New Member



Joined: Nov 11, 2004
Posts: 16

PostPosted: Sun May 01, 2005 12:03 am Reply with quote

OK, heres the problem. I have about 100 users on my site. FOr some reason, for the last 4 new users, when they register, their unique userid that is assigned to them is:
2147483647

THey get the post registration email and they can follow it, authenticate and connect. But from that point forward, every new user who attempts to register passes through the registration process, gets an email with a valid link but they cannot activate their account and they no longer exist in either nuke_users or nuke_users_temp. If I manually edit that last users userid and make it the next correct user# in order (105 for example) then again a nother new user can resgiter.

Where is thelast current userid stored and looked for so that when the next user wants to register they can get a next properly increemnted number?

Thanks!

E.

Quote:


Go into phpMyAdmin
Select the nuke_users table
Browse it
Find the SQL command box near the bottom of the form
remove anything that is already in the box
paste in these two lines
change the "40" to what you want your next userid to be.

ALTER TABLE nuke_users AUTO_INCREMENT = 40;
ALTER TABLE nuke_users_temp AUTO_INCREMENT = 40;

Click GO.

Rest mine like a champ.

_________________
EAK specs (OS / Apache / MySQL / PHP / PHPNuke)
FedoraCore2 2.6.5-1.358smp/httpd-2.0.50-2.1/mysql-3.23.58-9/PHP 4.3.8/PHPNuke7.5

Last edited by eak on Sun May 01, 2005 12:44 am; edited 1 time in total 
View user's profile Send private message Send e-mail Visit poster's website
eak







PostPosted: Sun May 01, 2005 12:25 am Reply with quote

So I see in nuke_users is where the vaslue is stored. And my value:

Next Autoindex 2,147,483,647

But I can't seem to find any way to change it. ANyone have any suggestions?

Thanks!
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Post Installation Help

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 ©