The Joomla Training Cohort has been launched!

Please send any feedback or bug reports to (opens new link)  

It has been discovered that the update to Joomla 3.9.16 fails if your Joomla site has duplicate usernames. This is a very rare situation which may exist due as a result of migrating users from one Joomla site to another directly in a database. In this video we'll see how to search for duplicate usernames in Joomla and how to correct them if you find any. One of the methods we try is an SQL query suggested by Joomla, but so far I have been unable to get that to work. Here are some links mentioned in this stream:




  • Video demonstrates how to find and correct duplicate usernames in Joomla.
    - Issue with duplicate usernames causing problems in Joomla 3.9.16 update.
    - Duplicate usernames can arise from importing content or migrating sites.
    - Tutorial focuses on small sites or manual username adjustments.
    - Users can change usernames individually or sort/filter in backend.
    - SQL query provided to identify duplicate usernames in database.
    - Transcription includes troubleshooting attempt using SQL query.
    - Mention of a potential plugin by Joomla Gig for detecting duplicates.
    - Search for plugin not successful, potential solution found in an extension shared by John Molehole.

Monday Maintenance 131


😴👌Watch Me Work live streams ►    • Find and Replace ...  

Here are some of the links mentioned in this Live Stream - and some others:

Contact Tim Davis ► This email address is being protected from spambots. You need JavaScript enabled to view it.

Joomla Training Cohort ► ►

MigrateMe 4 ►

Stageit for Joomla ►    • First Look at Sta...  

Backing Up Your Joomla Site with Akeeba ►    • How to Backup a J...  

Better Frontend Link ►

FOLLOW US ON TWITTER! ► @basicjoomla

Like Us On FaceBook! ►

Interesting blog? Like it on Facebook, Post it or share this article on other bookmarking websites.

Written by:
Tim Davis is the founder and owner of Cybersalt.
Log in to comment

Add comment