You are missing our premiere tool bar navigation system! Register and use it for FREE!


Author: RavenLocation: USAPostPosted: Tue Sep 16, 2003 4:49 am    Post subject: Re: New User Activation not Working

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.

Author: DeakoPostPosted: Tue Sep 16, 2003 5:11 am    Post subject:

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?

Author: RavenLocation: USAPostPosted: Tue Sep 16, 2003 5:23 am    Post subject:

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.

Author: GuestPostPosted: Tue Sep 16, 2003 5:28 am    Post subject:

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!

Author: RavenLocation: USAPostPosted: Tue Sep 16, 2003 5:31 am    Post subject:

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.

Author: GuestPostPosted: Tue Sep 16, 2003 5:37 am    Post subject: Re: New User Activation not Working

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

Author: RavenLocation: USAPostPosted: Tue Sep 16, 2003 5:42 am    Post subject:

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]


Last edited by Raven on Tue Sep 16, 2003 5:47 am; edited 1 time in total

Author: GuestPostPosted: Tue Sep 16, 2003 5:45 am    Post subject:

Similar to the error i get above unfortunately. This is the error i get:-
NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 

Author: GuestPostPosted: Tue Sep 16, 2003 1:58 am    Post subject: Re: New User Activation not Working

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.

Author: GuestPostPosted: Tue Sep 16, 2003 2:18 am    Post subject: Re: New User Activation not Working

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!

Author: DeakoPostPosted: Tue Sep 16, 2003 3:22 am    Post subject:

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:-

Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 156 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - New User Activation not Working New User Activation not Working
Goto page 1, 2, 3  Next  :| |:
Nuke Cops -> Post-Install Help For Guests Only

Author: Deako PostPosted: Tue Sep 16, 2003 1:56 am    Post subject: New User Activation not Working

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!
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?
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?

Author: RavenLocation: USA PostPosted: Tue Sep 16, 2003 5:50 am    Post subject:

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;

Author: Guest PostPosted: Tue Sep 16, 2003 5:52 am    Post subject:

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

Author: RavenLocation: USA PostPosted: Tue Sep 16, 2003 5:55 am    Post subject:

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.



Nuke Cops -> Post-Install Help For Guests Only

All times are GMT - 8 Hours

Goto page 1, 2, 3  Next  :| |:
Page 1 of 3

Powered by phpBB © 2001,2002 phpBB Group
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.051 Seconds - 219 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
added by Evaders - DO NOT REMOVE
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::