Cannot delete user

[SV8Predator]

Forum using phpBB 2.0.17 .

Two spammers have registered with usernames:

gEmerson f
vAlexis j

They have been deleted via the Admin Panel but their profiles remain in the memberlist. Thus their profiles and offensive webpages are still viewable.

If I cut and paste the username and then look up user, I get the message:

"Sorry, but that user does not exist."

So I cannot delete them from the memberlist.

Is there a solution to this problem?

I feel that the "space" in the username has something to do with this?

[Wicher]

Try executing below lines in phpmyadmin:

[adrianxw]

I also have a user that I want to get rid of and cannot. When I try in admin, it says "Sorry, but that user does not exist." The name is "Gwenn (BWR ) Moring" and I assume there is something invisible there. I don't have access to the database, so can't use the suggested fix. I tried pasting the name into a hex editor and couldn't see anything. Is there anything else I could try?

To explain a bit further, (not relevent to the question really but may answer a few questions before they are asked!), the board owner is not really active, he made me, first a mod then later admin. He lives in Greece, but the board is hosted and run from another company in the US. In the past, they have had a web site where you could get help, but now they have this which is not much use to anyone, it's been like that for months. I started with the phpBB support site, but they don't support 2 anymore, well, not problems, only migration.
_________________
Wave upon wave of demented avengers march cheerfully out of obscurity into the dream.

[Wicher]

Can you upload files to the server?
_________________
My little mods | Statistics Mod 4.x.x (revision of 2.1.5) | My hacks at phpbbhacks

[adrianxw]

I doubt it. The board does not allow it, only links. How can I attempt this?
_________________
Wave upon wave of demented avengers march cheerfully out of obscurity into the dream.

[Jim_UK]

If you install the starfoxtj tookit then you will be able to delete them with that.
The reason you can not find them to delete them is that they are using code within their username that does not show visible characters.
The toolkit will zap them. If you do not have the toolkit then PM me and I will send it to you. It is a single file to upload to the root of phpBB2.

Jim

[adrianxw]

I have no access to the server.
_________________
Wave upon wave of demented avengers march cheerfully out of obscurity into the dream.

[Jim_UK]

Have you tried just taking a section of the name such as this (BWR) and inserting the * which is for anything preceding or after such as *(BWR)*
If that finds them then you can use it in User admin>management to remove them.

Jim

[Dogs and Things]

Hi Jim,

That sounds like a possibly good solution.

Greetings.

[adrianxw]

Got all excited for a moment, alas, when trying wildcarding, all I get is "Sorry, that user doesn't exist" message. I tried several wildcard solutions, including attempts using my account, each with the same result. I suppose wildcarding is a newer feature then the board has.
_________________
Wave upon wave of demented avengers march cheerfully out of obscurity into the dream.