Thanks Brf. I’ve not made any changes to the database, and have only one disabled user … there were a couple of spam users when I had the default spam protection, but this is happening with new topics now.
Code: Select all
SELECT poster_id FROM phpbb_posts WHERE poster_id NOT IN(SELECT user_id FROM phpbb_users WHERE user_type <> 2)
phpbb_
change it in the query accordingly.My point was your "NOT IN" part is including user_type 1 also. You should also exclude the user_type 1 users
Hi. This has brought up about 30 rows. Should I delete these from the database, or maybe better find all non active users and delete them in the PHPBB admin console?
Use the ACP, direct database editing should be kept to a minimum and only done by those who know exactly what they are doing and can repair any errors resulting from their action.
Hi
So it does sound like it’s a bug?I installed phpBB (version 3.3.4) on my local network, did nothing but create a forum, and two users to test the bug, and the same bug happened.