can't find username/email...

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

can't find username/email...

Post by runehints »

the board wont allow me to sign in, reset password, or reactivate the account.

The board also has not updated with the database... what is going on?
narqelion
I've Been Banned!
Posts: 7235
Joined: Sat Dec 13, 2008 5:00 pm
Contact:

Re: can't find username/email...

Post by narqelion »

Scusi? What board? Where? Could you please provide just a tad bit more information? :P
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

http://forums.runehints.com

user name is gaogier email is gaogier@runehints.com

if you look at the forums, its still in 2007, but if you click on the forum, ie, news and announcements you will see all the topics/posts...
narqelion
I've Been Banned!
Posts: 7235
Joined: Sat Dec 13, 2008 5:00 pm
Contact:

Re: can't find username/email...

Post by narqelion »

Yes...I still do not understand your problem. The user is clearly an admin and appears listed in multiple groups so where exactly are you looking that you cannot "find them" ? :? Is English your native language?
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

Yes. I am british.

however if you try and reset your password via I forgot my password, you will see what I mean.
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52298
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: can't find username/email...

Post by Brf »

That looks like a bad conversion.
The very first Forum shows the Last Post made in 2007, but if I go into the forum itself and ignore the Announcements, I see a bunch of 2009 and 2008 posts by yellow-named users. Then no posts at all in 2007. Then some posts in 2006 by user #2, with a red-name, instead of the yellow-name that is shown in 2008 and 2009.
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

So, what should be done? or can be done?

This was before I tried to merge my two post/thread tables...

However it has gotten worse.

Please advise?



Explaining what has happened.

Forums got pruned, and as I was looking through to restore the database, I deleted the backup. The next oldest backup is 2 years old.

I have a topic open here, http://www.phpbb.com/community/viewtopi ... &t=1873145 and my plans seems like it could work. However, the forums wont allow me to login. and is not showing the correct data, as you have seen.
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

sorry, this is kind of urgent to me... anyone know how to access the account?
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

Sorry for yet another "bump" post, this problem is still not fixed, and I really want it fixed... :P
User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: can't find username/email...

Post by HGN »

Since you restored a two year old back-up your password and e-mail adress of two years ago are restored.

You might use the Support Tool Kit to modify your password or create a new admin account.
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

I have another account on the forums, however, how can I make it admin?
User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: can't find username/email...

Post by HGN »

HGN wrote:You might use the Support Tool Kit to modify your password or create a new admin account.
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

I can't login...?
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51888
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: can't find username/email...

Post by stevemaury »

In phpmyadmin, run the following, which will create an admin user named admin1 with a password of admin. From that point you should be able to get into the ACP. Change your table prefix if it is not phpbb_.

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', 'admin@yourdomain.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

I am in...

How can i fix my forums?

You can check here, http://forums.runehints.com
Locked

Return to “[3.0.x] Support Forum”