Author |
Message |
ill_c
New Member


Joined: Jan 05, 2007
Posts: 5
|
Posted:
Fri Jan 05, 2007 4:23 pm |
|
Hi,
First off apologies if this is in the wrong place and if it has already been answered but i have been searching for an answer for hours now. A link to an answer would be much appreciated!
I'm quite new to this so please bear with me.
No one can register with my site as a new user. The closest topic i could find to an answer is here http://www.ravenphpscripts.com/postt1477.html.
as per the above thread -
When a new user registers with my site i check in phpmyadmin and in nuke_users_temp, and all their info is there that they entered when registering.
upon clicking the link in the activation email it takes me back to the site stating success and i should now log in.
Checking the table nuke_users_temp shows it now is empty, but the information was not transferred over to nuke_users which is also empty, and my login details are invalid!
Please help me fix this its driving me mad.
My site is http://www.ill-clan.net |
|
|
|
 |
montego
Site Admin

Joined: Aug 29, 2004
Posts: 9457
Location: Arizona
|
Posted:
Fri Jan 05, 2007 5:24 pm |
|
What version of nuke? And have you made any modifications to the script files? |
_________________ Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! |
|
|
 |
ill_c

|
Posted:
Fri Jan 05, 2007 5:30 pm |
|
sorry, its nuke 7.6 (v2.02.02. ravennuke)
i haven't personally made changes to the scripts unless i was installing a block or module for my site which told me to.
Which file deals with the adding of users from users_temp to users? |
Last edited by ill_c on Fri Jan 05, 2007 5:36 pm; edited 1 time in total |
|
|
 |
montego

|
Posted:
Fri Jan 05, 2007 5:36 pm |
|
2.02.02 works like a champ with regards to the registration, so I am wondering if one of your module installations modified the index.php under the modules/Your_Account directory? |
|
|
|
 |
ill_c

|
Posted:
Fri Jan 05, 2007 5:39 pm |
|
i'll see what happens when i replace that file with a freshly installed one. |
|
|
|
 |
ill_c

|
Posted:
Fri Jan 05, 2007 5:45 pm |
|
Just put the modules/your_account/index.php on from the zipped up v2.02.02 archive and its still not registering users  |
|
|
|
 |
montego

|
Posted:
Fri Jan 05, 2007 6:03 pm |
|
someone else is going to have to take a stab at this one. The common issues would be not getting the email out, but that is happening, so I am now stumped.
Actually, post the table structure from phpMyAdmin of the nuke_users and nuke_users_temp tables here so we can take a look at them. |
|
|
|
 |
ill_c

|
Posted:
Fri Jan 05, 2007 7:01 pm |
|
Table nuke_users:
Code:Field Type Collation Attributes Null Default Extra Action
user_id int(11) No auto_increment Browse distinct values Change Drop Primary Unique Index Fulltext
name varchar(60) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
username varchar(25) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
user_email varchar(255) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
femail varchar(255) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
user_website varchar(255) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
user_avatar varchar(255) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
user_regdate varchar(20) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
user_icq varchar(15) utf8_general_ci Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_occ varchar(100) utf8_general_ci Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_from varchar(100) utf8_general_ci Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_interests varchar(150) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
user_sig varchar(255) utf8_general_ci Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_viewemail tinyint(2) Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_theme int(3) Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_aim varchar(18) utf8_general_ci Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_yim varchar(25) utf8_general_ci Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_msnm varchar(25) utf8_general_ci Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_password varchar(40) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
storynum tinyint(4) No 10 Browse distinct values Change Drop Primary Unique Index Fulltext
umode varchar(10) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
uorder tinyint(1) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
thold tinyint(1) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
noscore tinyint(1) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
bio tinytext utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
ublockon tinyint(1) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
ublock tinytext utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
theme varchar(255) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
commentmax int(11) No 4096 Browse distinct values Change Drop Primary Unique Index Fulltext
counter int(11) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
newsletter int(1) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_posts int(10) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_attachsig int(2) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_rank int(10) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_level int(10) No 1 Browse distinct values Change Drop Primary Unique Index Fulltext
broadcast tinyint(1) No 1 Browse distinct values Change Drop Primary Unique Index Fulltext
popmeson tinyint(1) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_active tinyint(1) Yes 1 Browse distinct values Change Drop Primary Unique Index Fulltext
user_session_time int(11) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_session_page smallint(5) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_lastvisit int(11) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_timezone tinyint(4) No 10 Browse distinct values Change Drop Primary Unique Index Fulltext
user_style tinyint(4) Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_lang varchar(255) utf8_general_ci No english Browse distinct values Change Drop Primary Unique Index Fulltext
user_dateformat varchar(14) utf8_general_ci No D M d, Y g:i a Browse distinct values Change Drop Primary Unique Index Fulltext
user_new_privmsg smallint(5) UNSIGNED No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_unread_privmsg smallint(5) UNSIGNED No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_last_privmsg int(11) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_emailtime int(11) Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_allowhtml tinyint(1) Yes 1 Browse distinct values Change Drop Primary Unique Index Fulltext
user_allowbbcode tinyint(1) Yes 1 Browse distinct values Change Drop Primary Unique Index Fulltext
user_allowsmile tinyint(1) Yes 1 Browse distinct values Change Drop Primary Unique Index Fulltext
user_allowavatar tinyint(1) No 1 Browse distinct values Change Drop Primary Unique Index Fulltext
user_allow_pm tinyint(1) No 1 Browse distinct values Change Drop Primary Unique Index Fulltext
user_allow_viewonline tinyint(1) No 1 Browse distinct values Change Drop Primary Unique Index Fulltext
user_notify tinyint(1) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_notify_pm tinyint(1) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_popup_pm tinyint(1) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_avatar_type tinyint(4) No 3 Browse distinct values Change Drop Primary Unique Index Fulltext
user_sig_bbcode_uid varchar(10) utf8_general_ci Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_actkey varchar(32) utf8_general_ci Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
user_newpasswd varchar(32) utf8_general_ci Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
points int(10) Yes 0 Browse distinct values Change Drop Primary Unique Index Fulltext
last_ip varchar(15) utf8_general_ci No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
user_allow_arcadepm tinyint(4) No 1
|
Table nuke_users_temp:
Code:Field Type Collation Attributes Null Default Extra Action
user_id int(10) No auto_increment Browse distinct values Change Drop Primary Unique Index Fulltext
username varchar(25) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
user_email varchar(255) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
user_password varchar(40) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
user_regdate varchar(20) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
check_num varchar(50) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
time varchar(14) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
|
I notice some fields have been added by the v3 arcade mod i put on, could this be the issue? |
|
|
|
 |
montego

|
Posted:
Sat Jan 06, 2007 8:04 am |
|
Well, something has definitely added a new field to the nuke_users table:
user_allow_arcadepm
This field is NOT in the 2.02.02 table definition for nuke_users.
If the corresponding Your_Account changes were not made to account for that (along with several other changes in other places, such as admin), you are going to have this problem.
If you do not recognize this field or the mod that it goes with, delete the field using phpMyAdmin and see if that solves your problem. |
|
|
|
 |
|