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 |
|
|