"username is already being used" - User doesn't exist

[LikeableHades]

I'm having a very strange issue. On my site, if I try to create a user with a certain username (Let's call it "FriendlyName"), it gives me the error message that the username is already being used.

• Searched using the Manage Users page - No results
• SQL query: SELECT * FROM [database].mantis_user_table where username LIKE '%FriendlyName%'; - No results
• Debug code in plugin: user_get_id_by_name( $t_username ) - No results

Any ideas where I could possibly find the source of this? And ways to avoid this in the future for other users?


MantisBT Version - 2.25.1
Schema Version - 211
PHP Version - 7.4.13
Database Driver - mysqli
Database Version, Description - 8.0.37, 8.0.37

[cas]

try looking for :
SELECT * FROM [database].mantis_user_table where username LIKE '%lyN%';
perhaps that brings you closer, could be an odd character causing this.