Sophia Posted May 22, 2011 Share Posted May 22, 2011 I have two questions: - If I go into the database and manually change the ID of a product from say 31 to 3, would I break anything? - At one point in the distant past, when I was still "playing" with WHMCS, I created (too) many products. Even though I deleted them, WHMCS continues the count. Now, when I create a new one, it gets an id well into the 30's or so. Is there a way to start the counter at the "next" number, which should be around 5 or 6? Thanks I'm only being a neat buff, that's all. 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted May 23, 2011 Share Posted May 23, 2011 Yes, you can use mysql to edit the next value for the auto-increment. If you already have clients with the products, then you'll need to alter the packageid on tblhosting when you alter the tblproducts (and related tables - like tblpromotions, tblproductconfiggroups etc) Unless this is *really* causing you a *problem" (rather than just triggering your unusual form of OCD) I'd suggest not bothering 0 Quote Link to comment Share on other sites More sharing options...
Sophia Posted May 23, 2011 Author Share Posted May 23, 2011 Thanks othello I did alter one of them and it went well, so being a proper NERD, I think I'll risk it :) 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.