How to check Colliding Usernames? SQL

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
mikego
Registered User
Posts: 3
Joined: Tue Oct 17, 2017 10:29 pm

How to check Colliding Usernames? SQL

Post by mikego » Mon Dec 11, 2017 3:18 am

I have colliding usernames in my database. How can I check which usernames are colliding? What should I type in phpMyAdmin?

Thanks in advance!

User avatar
david63
Jr. Extension Validator
Posts: 13402
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: How to check Colliding Usernames? SQL

Post by david63 » Mon Dec 11, 2017 6:15 am

What are "colliding usernames"?
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

mikego
Registered User
Posts: 3
Joined: Tue Oct 17, 2017 10:29 pm

Re: How to check Colliding Usernames? SQL

Post by mikego » Mon Dec 11, 2017 7:42 am

Duplicate usernames, identical like:
username 1: John
username 2234: John

I had a problem with colliding usernames when i convert my forum. Error massage:
Tue Oct 17 20:20:08.303708 2017] [proxy_fcgi:error] [pid 22536] [client xxxxxxxx] AH01071: Got error 'PHP message: PHP Fatal error: Call to a member function error() on null in xxxxxxxxxxxxxxxxxxxxx/install/convertors/functions_phpbb20.php on line 1906\n', referer: xxxxxxxxxxxx/install/app.php/convert/in_progress/phpbb20?current_table=0&skip_rows=11678

This is the code in that file:
$convert->p_master->error('<span style="color:red">' . $user->lang['COLLIDING_USERNAMES_FOUND'] . '</span></b><br /><br />' . $list . '<b>', __LINE__, __FILE__);

User avatar
AmigoJack
Registered User
Posts: 5055
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: How to check Colliding Usernames? SQL

Post by AmigoJack » Mon Dec 11, 2017 9:54 am

Seems like the converter is broken, as it should already check first for duplicate names. Via SQL you could query

Code: Select all

SELECT username, user_id
  FROM phpbb_users
 WHERE username IN
 ( SELECT username
     FROM phpbb_users
    GROUP BY username
   HAVING count( username )> 1
 )
to see which accounts need to take care of. phpBB 3.x doesn't even allow similar usernames, so this approach may not resolve everything. Seeking help at the converter development should be more promising.
The worst thing about censorship is ███████████

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: Bermudez, Davethejunky, detection, gillyflower, invenio, UXgizmo and 31 guests