vBulletin MySQL help

Discussion in 'MySQL' started by Colleen, Jan 7, 2006.

0
  1. #1
    I create vbulletin skins. I had a bunch of test skins which I deleted.

    Here's what I need help with. I just added a new skin and the ID assigned to it was 28, but the skin is actually 12. All those skins in between are now gone.

    So now I have to go in phpMyAdmin and change the ID myself. I don't want to always have to do this.

    Is there a query I can run for the style table to fix it so it's back to normal? So it assumes 12 was the very last skin added and give the next installed skin ID 13, not ID 29?
     
    Colleen, Jan 7, 2006 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    Change the auto increment value for the style table like so (SQL query):

    ALTER TABLE style AUTO_INCREMENT = 13
    Code (sql):
     
    digitalpoint, Jan 7, 2006 IP
    Colleen likes this.
  3. Colleen

    Colleen Illustrious Member

    Messages:
    6,777
    Likes Received:
    725
    Best Answers:
    1
    Trophy Points:
    430
    #3
    Wow, that's all there is to it? :) Nice.

    Thanks Shawn. I waited all day for you. :eek:
     
    Colleen, Jan 7, 2006 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    I'm worth it.
     
    digitalpoint, Jan 7, 2006 IP
  5. Colleen

    Colleen Illustrious Member

    Messages:
    6,777
    Likes Received:
    725
    Best Answers:
    1
    Trophy Points:
    430
    #5
    That's true... handsome devil you...

    *and he knows it... :eek:
     
    Colleen, Jan 7, 2006 IP
  6. Shoemoney

    Shoemoney $

    Messages:
    4,474
    Likes Received:
    588
    Best Answers:
    0
    Trophy Points:
    295
    #6
    DigitalPoint... good with vb, sql, and the ladies ;)
     
    Shoemoney, Jan 7, 2006 IP