New User Activation not Working

Guest

Hi all, please help with with this query asap if possible.

I have recently undertaken a phpBB to nuke port which went well. Im running the 2.0.6 version of the BB integrated with the Nuke site. This is all working well, i have also carried out the quick reply mod on the forum and this has also worked well.

Up until a couple of days back (i have carried out so many mods now i lose track of them) the new user registration was functioning correctly. However, now it doesnt appear to be working.

When the new user gets the confirmation email, they click the link only to be told the account has been created. However, when they try to log on they are told that the login information is incorrect. Also, if they try clicking on the email link again, they are told the account also doesnt exist.

Im running version 6.5 of PHP Nuke.

Any help would be appreciated, or i feel im going to have to restore an older version that i have backed up and hope there are no DB conflicts!

Posted: Tue Sep 16, 2003 1:58 am

Also, if i try to manually add a user to the database using the administration, then after i confirm the details im presented with a blank page with the admin.php address in the brower window! EEEk. Please help me if you can.

Posted: Tue Sep 16, 2003 2:18 am

Ok then, due to my cast computer knowledge Wink

I have discovered what is happening, i just dont know how to stop it!

When a new user is created, instead of incrementing by "1" the new user gets a user_id of "2147483647". Thats enough to screw up the new users registration process it seems.

Any ideas where the current or next user_id is stored, or how its worked out?? Really desperate for this information if anyone can help!!
Thanks in Advance!

Guest

Ok guys, really am desperate. I know what i need to do, but i just cant figure out how to do it.

Someone said goto phpmyadmin and look at the options for the nuke_users table and set the auto increment that way. However, once there the option isnt available.

Also, another suggestion was to try a small sql command:-

Quote:

ALTER TABLE nuke_users AUTO_INCREMENT = 236;
ALTER TABLE nuke_users_temp AUTO_INCREMENT = 236;

^^^^236 is what i need my records to start from.

But i get the following error:-

Quote:

SQL-query :

ALTER TABLE nuke_usersAUTO_INCREMENT = 236

MySQL said:

You have an error in your SQL syntax near '= 236' at line 1

Here is the information listed at the bottom of my nuke_users table:-

Quote:

Row Statistic : Statements Value
Format dynamic
Rows 233
Row length ø 271
Row size ø 346 Bytes
Next Autoindex 2,147,483,647

Can anyone else help me reset the auto increment to my pre determined value?

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

The conversion script you use still has a tiny, but major flaw in it. It keeps the anonymous user -1. That will not work in the later release port. In addition to altering the autoincrement values, you must do this too.

- Change the -1 userid to 0 or (1 if 1 is not already used) in nuke_users.
- Using phpMyAdmin, change all poster_id from -1 to 0 (or 1) in nuke_bbposts.
- Using phpMyAdmin, change all topics_poster from -1 to 0 (or 1) in nuke_bbtopics.

There may be one more table/column, I can't remember for sure where there is the -1 that you will have to change. Maybe on replies.

It's the -1 that is causing the huge auto increment values.

Guest

I dont allow anonymous posting on the forum, and am unable to find any -1 values in the other tables. However, at the bottom of the nuke_users table the Next Autoindex is still listed as the stupidly high number after changing the anonymous user_id to 1.

Any other ideas? Can i force the autoincrement back to 236 like others have mentioned?

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Whether you allow it or not, the system usually adds an anonymous user in the nuke_users table with a -1 user_id. If you do not have a -1 user_id, that is very odd and I have never seen the huge number occur for any other reason. Try doing an SQL search on the table

Select * from nuke_users where user_id=-1;

to verify that there is no user like that. If there isn't, then I don't know what else would cause your problem.

Posted: Tue Sep 16, 2003 5:28 am

No, i have changed the user_id in the nuke_users table for the anonymous poster back to 1 from -1. However, because i dont allow any anonymous posting there are no other -1 values in the tables.

But the autoindex is still listed as:- 2147483647 at the bottom of the nuke_users table and upon creating new users they are given that user_id!

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Try this.

- Export the table and save it to a file. Manually alter the auto increment value in the exported file to 236.
- Drop the nuke_users table.
- Import the table back in.

Posted: Tue Sep 16, 2003 5:37 am

Hehe, thats what im trying to find out how to do at the moment. I need to manually alter tha autoincrement but dont know how! Wink

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Use phpMyAdmin. Select the nuke_users table. Issue this command in the SQL window

ALTER TABLE nuke_users AUTO_INCREMENT = 236;

[syntax error - sorry - typo corrected]

Posted: Tue Sep 16, 2003 5:45 am

Similar to the error i get above unfortunately. This is the error i get:-

Quote:

Error

SQL-query :

ALTER TABLE nuke_users SET AUTO_INCREMENT = 236

MySQL said:

You have an error in your SQL syntax near 'SET AUTO_INCREMENT = 236' at line 1
Back

Thanks for all the help btw. Any other ideas?

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

The SET was a mistake. Try this.

Make sure that you have corrected the high number to a valid number. Then issue
ALTER TABLE nuke_users AUTO_INCREMENT = 236;

Posted: Tue Sep 16, 2003 5:52 am

As i listed above, this is the code i found somewhere else and it didnt work. Well not with my phpmyadmin anyway Sad

Error i get is the same as above:-

Quote:

Error

SQL-query :

ALTER TABLE nuke_usersAUTO_INCREMENT = 236

MySQL said:

You have an error in your SQL syntax near '= 236' at line 1

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Raven wrote:

Try this.

- Export the table and save it to a file. Manually alter the auto increment value in the exported file to 236.
- Drop the nuke_users table.
- Import the table back in.

Then do what I told you in this post. Manually alter the value in the FILE with a text editor. The drop the table using phpMyAdmin. Then IMPORT the table back in.