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

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
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, 131 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 [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
This forum is locked: you cannot post, reply to, or edit topics.  This topic is locked: you cannot edit posts or make replies.printer-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
Deako
Guest






PostPosted: Tue Sep 16, 2003 1:56 am Reply with quoteBack to top

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!
Find all posts by Anonymous
Guest







PostPosted: Tue Sep 16, 2003 1:58 am Reply with quoteBack to top

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.
Find all posts by Anonymous
Guest







PostPosted: Tue Sep 16, 2003 2:18 am Reply with quoteBack to top

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!
Find all posts by Anonymous
Deako
Guest






PostPosted: Tue Sep 16, 2003 3:22 am Reply with quoteBack to top

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?
Find all posts by Anonymous
Raven
General
General


Joined: Mar 22, 2003
Posts: 5233

Location: USA

PostPosted: Tue Sep 16, 2003 4:49 am Reply with quoteBack to top

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.

_________________
Those who hear not the music think the dancers mad.
Raven Web Hosting|My Scripts & Stuff
Find all posts by RavenView user's profileSend private messageVisit poster's website
Deako
Guest






PostPosted: Tue Sep 16, 2003 5:11 am Reply with quoteBack to top

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?
Find all posts by Anonymous
Raven
General
General


Joined: Mar 22, 2003
Posts: 5233

Location: USA

PostPosted: Tue Sep 16, 2003 5:23 am Reply with quoteBack to top

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.

_________________
Those who hear not the music think the dancers mad.
Raven Web Hosting|My Scripts & Stuff
Find all posts by RavenView user's profileSend private messageVisit poster's website
Guest







PostPosted: Tue Sep 16, 2003 5:28 am Reply with quoteBack to top

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!
Find all posts by Anonymous
Raven
General
General


Joined: Mar 22, 2003
Posts: 5233

Location: USA

PostPosted: Tue Sep 16, 2003 5:31 am Reply with quoteBack to top

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.

_________________
Those who hear not the music think the dancers mad.
Raven Web Hosting|My Scripts & Stuff
Find all posts by RavenView user's profileSend private messageVisit poster's website
Guest







PostPosted: Tue Sep 16, 2003 5:37 am Reply with quoteBack to top

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
Find all posts by Anonymous
Raven
General
General


Joined: Mar 22, 2003
Posts: 5233

Location: USA

PostPosted: Tue Sep 16, 2003 5:42 am Reply with quoteBack to top

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]

_________________
Those who hear not the music think the dancers mad.
Raven Web Hosting|My Scripts & Stuff

Last edited by Raven on Tue Sep 16, 2003 5:47 am; edited 1 time in total
Find all posts by RavenView user's profileSend private messageVisit poster's website
Guest







PostPosted: Tue Sep 16, 2003 5:45 am Reply with quoteBack to top

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?
Find all posts by Anonymous
Raven
General
General


Joined: Mar 22, 2003
Posts: 5233

Location: USA

PostPosted: Tue Sep 16, 2003 5:50 am Reply with quoteBack to top

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;

_________________
Those who hear not the music think the dancers mad.
Raven Web Hosting|My Scripts & Stuff
Find all posts by RavenView user's profileSend private messageVisit poster's website
Guest







PostPosted: Tue Sep 16, 2003 5:52 am Reply with quoteBack to top

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
Find all posts by Anonymous
Raven
General
General


Joined: Mar 22, 2003
Posts: 5233

Location: USA

PostPosted: Tue Sep 16, 2003 5:55 am Reply with quoteBack to top

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.

_________________
Those who hear not the music think the dancers mad.
Raven Web Hosting|My Scripts & Stuff
Find all posts by RavenView user's profileSend private messageVisit poster's website
Display posts from previous:      
This forum is locked: you cannot post, reply to, or edit topics.  This topic is locked: you cannot edit posts or make replies.printer-friendly view
View previous topic Log in to check your private messages View next topic
You can post new topics in this forum
You can 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



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
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: 5.537 Seconds - 86 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::