| Author |
Message |
Guest
|
 Posted:
Mon Oct 10, 2005 3:16 pm |
  |
im having a problem adding users, when ever i manually try to add a new user from admin, my page just goes blank, and the user isnt it the database??? |
|
|
 |
|
Guest
|
| Posted:
Mon Oct 10, 2005 4:07 pm |
|
im using version 7.8, i downloaded the auto activate mod, i tried to add myself as a new user, it all seemed to work fine but when i tried to log in ising the new login, said incorrect user or password, i checked the table nuke_users, and there is no data in the table, its seems like a sql issue, but i can work it out |
|
|
|
|
Evaders99
Site Admin
Joined: Aug 17, 2003
Posts: 12373
|
| Posted:
Mon Oct 10, 2005 5:42 pm |
|
|
    |
|
Guest
|
| Posted:
Mon Oct 10, 2005 6:10 pm |
|
Table structure for table nuke_users
Field Type Null Default
user_id int(11) Yes NULL
name varchar(60) Yes
username varchar(25) Yes
user_email varchar(255) Yes
femail varchar(255) Yes
user_website varchar(255) Yes
user_avatar varchar(255) Yes
user_regdate varchar(20) Yes
user_icq varchar(15) Yes NULL
user_occ varchar(100) Yes NULL
user_from varchar(100) Yes NULL
user_interests varchar(150) Yes
user_sig varchar(255) Yes NULL
user_viewemail tinyint(2) Yes NULL
user_theme int(3) Yes NULL
user_aim varchar(1 Yes NULL
user_yim varchar(25) Yes NULL
user_msnm varchar(25) Yes NULL
user_password varchar(40) Yes
storynum tinyint(4) Yes 10
umode varchar(10) Yes
uorder tinyint(1) Yes 0
thold tinyint(1) Yes 0
noscore tinyint(1) Yes 0
bio tinytext Yes
ublockon tinyint(1) Yes 0
ublock tinytext Yes
theme varchar(255) Yes
commentmax int(11) Yes 4096
counter int(11) Yes 0
newsletter int(1) Yes 0
user_posts int(10) Yes 0
user_attachsig int(2) Yes 0
user_rank int(10) Yes 0
user_level int(10) Yes 1
broadcast tinyint(1) Yes 1
popmeson tinyint(1) Yes 0
user_active tinyint(1) Yes 1
user_session_time int(11) Yes 0
user_session_page smallint(5) Yes 0
user_lastvisit int(11) Yes 0
user_timezone tinyint(4) Yes 10
user_style tinyint(4) Yes NULL
user_lang varchar(255) Yes english
user_dateformat varchar(14) Yes D M d, Y g:i a
user_new_privmsg smallint(5) Yes 0
user_unread_privmsg smallint(5) Yes 0
user_last_privmsg int(11) Yes 0
user_emailtime int(11) Yes NULL
user_allowhtml tinyint(1) Yes 1
user_allowbbcode tinyint(1) Yes 1
user_allowsmile tinyint(1) Yes 1
user_allowavatar tinyint(1) Yes 1
user_allow_pm tinyint(1) Yes 1
user_allow_viewonline tinyint(1) Yes 1
user_notify tinyint(1) Yes 0
user_notify_pm tinyint(1) Yes 0
user_popup_pm tinyint(1) Yes 0
user_avatar_type tinyint(4) Yes 3
user_sig_bbcode_uid varchar(10) Yes NULL
user_actkey varchar(32) Yes NULL
user_newpasswd varchar(32) Yes NULL
points int(10) Yes 0
last_ip varchar(15) Yes 0
karma tinyint(1) Yes 0 |
|
|
|
|
Evaders99
Site Admin
Joined: Aug 17, 2003
Posts: 12373
|
| Posted:
Mon Oct 10, 2005 9:24 pm |
|
|
|
|
Guest
|
| Posted:
Mon Oct 10, 2005 9:32 pm |
|
i downloaded them, do i just extract the files ontop of the current ones???? |
|
|
|
|
Evaders99
Site Admin
Joined: Aug 17, 2003
Posts: 12373
|
| Posted:
Mon Oct 10, 2005 9:33 pm |
|
|
|
|
Guest
|
| Posted:
Mon Oct 10, 2005 9:43 pm |
|
ok i did that and updated the nuke database, now when i try and access the page i just get "There seems to be a problem with the MySQL server, sorry for the inconvenience.
We should be back shortly."
i dont know if it helps, i have mysql 5 installed |
|
|
|
|
Guest
|
| Posted:
Mon Oct 10, 2005 9:45 pm |
|
nvm last post, i forgot to modify the config.php, im trying to add a new user now |
|
|
|
|
Guest
|
| Posted:
Mon Oct 10, 2005 9:50 pm |
|
no, still get a blank page when i try to add user through admin, and doesnt work when i log out as admin and try register myself either |
|
|
|
|
Evaders99
Site Admin
Joined: Aug 17, 2003
Posts: 12373
|
| Posted:
Tue Oct 11, 2005 11:54 am |
|
|
|
|
Guest
|
| Posted:
Tue Oct 11, 2005 3:31 pm |
|
i enabled "error_reporting = E_ALL; display all errors, warnings and notices"
no errors of any kind are showing up and im at a loss for whats causing it, ive also discovered i can add forums, but when i try to post, they are not saved in the forum, also i added a picture to my home page messages section and lost my right side blocks?????? took the picture off and they are still gone lol, do you think this could be a MySql 5.0 issue?? would it be wise to install an earlier version say 4.X??? |
|
|
|
|
Guest
|
| Posted:
Tue Oct 11, 2005 4:41 pm |
|
ok, i decided to try MySql 4.1, and i couldnt believe it, i can now add users. cheers for your help. |
|
|
|
|
|
|
