Not Solved [How To?] Change new UIDs in database
#1
Not Solved
Everything was fine with my board 'till a previous Admin with Cpanel access changed last uid from 150 to 5000.

This lead all new users to have uid 5001,5002,5003... etc.

I want to rever back to uid=150 to fill this hole, but I'm afraid db engine will keep reading the highest uid value and increment it.

How can this be fixed?
Reply
#2
Not Solved
you may have to manually change the new higher UIDs to normal UIDs and
modify auto_increment value depending on the last UID (see this reply)
Reply
#3
Not Solved
(2017-07-21, 09:58 AM).m. Wrote: you may have to manually change the new higher UIDs to normal UIDs and
modify auto_increment value depending on the last UID (see this reply)

Done, the problem is that UIDs now are back to 5000+

I've edited latest uid and turned it to 150, then edited auto_increment to 150.

I created a test account and, after joining, an SQL error has been returned warning about missing fields. It had uid = 150

2 additional test accounts have been created and these last 2 have uid with 5000+
Reply
#4
Not Solved
The AUTO_INCREMENT value holds the next index that will be assigned - increment it by adding 1 and try again.
devilshakerz.com/pgp (DF3A 34D9 A627 42E5 BC6A 6750 1F2F B8AA 28FF E1BC) ▪ keybase.io/devilshakerz
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)