matt4 Posted April 20, 2011 Share Posted April 20, 2011 Hi, I have quite some difficulty explaining this but here goes. I want to delete a client but not skip a id. Say if I delete client id 21 the next in the system it would jump to is 22 when I would want a new client coming to 21. How do I adjust this? Thank you, 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted April 21, 2011 WHMCS Support Manager Share Posted April 21, 2011 You'd need to edit the auto_increment value of tblclients using phpmyadmin. But I'd recommend against doing it. 0 Quote Link to comment Share on other sites More sharing options...
matt4 Posted April 23, 2011 Author Share Posted April 23, 2011 Why would you recommend against it? Does it have a potential knock on effect in the system? Thanks, 0 Quote Link to comment Share on other sites More sharing options...
matt4 Posted May 2, 2011 Author Share Posted May 2, 2011 Why? I also can only untick but not change. I want to change something so that the next client becomes 26 for example not 27. Same with invoices. Thanks, 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted May 2, 2011 Share Posted May 2, 2011 Why would you recommend against it? Does it have a potential knock on effect in the system? Screwing with the id's of records in any database can have disastrous effects if you're not 1000% sure of exactly what you are doing, which other tables are affected, how the db-server handle auto-incremements etc. 0 Quote Link to comment Share on other sites More sharing options...
matt4 Posted May 3, 2011 Author Share Posted May 3, 2011 Thanks, I won't touch them then. Will explain my mistake to my accountant when the time comes. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.