Inactive users on my phpbb3 board

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
McWilliam554
Registered User
Posts: 1
Joined: Mon Feb 11, 2019 9:08 am

Inactive users on my phpbb3 board

Post by McWilliam554 » Mon Feb 11, 2019 9:11 am

I had 45K inactive users on my phpbb3 board. Went on to delete them from mysql (erased all that had user_new=1). Now I can't login, and the board shows no forums.

No idea how to get all the forums and the login back without resorting to restore the database. It would be good to know why this happen if I only erased inactive users.

User avatar
KevC
Support Team Member
Support Team Member
Posts: 68681
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Inactive users on my phpbb3 board

Post by KevC » Mon Feb 11, 2019 9:13 am

That was a really bad idea to delete directly from the database. The accounts are referenced in more than just one table.

Did you back up the database before you deleted them? If not, contact your hosts and see if they have a recent back up to reinstall
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51556
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Inactive users on my phpbb3 board

Post by Brf » Mon Feb 11, 2019 2:15 pm

McWilliam554 wrote:
Mon Feb 11, 2019 9:11 am
Went on to delete them from mysql (erased all that had user_new=1).
If you had removed a user manually from the NRU group, their user_new flag would never be set to 0. You likely did that with your own account if you registered it, and then used the original admin account to remove it from the NRU.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50065
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Inactive users on my phpbb3 board

Post by stevemaury » Mon Feb 11, 2019 4:37 pm

Try this:

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.

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_jabber, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin1', 'admin1', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@example.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');
Change your table prefix if it is not phpbb_

See Executing SQL Queries in phpMyAdmin if you are unfamiliar with running database queries.

As soon as you have done this, use the temporary admin account to change the details on the original admin account, then delete the temporary account.
This is because:
  1. anyone could use that account to log in to your board if you didn't change the password.
  2. this temporary user has not been fully set up (e.g. it is not a member of the "Registered users" group, so it won't have normal access to your forums).
To remove the account you will first need to remove ???founder??? status from it: ACP > USERS AND GROUPS tab > Manage Users > Admin1 > Overview > Founder = No
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)

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: canonknipser and 30 guests