Registration error.. username already taken !!?!!

scriptleek · Hangin' Around Joined: Oct 19, 2005 Posts: 40

Hi, Suddenly another weird error occurred.
When my users want to register they get the message ..error! username already taken.. Whatever username they choose they get this message.

phpnuke 7.8 patched 3.1

can anyone help me out here?

Thnx.
Regards;
Scriptleek.

CurtisH · Posted: Tue Oct 25, 2005 6:21 am

Check your nuke_users table and make sure that you have an entry for anonymous with the user_id of "1"

Without that entry you can get the error you are reporting.

scriptleek · Hangin' Around Joined: Oct 19, 2005 Posts: 40

Hello CurtisH, thnx for the info i restored my db and all works now but i was curious what caused it..now i know.. the weird thing is ..it works..ok..but..now i checked my db and in the nuke_users table there are all users but no anonymous Shocked

and when i try to add anonymous to the database i get the error..#1136 - Column count doesn't match value count at row 1 ..using the original 7.8 table string:

INSERT INTO nuke_users VALUES (1, '', 'Anonymous', '', '', '', 'blank.gif', 'Nov 10, 2000', '', '', '', '', '', 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, '0', 0);

Am i overlooking things?
Thnx & regards;
Scriptleek.

CurtisH · Posted: Tue Oct 25, 2005 6:54 am

Compare your INSERT statement with the existing table to ensure that you have the same number of values as there are columns. If they do not match you will get that error.

scriptleek · Hangin' Around Joined: Oct 19, 2005 Posts: 40

Ah.. i c ..hm..ok many thnx CurtisH.

Greetz;
Scriptleek.

scriptleek · Hangin' Around Joined: Oct 19, 2005 Posts: 40

Good evening,

Well after the above post i tried and i tried but i gave up on how to add the anonymous user to the database..i ran out of options.. so i don't know how to do this.

Can anybody explain how to add the anonymous user to my database please because now i constantly get the ..username already taken.. error at registration.

Thnx.
Regards;
Scriptleek.

CurtisH · Posted: Tue Oct 25, 2005 2:32 pm

Please provide the sql for the nuke_users table. Export the table (not data too, just the table) to an sql file and post it (using the code tags please) in a reply so I can see the structure of your nuke_users table.

It should look something like this:

Code:

CREATE TABLE nuke_users (
user_id int(11) NOT NULL auto_increment,
name varchar(60) NOT NULL default '',
username varchar(25) NOT NULL default '',
user_email varchar(255) NOT NULL default '',
femail varchar(255) NOT NULL default '',
user_website varchar(255) NOT NULL default '',
user_avatar varchar(255) NOT NULL default '',
user_regdate varchar(20) NOT NULL default '',
user_icq varchar(15) default NULL,
user_occ varchar(100) default NULL,
user_from varchar(100) default NULL,
user_interests varchar(150) NOT NULL default '',
user_sig varchar(255) default NULL,
user_viewemail tinyint(2) default NULL,
user_theme int(3) default NULL,
user_aim varchar(18) default NULL,
user_yim varchar(25) default NULL,
user_msnm varchar(25) default NULL,
user_password varchar(40) NOT NULL default '',
storynum tinyint(4) NOT NULL default '10',
umode varchar(10) NOT NULL default '',
uorder tinyint(1) NOT NULL default '0',
thold tinyint(1) NOT NULL default '0',
noscore tinyint(1) NOT NULL default '0',
bio tinytext NOT NULL,
ublockon tinyint(1) NOT NULL default '0',
ublock tinytext NOT NULL,
theme varchar(255) NOT NULL default '',
commentmax int(11) NOT NULL default '4096',
counter int(11) NOT NULL default '0',
newsletter int(1) NOT NULL default '0',
user_posts int(10) NOT NULL default '0',
user_attachsig int(2) NOT NULL default '0',
user_rank int(10) NOT NULL default '0',
user_level int(10) NOT NULL default '1',
broadcast tinyint(1) NOT NULL default '1',
popmeson tinyint(1) NOT NULL default '0',
user_active tinyint(1) default '1',
user_session_time int(11) NOT NULL default '0',
user_session_page smallint(5) NOT NULL default '0',
user_lastvisit int(11) NOT NULL default '0',
user_timezone tinyint(4) NOT NULL default '10',
user_style tinyint(4) default NULL,
user_lang varchar(255) NOT NULL default 'english',
user_dateformat varchar(14) NOT NULL default 'D M d, Y g:i a',
user_new_privmsg smallint(5) unsigned NOT NULL default '0',
user_unread_privmsg smallint(5) unsigned NOT NULL default '0',
user_last_privmsg int(11) NOT NULL default '0',
user_emailtime int(11) default NULL,
user_allowhtml tinyint(1) default '1',
user_allowbbcode tinyint(1) default '1',
user_allowsmile tinyint(1) default '1',
user_allowavatar tinyint(1) NOT NULL default '1',
user_allow_pm tinyint(1) NOT NULL default '1',
user_allow_viewonline tinyint(1) NOT NULL default '1',
user_notify tinyint(1) NOT NULL default '0',
user_notify_pm tinyint(1) NOT NULL default '0',
user_popup_pm tinyint(1) NOT NULL default '0',
user_avatar_type tinyint(4) NOT NULL default '3',
user_sig_bbcode_uid varchar(10) default NULL,
user_actkey varchar(32) default NULL,
user_newpasswd varchar(32) default NULL,
points int(10) default '0',
last_ip varchar(15) NOT NULL default '0',
PRIMARY KEY (user_id),
KEY uid (user_id),
KEY uname (username),
KEY user_session_time (user_session_time)
) TYPE=MyISAM;

Raven · Posted: Tue Oct 25, 2005 2:33 pm

INSERT INTO nuke_users VALUES (NULL, '', 'Anonymous', '', '', '', 'blank.gif', 'Nov 10, 2000', '', '', '', '', '', 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, '0', 0);

That will get it added but the system assumes that Anonymous is user_id 1. What I would do is this. Use phpMyAdmin and assign whatever user has user_id 1 a new number. Just make it the very next number in sequence. Then, modify Anonymous to be uder_id 1.

scriptleek · Hangin' Around Joined: Oct 19, 2005 Posts: 40

Hi Raven, i tried your INSERT but didn't work then i get a sql error about column 1 thingy...so below the nuke_users table of my phpnuke v7.8 patched 3.1.

#
# 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 default '',
`username` varchar(25) NOT NULL default '',
`user_email` varchar(255) NOT NULL default '',
`femail` varchar(255) NOT NULL default '',
`user_website` varchar(255) NOT NULL default '',
`user_avatar` varchar(255) NOT NULL default '',
`user_regdate` varchar(20) NOT NULL default '',
`user_icq` varchar(15) default NULL,
`user_occ` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_interests` varchar(150) NOT NULL default '',
`user_sig` varchar(255) default NULL,
`user_viewemail` tinyint(2) default NULL,
`user_theme` int(3) default NULL,
`user_aim` varchar(1 Cool

default NULL,
`user_yim` varchar(25) default NULL,
`user_msnm` varchar(25) default NULL,
`user_password` varchar(40) NOT NULL default '',
`storynum` tinyint(4) NOT NULL default '10',
`umode` varchar(10) NOT NULL default '',
`uorder` tinyint(1) NOT NULL default '0',
`thold` tinyint(1) NOT NULL default '0',
`noscore` tinyint(1) NOT NULL default '0',
`bio` tinytext NOT NULL,
`ublockon` tinyint(1) NOT NULL default '0',
`ublock` tinytext NOT NULL,
`theme` varchar(255) NOT NULL default '',
`commentmax` int(11) NOT NULL default '4096',
`counter` int(11) NOT NULL default '0',
`newsletter` int(1) NOT NULL default '0',
`user_posts` int(10) NOT NULL default '0',
`user_attachsig` int(2) NOT NULL default '0',
`user_rank` int(10) NOT NULL default '0',
`user_level` int(10) NOT NULL default '1',
`broadcast` tinyint(1) NOT NULL default '1',
`popmeson` tinyint(1) NOT NULL default '0',
`user_active` tinyint(1) default '1',
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_lastvisit` int(11) NOT NULL default '0',
`user_timezone` tinyint(4) NOT NULL default '10',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) NOT NULL default 'english',
`user_dateformat` varchar(14) NOT NULL default 'D M d, Y g:i a',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(1) NOT NULL default '0',
`user_notify_pm` tinyint(1) NOT NULL default '0',
`user_popup_pm` tinyint(1) NOT NULL default '0',
`user_avatar_type` tinyint(4) NOT NULL default '3',
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`points` int(10) default '0',
`last_ip` varchar(15) NOT NULL default '0',
`karma` tinyint(1) default '0',
`user_allow_arcadepm` tinyint(4) NOT NULL default '1',
`user_group_cp` int(11) NOT NULL default '2',
`user_group_list_cp` varchar(100) NOT NULL default '2',
`user_active_cp` enum('YES','NO') NOT NULL default 'YES',
`user_ip` varchar(15) NOT NULL default '',
`user_lastlogin` varchar(12) NOT NULL default '',
`user_hits` varchar(11) NOT NULL default '0',
`user_lastlogindate` varchar(12) NOT NULL default '',
`user_lastlogintime` time NOT NULL default '00:00:00',
`user_flag` char(1) NOT NULL default '0',
`user_flagdate` varchar(12) NOT NULL default '',
`user_status` char(1) NOT NULL default '0',
`custom1` varchar(255) default NULL,
`custom2` varchar(255) default NULL,
`custom3` varchar(255) default NULL,
`custom4` varchar(255) default NULL,
`custom5` varchar(255) default NULL,
`custom6` varchar(255) default NULL,
`custom7` varchar(255) default NULL,
`custom8` varchar(255) default NULL,
`custom9` varchar(255) default NULL,
`custom10` varchar(255) default NULL,
`custom11` varchar(255) default NULL,
`custom12` varchar(255) default NULL,
`custom13` varchar(255) default NULL,
`custom14` varchar(255) default NULL,
`custom15` varchar(255) default NULL,
`custom16` varchar(255) default NULL,
`custom17` varchar(255) default NULL,
`custom18` varchar(255) default NULL,
`custom19` varchar(255) default NULL,
`custom20` varchar(255) default NULL,
`custom21` varchar(255) default NULL,
`custom22` varchar(255) default NULL,
`custom23` varchar(255) default NULL,
`custom24` varchar(255) default NULL,
`user_show_custom1` tinyint(2) NOT NULL default '1',
`user_show_custom2` tinyint(2) NOT NULL default '1',
`user_show_custom3` tinyint(2) NOT NULL default '1',
`user_show_custom4` tinyint(2) NOT NULL default '1',
`user_show_custom5` tinyint(2) NOT NULL default '1',
`user_show_custom6` tinyint(2) NOT NULL default '1',
`user_show_custom7` tinyint(2) NOT NULL default '1',
`user_show_custom8` tinyint(2) NOT NULL default '1',
`user_show_custom9` tinyint(2) NOT NULL default '1',
`user_show_custom10` tinyint(2) NOT NULL default '1',
`user_show_custom11` tinyint(2) NOT NULL default '1',
`user_show_custom12` tinyint(2) NOT NULL default '1',
`user_show_custom13` tinyint(2) NOT NULL default '1',
`user_show_custom14` tinyint(2) NOT NULL default '1',
`user_show_custom15` tinyint(2) NOT NULL default '1',
`user_show_custom16` tinyint(2) NOT NULL default '1',
`user_show_custom17` tinyint(2) NOT NULL default '1',
`user_show_custom18` tinyint(2) NOT NULL default '1',
`user_show_custom19` tinyint(2) NOT NULL default '1',
`user_show_custom20` tinyint(2) NOT NULL default '1',
`user_show_custom21` tinyint(2) NOT NULL default '1',
`user_show_custom22` tinyint(2) NOT NULL default '1',
`user_show_custom23` tinyint(2) NOT NULL default '1',
`user_show_custom24` tinyint(2) NOT NULL default '1',
PRIMARY KEY (`user_id`),
KEY `uid` (`user_id`),
KEY `uname` (`username`),
KEY `user_session_time` (`user_session_time`),
KEY `karma` (`karma`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table 'nuke_users'
#

Thnx;
Scriptleek.

Raven · Posted: Tue Oct 25, 2005 3:01 pm

- That's because you now have a VERY modified users table! Compare your schema with the one that came with your version. The solution I gave you will work but it was based on the [mis]assumption that the query you posted was what your system was actually using. Now, probably you will need to export any record that you have, clone it, modify the clone user_id and username and reinsert it.

scriptleek · Hangin' Around Joined: Oct 19, 2005 Posts: 40

Hello Raven, thnx for your time..

If i understood well i delete this nuke_users table and reinstall the original nuke7.8 one..or am i saying stupid things now..? Sad

I was planning to do this earlier but first i seeked some advice.. and ofcourse to learn from it.
I wondered, if this can be done i can enter the information of the existing users in the fresh and empty users add from the Admincontrolpanel..isn't it?
Let me know ok.. my site is pretty young of existance so i only have 17 users till now so can be done Smile

Thnx;
Scriptleek.

scriptleek · Hangin' Around Joined: Oct 19, 2005 Posts: 40

Ok i deleted the nuke_users in the database and i installed the original nuke_users tabel, that came with phpnuke 7.8, to the database. I register the user that i want to add.. also to see if everything works.. and when i click the activationlink in the email i get the following error on my webpage:

ERROR
Unknown column 'custom1' in 'field list'

and when i check the database nothing is added..lol..now i only have the anonymous user but no new users heheh.

Am i overlooking something here..concerning the error?

Laterzz..
Scriptleek.

Raven · Posted: Tue Oct 25, 2005 7:16 pm

That would indicate that your Your_Account module is no longer in sync with your database. You need to restore your original Your_Account module now that you have restored the original table.