Sorry, but this username has already been taken..

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
mrslim
Registered User
Posts: 19
Joined: Wed Aug 22, 2007 8:59 am

Sorry, but this username has already been taken..

Post by mrslim »

All,

I am running 'Powered by phpBB 2.0.22 © 2001 phpBB Group' and am having a very annoying issue with new user signups. When you attempt to register a new user, it takes you straight to this message 'Sorry, but this username has already been taken'.. This is without you filling out any form at all!

This is the URL you hit:

profile.php?mode=register&agreed=true

Any ideas at all? Thanks!

Dean
Last edited by ric323 on Mon Oct 15, 2007 1:26 pm, edited 1 time in total.
Reason: Topic icon changed
User avatar
jwunderly
Registered User
Posts: 5740
Joined: Sun Mar 30, 2003 2:18 pm
Location: Easton, PA (in the groove)

Re: Sorry, but this username has already been taken..

Post by jwunderly »

John (A cranky old man. "Looking for an echo ...")
using any control-panel install/update is like shooting yourself in the foot. It won't kill you, but you're really going to hobble around until it heals.
Using the wrong tools (Front Page, DreamWeaver) gives the same results
Do not PM me for Support!
mrslim
Registered User
Posts: 19
Joined: Wed Aug 22, 2007 8:59 am

Re: Sorry, but this username has already been taken..

Post by mrslim »

Thank you kindly! However.. I have tried this and get the following back:

'Error

SQL query:

INSERT INTO phpbb_users( user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd )
VALUES (
'-1', '0', 'Anonymous', '', '0', '0', '0', '1082539867', '0', '0', '0.00', NULL , '', '', '0', '0', '0', NULL , '0', '0', '1', '1', '1', '1', '0', '1', '0', '1', '0', NULL , '', '0', '', '', '', '', '', NULL , '', '', '', '', '', '', ''
);

MySQL said: Documentation
#1062 - Duplicate entry '-1' for key 1 '

Any ideas?

Dean
User avatar
jwunderly
Registered User
Posts: 5740
Joined: Sun Mar 30, 2003 2:18 pm
Location: Easton, PA (in the groove)

Re: Sorry, but this username has already been taken..

Post by jwunderly »

Please copy the Support Request Template body into a reply to this topic and complete it as fully as possible, so that we may provide assistance.
John (A cranky old man. "Looking for an echo ...")
using any control-panel install/update is like shooting yourself in the foot. It won't kill you, but you're really going to hobble around until it heals.
Using the wrong tools (Front Page, DreamWeaver) gives the same results
Do not PM me for Support!
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Sorry, but this username has already been taken..

Post by stevemaury »

Check to see if registration works now. The message means you already have an Anonymous user. So either you ran the query twice, or you have a different problem.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
mrslim
Registered User
Posts: 19
Joined: Wed Aug 22, 2007 8:59 am

Re: Sorry, but this username has already been taken..

Post by mrslim »

Thanks so much! All working! :-)
Locked

Return to “2.0.x Support Forum”