View Full Version : At register username not inserted in database.
Chebiza
02-11-2006, 02:32 AM
Hi
I installed a nuke platinum 7.0.6 and created a new database in phpmyadmin.
Before that I had made a backup file of my former database also
a nuke platinum 7.0.6. (I have MySql)
After the database was created I inserted
the former backup database as it was
with all the members and everything.
I did that in query and then imported the backup file.
Everything works fine...except when new users registers the username is not showing.
In the Users info the latest member registered shows a blank(nothing)
When I go to active users in the Admin panel your account admin it shows the uid but not username?
What is wrong?
And what do I have to do to meke all the new registered members username shows?
Thankx
Chebiza
welcome here!
you're not realy giving us anything more then a description of the problem. We need to see the code that you use to insert the user, a dumpfile of the tablestructure, the selectquery that you use to get the userdatails etc.
Chebiza
02-11-2006, 02:28 PM
welcome here!
you're not realy giving us anything more then a description of the problem. We need to see the code that you use to insert the user, a dumpfile of the tablestructure, the selectquery that you use to get the userdatails etc.
Okej here goes:
I clicked the query window in myphpadmin up at my cpanel
And pasted the following in the window:
#
# Table structure for table 'nuke_users'
#
DROP TABLE IF EXISTS nuke_users;
CREATE TABLE nuke_users (
user_id int(11) NOT NULL auto_increment,
name varchar(60) NOT NULL,
username varchar(25) NOT NULL,
user_email varchar(255) NOT NULL,
femail varchar(255) NOT NULL,
user_website varchar(255) NOT NULL,
user_avatar varchar(255) NOT NULL,
user_regdate varchar(20) NOT NULL,
user_icq varchar(15),
user_occ varchar(100),
user_from varchar(100),
user_interests varchar(150) NOT NULL,
user_sig varchar(255),
user_viewemail tinyint(2),
user_theme int(3),
user_aim varchar(18),
user_yim varchar(25),
user_msnm varchar(25),
user_password varchar(40) NOT NULL,
storynum tinyint(4) DEFAULT '10' NOT NULL,
umode varchar(10) NOT NULL,
uorder tinyint(1) DEFAULT '0' NOT NULL,
thold tinyint(1) DEFAULT '0' NOT NULL,
noscore tinyint(1) DEFAULT '0' NOT NULL,
bio tinytext NOT NULL,
ublockon tinyint(1) DEFAULT '0' NOT NULL,
ublock tinytext NOT NULL,
theme varchar(255) NOT NULL,
commentmax int(11) DEFAULT '4096' NOT NULL,
counter int(11) DEFAULT '0' NOT NULL,
newsletter int(1) DEFAULT '0' NOT NULL,
user_posts int(10) DEFAULT '0' NOT NULL,
user_attachsig int(2) DEFAULT '0' NOT NULL,
user_rank int(10) DEFAULT '0' NOT NULL,
user_level int(10) DEFAULT '1' NOT NULL,
broadcast tinyint(1) DEFAULT '1' NOT NULL,
popmeson tinyint(1) DEFAULT '0' NOT NULL,
user_active tinyint(1) DEFAULT '1',
user_session_time int(11) DEFAULT '0' NOT NULL,
user_session_page smallint(5) DEFAULT '0' NOT NULL,
user_lastvisit int(11) DEFAULT '0' NOT NULL,
user_timezone tinyint(4) DEFAULT '10' NOT NULL,
user_style tinyint(4),
user_lang varchar(255) DEFAULT 'english' NOT NULL,
user_dateformat varchar(14) DEFAULT 'D M d, Y g:i a' NOT NULL,
user_new_privmsg smallint(5) unsigned DEFAULT '0' NOT NULL,
user_unread_privmsg smallint(5) unsigned DEFAULT '0' NOT NULL,
user_last_privmsg int(11) DEFAULT '0' NOT NULL,
user_emailtime int(11),
user_allowhtml tinyint(1) DEFAULT '1',
user_allowbbcode tinyint(1) DEFAULT '1',
user_allowsmile tinyint(1) DEFAULT '1',
user_allowavatar tinyint(1) DEFAULT '1' NOT NULL,
user_allow_pm tinyint(1) DEFAULT '1' NOT NULL,
user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL,
user_notify tinyint(1) DEFAULT '0' NOT NULL,
user_notify_pm tinyint(1) DEFAULT '0' NOT NULL,
user_popup_pm tinyint(1) DEFAULT '0' NOT NULL,
user_avatar_type tinyint(4) DEFAULT '3' NOT NULL,
user_sig_bbcode_uid varchar(10),
user_actkey varchar(32),
user_newpasswd varchar(32),
points int(10) DEFAULT '0',
user_color_gc varchar(6),
user_color_gi int(10) DEFAULT '0',
user_quickreply tinyint(1) DEFAULT '0' NOT NULL,
user_allow_arcadepm tinyint(4) DEFAULT '1' NOT NULL,
kick_ban int(2) DEFAULT '0' NOT NULL,
user_wordwrap smallint(2) DEFAULT '70' NOT NULL,
agreedtos tinyint(1) DEFAULT '0' NOT NULL,
user_group int(11) DEFAULT '2' NOT NULL,
user_group_list_cp varchar(100) DEFAULT '2' NOT NULL,
user_active_cp enum('YES','NO') DEFAULT 'YES' NOT NULL,
PRIMARY KEY (user_id),
KEY uid (user_id),
KEY uname (username),
KEY user_session_time (user_session_time)
);
#
# Dumping data for table 'nuke_users'
INSERT INTO nuke_users VALUES ('1', '', 'Anonymous', '', '', '', 'blank.gif', 'Jan 26, 2006', '', '', '', '', '', '0', '0', '', '', '', '', '10', '', '0', '0', '0', '', '0', '', '', '4096', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '0', '10', NULL, 'english', 'D M d, Y g:i a', '0', '0', '0', NULL, '1', '1', '1', '1', '1', '1', '1', '1', '0', '3', NULL, NULL, NULL, '0', NULL, '0', '0', '1', '0', '70', '0', '2', '2', 'YES');
And all the other users were inserted here......(as you may understand I cant paste that list here)
Thats it...
hugs
When I go to active users in the Admin panel your account admin it shows the uid but not username?
i just ran your code and i don't have any problem inserting a usernameor displaign it.
insertioncode:
INSERT INTO nuke_users VALUES ('1', '', 'Anonymous', '', '', '', 'blank.gif', 'Jan 26, 2006', '', '', '', '', '', '0', '0', '', '', '', '', '10', '', '0', '0', '0', '', '0', '', '', '4096', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '0', '10', NULL, 'english', 'D M d, Y g:i a', '0', '0', '0', NULL, '1', '1', '1', '1', '1', '1', '1', '1', '0', '3', NULL, NULL, NULL, '0', NULL, '0', '0', '1', '0', '70', '0', '2', '2', 'YES');
INSERT INTO nuke_users VALUES ('2', '', 'testets', '', '', '', 'blank.gif', 'Jan 26, 2006', '', '', '', '', '', '0', '0', '', '', '', '', '10', '', '0', '0', '0', '', '0', '', '', '4096', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '0', '10', NULL, 'english', 'D M d, Y g:i a', '0', '0', '0', NULL, '1', '1', '1', '1', '1', '1', '1', '1', '0', '3', NULL, NULL, NULL, '0', NULL, '0', '0', '1', '0', '70', '0', '2', '2', 'YES')
INSERT INTO nuke_users VALUES ('3', 'cccc', 'testetsdddd', '', '', '', 'blank.gif', 'Jan 26, 2006', '', '', '', '', '', '0', '0', '', '', '', '', '10', '', '0', '0', '0', '', '0', '', '', '4096', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '0', '10', NULL, 'english', 'D M d, Y g:i a', '0', '0', '0', NULL, '1', '1', '1', '1', '1', '1', '1', '1', '0', '3', NULL, NULL, NULL, '0', NULL, '0', '0', '1', '0', '70', '0', '2', '2', 'YES')
and to display:
select name, username from nuke_users
which shows
name,username
,Anonymous
,testets
cccc,testetsdddd
Chebiza
02-11-2006, 05:22 PM
i just ran your code and i don't have any problem inserting a usernameor displaign it.
insertioncode:
INSERT INTO nuke_users VALUES ('1', '', 'Anonymous', '', '', '', 'blank.gif', 'Jan 26, 2006', '', '', '', '', '', '0', '0', '', '', '', '', '10', '', '0', '0', '0', '', '0', '', '', '4096', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '0', '10', NULL, 'english', 'D M d, Y g:i a', '0', '0', '0', NULL, '1', '1', '1', '1', '1', '1', '1', '1', '0', '3', NULL, NULL, NULL, '0', NULL, '0', '0', '1', '0', '70', '0', '2', '2', 'YES');
INSERT INTO nuke_users VALUES ('2', '', 'testets', '', '', '', 'blank.gif', 'Jan 26, 2006', '', '', '', '', '', '0', '0', '', '', '', '', '10', '', '0', '0', '0', '', '0', '', '', '4096', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '0', '10', NULL, 'english', 'D M d, Y g:i a', '0', '0', '0', NULL, '1', '1', '1', '1', '1', '1', '1', '1', '0', '3', NULL, NULL, NULL, '0', NULL, '0', '0', '1', '0', '70', '0', '2', '2', 'YES')
INSERT INTO nuke_users VALUES ('3', 'cccc', 'testetsdddd', '', '', '', 'blank.gif', 'Jan 26, 2006', '', '', '', '', '', '0', '0', '', '', '', '', '10', '', '0', '0', '0', '', '0', '', '', '4096', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '0', '10', NULL, 'english', 'D M d, Y g:i a', '0', '0', '0', NULL, '1', '1', '1', '1', '1', '1', '1', '1', '0', '3', NULL, NULL, NULL, '0', NULL, '0', '0', '1', '0', '70', '0', '2', '2', 'YES')
and to display:
select name, username from nuke_users
which shows
name,username
,Anonymous
,testets
cccc,testetsdddd
Okej thanx
I have been watching my site all day today and today there
doesn´t seem to be any problem at all....:-)
I dont understand why I get new users added with only uid and nothing else?
Well, I will keep my eyes on it in the future so...:-)
Hugs
Chebiza
vBulletin® v3.8.2, Copyright ©2000-2012, Jelsoft Enterprises Ltd.