Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

managing the image_id numbers in the database dbi file

Discussion in 'General Discussion' started by audrey, Feb 5, 2009.

  1. audrey

    audrey Well-Known Member

    Joined:
    Oct 18, 2006
    Messages:
    78
    Likes Received:
    2
    Trophy Points:
    158
    I have a question about managing the id numbers in my main VSP table,
    im_main2.

    The image_id numbers get added in the interface dbi file, by looking at
    the highest number and adding 1.

    Periodically I deactivate entries in order to provide the best interface. And then I might go in and remove
    the entries.

    That means that gaps get left in the numbering and the id numbers get unnecessarily large.

    Is there any way, using cpanel or shell or cgi scripts, to go into that table and prune the id numbers back to a pure sequential series?
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice