PHP Bulletin Board Home
News About Home
Features of phpBB Test drive phpBB Downloads Support for phpBB The phpBB Community Styles for customising phpBB 3rd party modifications to phpBB

Support Home | Knowledge Base Home | Submit Article | Search Articles | Browse Articles
 How to fix "Username already taken" error 
Description: This fix will cure the error
Author: Anon
Date: Fri May 06, 2005 7:00 am
Type: Fix
Keywords: Username,taken,-1,register,error
Category: Miscellanea
You may have been getting errors that say "Sorry, that user name is already taken.", even before you get to the screen that lets you type in a username!

What? What's going on you might ask!?!

A common cause of this is the guest user has been deleted in the SQL database. This could be from many things, but we won't go into details.

1. Log into a Database admin tool. This is genrally through the tool "phpMyAdmin", however your webhost may have a different tool for this use.

2. Get to the Database.

3. [phpMyAdmin] Click the SQL tab, so you can copy and paste the following code into the "execute command" box:

Code:
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, '', '', '', '', '', '', '');


4. Click go, and it will attempt to execute the command.


If you get any errors at all, or if it does not cure the problem, please post in the correct support forum.

Happy Foruming Very Happy

Username: Password:
News | Features | Demo | Downloads | Support | Community | Styles | Mods | Links | Merchandise | About | Home
 © Copyright 2002 The phpBB Group.