Gap in user id's

General questions relating to Joomla! 3.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Joomla! Apprentice
Joomla! Apprentice
Posts: 21
Joined: Thu Aug 25, 2005 9:11 pm

Gap in user id's

Post by JonathanB » Wed May 08, 2019 9:15 pm


I have noticed that all my user id's are in sequence then suddenly there is a jump from 782 to 4433 with no user id's in between. I have checked the users table and the usergroup_map tables and none of the ids in-between those are there. Is there a way to reset the auto increment to continue in order as i have search the complete db and cant find anywhere where this is possible or where the missing ID's might be (sorry can only do the basic's in the DB)

Last edited by toivo on Wed May 08, 2019 9:48 pm, edited 1 time in total.
Reason: mod note: moved, not related to 3.x ACL

User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 117
Joined: Thu Sep 01, 2011 7:26 am
Location: Athens, Greece

Re: Gap in user id's

Post by Pnkr » Thu May 09, 2019 8:12 am

i dont think that you can change that and honestly... why bother??
there is no problem with that.

User avatar
Joomla! Champion
Joomla! Champion
Posts: 5775
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Gap in user id's

Post by AMurray » Fri May 10, 2019 11:54 pm

The ID number doesn't really mean anything to the front-end user, and is really only used to identify the user in the background. They wouldn't be numerical since the Super User for instance uses a specific ID number, and not simply the next in sequence when you created it and also if you delete users, the remaining records are not re-sorted according to that user ID field.
A Murray
Millennium Falcon - it's the ship that made the Kessel run in less than 12 parsecs! The fastest hunk of junk in the galaxy.



Return to “General Questions/New to Joomla! 3.x”