Just wondering how I can reset the user ID# after I delete and now block the spammers, I have 3 members to start so I can build the site, But the next member to join will be #95.
Just wondering if I do it in the database, and where?
Just wondering how I can reset the user ID# after I delete and now block the spammers, I have 3 members to start so I can build the site, But the next member to join will be #95. Just wondering if I do it in the database, and where? |
Yes, log into phpmyadmin, click the profiles table then click "operations".. set "auto_increment" to 4 or whatever you want the next user to be (that isn't in use). BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |
I remember when I was that obsessed with perfection... Then I found Dolphin. BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |
Just to point out. You can change the auto_increment as mscott mentioned. However. that value cannot be set to a value lower than the largest ID already in use. https://www.deanbassett.com |
thank you very much, |