Yeah, it doesnt work. For some reason it says "The e-mail/username information submitted could not be found."Oyabun1 wrote:In the phpbb_users table check that username you were using was correct and that the user_email value is current, then use the “I forgot my password” link on the login page.
Code: Select all
SELECT user_id, username, username_clean FROM phpbb_users WHERE user_type = 3
phpbb_
if that is not your table prefix.Took me a little bit to figure out exactly how to run that query.Oyabun1 wrote:Run this SQL query and tell us the resultChangeCode: Select all
SELECT user_id, username, username_clean FROM phpbb_users WHERE user_type = 3
phpbb_
if that is not your table prefix.
Since you were already messing around in the database I assumed you knew how to at least run a query. You shouldn't make any changes directly to the database unless you know precisely what you are doing and the ramifications, because you can do serious damage to the board.Adam D wrote:Took me a little bit to figure out exactly how to run that query
Code: Select all
INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin1', 'admin1', 0, '21232f297a57a5a743894a0e4a801fc3', '[email protected]', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
[phpBB Debug] PHP Warning: in file [ROOT]/includes/utf/utf_tools.php on line 1828: strtr(): The second argument is not an array