>>
Site Map
>>
Forums
>>
General 7x
Forum module - topics in forum:
General 7x - Discussions reagarding any other PHP-Nuke Problems. 7x
nuke_users and nuke_users_temp
Interesting problem here:
I have been getting users say they can't register on my phpnuke 7.x system. Upon looking at the nuke_users table, I found that all users since user 15 had NULL entries all over the place. The users 1-15 are fine and can log on no problems, the users 16 and above can't do anything (even the active field is null)
I though I'd just delete 16 and above and have those users re register. I don't want the first 15 to have to do this, that is the core group of users with forum posts, etc.
Now when I try to create a new user, I get the email and confirmation from the site saying that I registered successfully. However, I cannot log in and my test name isn’t shown on the latest new user (user info block).
I tried another test user, but before I clicked on the confirmation, I looked at my nuke_users_temp table and there was my test user. The problem was, his user_id was not next in line (remember, I have 15 users now in the table), he was assigned a higher number (18 in this case).
I am suspecting that since the system isn’t assigning the correct auto increment ID (next in line), it isn’t getting placed into the nuke_users table properly and thus not going in at all.
I can’t seem to find the placeholder for the auto increment user_id that gets created, it obviously isn’t looking at the last user_id in the nuke_users table.
I need this to start at 16 and work for new user registrations…..any thoughts?
(Thanks in advanced)
David
killum@teampro.us
Are the users actually activating their accounts?
Yep, the registration process will seem to work, the user will get the confirmation email, they'll confirm it, but they don't exist anywhere (does not show up as latest user and can't login). The user will stay in the temp table (not with the next available user_id field) until the confirmation, once confirmer....poof gone.
Depending on which version of phpMyAdmin you are using the auto_increment value can be set like:
nuke_users table > Operations > Table options > Set auto_increment value.
BL
Yep, there it is. Thanks for the info, I'll see about setting it to the next in line and see if I can reg people now.
