• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 979
  • Last Modified:

How to delete all non-active users in phpBB

When trying to convert phpBB 2 to 3, I receive the following error. How can I delete them or all non-active users without selecting them one by one?
Fatal conversion error
functions_phpbb20.php [ 1859 ]
Colliding usernames were found on your old board. In order to complete the conversion please delete or rename these users so that there is only one user on your old board for each clean username.

xelnagas is the clean username for:
» user id: 22 username: XelnagaS (0 posts)
» user id: 23 username: XelnagaS (0 posts)
skuepght is the clean username for:
» user id: 21890 username: Skuepght (0 posts)
» user id: 21891 username: Skuepght (0 posts)
1 Solution
try this
mysql_query("DELETE FROM Tablename WHERE fieldname='0'");

replace tablename with the table name and fieldname with the filed name (the one that counts user's posts)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now