vBulletin 3.8.3 Upgrade…

Okay, gonna go ahead and upgrade the Digital Point Forums to vBulletin 3.8.3… Since so many of you are freaks and are on it 24/7, I made this post to keep you up to date on what’s going on (I’ll update it periodically throughout the process). You can also use this blog post as the new temporary forum for all your discussion needs while I do the upgrade. hah

  • 3:26 am – Reading and posting seems to work… I suppose that’s good enough for now (still working on the other stuff, but don’t need to force everyone off to do it).
  • 3:24 am – Skimming over various areas of the forum to see if things (mostly) work. I could let you guys in before the templates are fully updated possibly.
  • 3:22 am – New moderator permissions set
  • 3:17 am – Static CSS files located on single server in web cluster and spread around properly (I hate this about vBulletin BTW… gimme a hook location to do it please!)
  • 3:09 am – Core upgrade done.
  • 3:07 am – Recoded some of the upgrade scripts so they aren’t making that change to the reputation table. Will deal with issue this later instead.
  • 3:00 am – Stupid reputation table was altered in 3.8.0 to not allow negative userids so it can accommodate 4 billion users instead of “only” 2 billion. Stupid. I used negative userids internally for some stuff. /thinking what to do about this…
  • 2:55 am – First problem… reputation table alterations not going well. Going digging in raw database…
  • 2:50 am – Running “ALTER TABLE pmtext” on DB servers. That’s a big one… going to get another beer.
  • 2:49 am – Up to version 3.8.0 alpha 1
  • 2:43 am – It’s almost 3am. If you are a cute girl reading this, please post your picture in the comments, k thanks.
  • 2:41 am – I forgot we have to go through all versions to get to the newest… lol… going through 3.7.0 beta 4 at the moment.
  • 2:40 am – Userlist rebuilding
  • 2:36 am – Watching DB servers alter thread table for tagging support… (this is really boring)
  • 2:34 am – Watching DB servers alter thread table for prefix support… /bored
  • 2:30 am – New PHP files in place and synced across web server cluster
  • 2:29 am – DB backup done
  • 2:27 am – Thinking I might not have enough beer for this…
  • 2:25 am – DB backup still running (it’s huge… many, many, many gigs)
  • 2:18 am – Got beer and craisens
  • 2:17 am – Backing up DB
  • 2:13 am – Making this post

236 thoughts on “vBulletin 3.8.3 Upgrade…”

  1. Haha, I’ve been using DP as an excuse to keep me up all night, avoiding the movie I have sitting in my DVD player…now I have a reason, at almost 5 30 in the morning, to go watch it!

    Thanks, you’re the best! lol

  2. Damn!!!

    ..and I’d just finished preparing a post asking why my site isn’t PR11 and if anyone wanted to part with oodles of cash for it ๐Ÿ™‚

    Hope the upgrade goes smoothly… rather you than me eek!

  3. Finally DP will be upgraded……I’m sure everyone will love it….got any more updates???Maybe installing a few vb plugins?

  4. wooho, finally it’s gonna happen..

    I am surprised = what is the reason for you being so active now a days and that too suddenly !!!!!!!!! ๐Ÿ˜ฎ ๐Ÿ˜€ :p

  5. No idea how long it will take… hopefully not all night. Gonna go as quick as possible, I promise.

    @GoScript – actually it’s heavily modified, just with stuff you don’t see. ๐Ÿ™‚

  6. @Tanuj – there are already hundreds of custom plug-ins (I wrote) that keep things running (relatively) smoothly and efficiently. It’s far from a stock install…

  7. Thank you for the upgrade Sean!

    I hope it doesnt make the loading of the site slower or anything………

    Digitalpoint is a wonderfull place ๐Ÿ™‚

  8. Cool about the upgrade tho, any chance we can get a rough idea on how long with will take? It’s prime UK time here.. Ta

  9. hey Ninja ,
    i see u are upgreading the forums , it’ll be good if u keep our post safe …..u have a great ninja mission ….take care Shawn and thank you so much

    Morocco Webmaster

  10. wooho, he is replying too…
    I already see some gr8 changes of DP search..

    will there be a new design too ? ๐Ÿ˜€ atleast new logo plz :p

  11. Thats a great new Shawn , Please make the banning system little lighter . I am banned on DP and cannot Access my account there forever because I made multiple accounts an year ago but I used only one account and after a long time i got banned ๐Ÿ™ all my contribution went to waste

  12. I think this post will get the most comments ever in the history of wordpress if you keep the forum down for more…

    Can u count how long will u go?

    or lets create the history ๐Ÿ˜€

  13. Today Digital Point was running grate since morning. Just now I couldnโ€™t make a comment. Hope the software update procedure will be done soon :).

  14. Hey Shawn,
    I hope you won’t be high and screw up our Usernames/passwords ๐Ÿ™‚ Please be careful when you drink beer and typing on this DP server ๐Ÿ™‚ We trust you but can’t trust the beer you are sipping. Anyway Cheers. Waiting for DP to be online…

  15. Well great job Shawn, It will be more secure and I hope we get some new features too ๐Ÿ™‚ , Upgrading will be a big challenge for you because there are millions of posts.

    Good Luck Shawn!

  16. This blog comment thread is going be the biggest in history. I think it will reach 500 comments in one day. Who else wants to guess the comment total for one day?

  17. Yes Shawn, I am damn sure this post will get over 100 Comments depends on Work and Beers.

    Only 100 ???

    I think it will get over 1000 comments in 2 hours only… :p

  18. Shawn is there a way to contact you personally? Actually I sent many emails and PM’s but got no answer. Maybe this is the best way to contact you. I am very old on your forum but banned due to a very small mistake. I apologized many times on forum with different user but always again banned by MOD’s. Even my younger brother on forum requested to un-ban me but sadly he also got banned and the reason told user can’t use anyone’s account. My old user were very close to my heart and everybody knows me with that nick. Can you help me by unban my old account? it was: stormy

    It was obviously my mistake and I again really apologize for the reason I got banned. I shall be very very thankful to you.

  19. And he seems doing more things
    – upgrading
    – drinking
    – approving and replying comments – strange !!!

    Is it Shawn for sure or a coworker.. :eek coz he was never so active.

  20. congratulatioins for the upgrade ๐Ÿ™‚
    i’s daytime here, why you didn’t upgrade it while i was sleeping (in your daytime) :D:D:D

    good luck pal!

  21. [QUOTE]It’s almost 3am. If you are a cute girl reading this, please post your picture in the comments, k thanks.[/QUOTE]
    Finally drunk I guess ๐Ÿ˜‰

  22. so when the server will up back? .. so bored cause everyday i logged to digitalpoint forums do some research. I hope server will upback successfull after Upgrade.

  23. Weee, hundreds of custom plug-ins (you wrote). That gonna be pain in the $$$ to modify it and get it work with the new Version 3.8.
    Get ride on that baby genius

  24. @ Shawn – Probably , I didn’t realize that there is a huge database running ; I know you’ve worked on it . Its not so easy to run such a big db . Cheers!!

    @ Shawn the Admin – Can’t you use a different name? its so f*ckin confusing…..

  25. abay ma k loray ma chod dii hai gandoo shawn tune digitalpoint kii

    infractions pay infractions atay rehteee hai gando terii takar ka ek forum banaonga na main tera pora forum lund hojayega koi bhi nahi hoga waha pay samjha

    mader chood teri ma ko chodo

  26. Seems it is almost done…

    Hope we will see some performance improvement as well

    @bohra – that picture was really nice, is that you ?

  27. Looks like you slept before completing the upgrade? Please update us. I see in the footer vBulletinยฎ v3.7.0 Beta 2

  28. Hmmm… Sooooo many comments here… ๐Ÿ™‚
    We are going to set a NEW WORLD record!:p

  29. You do realise that your blog is going to suffer under the weight of all those DP’ers:)

    Maybe you should start on the coffee, I think it’s going to be a long night for you.


    Picture of nice lady for you…..

  30. Great News, DP is updating. I hope we will get rid of those DB issues now.

    But its really boring without DP right now. I can realize how much you are bored doing this @Shawn ๐Ÿ™‚

  31. wooho, 100 comments reaches..
    I never received 100 comments in my 1 year old blog.. ๐Ÿ˜ฎ

    Aloha !!!!!!!!!!! Bravo Shawn Hogan !!!

  32. cool…great to see Admin back on DP..

    DP needed the software upgrade..

    Have upgraded vB several times..However once or twice my forum got into a complete mess..:P

    Hope nothing of that kind happens now..

    Thanks Shawn…:)

  33. lol. I was freaked out. I use Dialup and it takes forever to load a page.

    When I visited DP today, the page was not loaded but the title was “Digitalpoint Forums”. I was really freaked out when I saw that. Because that’s what you see when you get banned :o. I was waiting for the page to load so that I can see the “Ban reason” and the deadline. ๐Ÿ˜€

    lol. Thanks Shawn for the upgrade. Hope all the DB errors gets fixed.

  34. I think people will start making ebooks on
    “how to make money of Shawn’s forum upgrade – Buy now ”
    “viral marketing with Shanw’s upgrade” lol ๐Ÿ˜†

  35. Well I would post my pic but it looks like you’ve already proposed to someone else.. :p

    But in the event that doesn’t work out, I can bend like a pretzel (LMFAO!).

  36. look at the footer on dp now
    ” vBulletinยฎ v3.8.3, Copyright ยฉ2000-2009, Jelsoft Enterprises Ltd. ”

    woila.. congrats dp community, beer time..

  37. i think full upgrade will take lots of time i mean all features of dp to be back to normal… but with the basic version it may come online fast

  38. @ Shawn the Admin

    Would you mind not to remove the footer links on your fashionsmash blog? Because this theme was made by me and I didn’t allow to remove footer links.

    @ Shawn

    Accept my request or am gonna cry soon.

  39. The number of comments have already crossed 100 mark! ๐Ÿ™‚

    Hopefully, we would see some visibly exciting features on our forum!
    How much time more for completion…Shawn? ๐Ÿ™



  40. for a second i thought i was banned from DP!
    but later after a clear look, i understood what had happened
    god my heart is strong!

  41. Hello Shawn.. ,

    Great news for DP, finally updating….

    btw where is your cat?


  42. Well its Good that shawn is upgrading , 2 months back we are also facing problems in opening Dp – Its Good that the Admin of Dp is taking Great step in Clearing the Things UP , Best of luck , Hopefully at night things are get back to original spots ๐Ÿ˜€

  43. @Love – if you are a real life girl, wanna go out on a date? (you don’t have to use pretzel skills… just dinner.) ๐Ÿ™‚

  44. @Shawn,
    what about the PMs?
    will our PM’s remain or will we loose them?
    what about itrades?
    should we start building them from the start?

  45. Shawn, i think u need to update the template to the 3.8.3 version as the new things added will then only be visible to users, like profiles page and stuff

  46. @abhijit – I’m sure it should all be there, but I’m gonna be working on getting it all up to par/updating backend code I’m sure… weee…

  47. @Shawn, I’m really a girl, but I’m halfway around the world (Philippines, to be exact). I would have loved dinner though. =(

  48. Database error in vBulletin 3.8.3:

    Invalid SQL:

    INSERT INTO regimage
    (regimagehash, imagestamp, dateline)
    (‘f648cb7b3125749c7e145f447ff0e6d6’, ‘Cj6P4J’, 1248431362);

    MySQL Error : Table ‘forums.regimage’ doesn’t exist
    Error Number : 1146
    Request Date : Friday, July 24th 2009 @ 03:29:22 AM
    Error Date : Friday, July 24th 2009 @ 03:29:22 AM
    Script : http://forums.digitalpoint.com/newthread.php?do=newthread&f=19
    Referrer : http://forums.digitalpoint.com/forumdisplay.php?f=19
    IP Address :
    Username : digitech
    Classname : vB_Database_Slave
    MySQL Version :

  49. @Shawn

    Okies kool my 7 day ban expires tom too bad i have to wait otherwise i would have reported problems ๐Ÿ™‚

    Eventhough u should probably fix the contact us page email to a email u check

  50. I really think we need to reconsider the child porn and age of consent laws. Horny is horny no matter what your age.

  51. lol shawn….see how she reacts…she even doesn’t bother to accept your offer. let me visit doctor to change my sex ๐Ÿ˜›

    P.S please unban my account if you have spare time. stormy

  52. Shawn,

    is there anyway i can get my account unbanned and my wifes account unbanned? pretty please as they are the ones that we really want and the others i told mods about and banned me like little bullies.

  53. @Qadsl – I don’t even know who you are, how can I unban you? lol I like girls, not girls that used to be guys.

    @Love – is your boyfriend going to shoot me or anythiing? ๐Ÿ™‚

  54. OMG!!
    Shawn is doing it atlast.
    My bad I couldn’t enjoy it since I got banned.
    Shawn, could you please review my ban and reinstate me?

  55. Shawn is a busy guy….How about dinner with me ๐Ÿ˜› but sorry you gonna pay the bill…I am not like shawn ๐Ÿ˜€

  56. @Shawn, lol umm not sure how to answer that, but let’s just say by the time we have dinner I’ll be completely boyfriend-free ๐Ÿ˜›

  57. @ Shawn, It’s my new nick on your forum due to got banned few months back. I never got any warning and ban were forever. I sent few PM’s to my clients and MOD’s banned thought maybe am spamming. I am on your forum for last 5 years. My old nick is stormy and new one is qadsi. Can you please unban my old account because that was worth more then this new account. I spent few part of my life on DP but no body considered to accept my request. I even sent emails to support @ dp but got no response. Then my brother (ahsanw) made a post and requested to unban me but MOD banned him too. I love DP and respect all ….I didn’t really mean to spam seriously. So please consider my request and unban my account: stormy

  58. @Qadsl – bug me about when when I’m not in the middle of something… don’t really have the time to go digging at the moment, sorry.

    @Love – ditch him! ๐Ÿ™‚

  59. Shawn i think the best would be u use the vbulletin 3.8.3 default template for time bieng and then convert that into green version

    That way the task would be easy for u

  60. @ Shawn, Can I have your cell phone? Sometime telling other DP members that I have talked with Shawn….will make me proud lol ๐Ÿ˜› Or Love* can i have yours hahahaha.

  61. @ Shawn, we’ve just been together 3 months so it’s not anything I can’t get myself out of. ๐Ÿ˜›

    & @ Abboodeh, lol, I see you on the forum all the time! ๐Ÿ™‚

  62. @digitech – I have a gf? Since when? Who is she? Is she cute?

    @Qadsl – right.

    @Love – Ah, okay then… ๐Ÿ™‚

  63. @ digitech, Don’t get ahead of yourself now, it’s just dinner that could very possibly not happen anyway since we are worlds apart. LOL I’m not gonna ask him to do anything. ๐Ÿ˜›

    & @ QuadsI, my number is available for $1,500 via Paypal (send payment as gift). If interested, PM me. ๐Ÿ˜›

  64. Really… who is this gf I have, I’d love to meet her. She’s probably very angry at me for neglecting and ignoring her all these years.

  65. @ Shawn, Would you like to visit Pakistan? I want to invite you. Seriously not kidding. Many webmasters would like to meet you here. We will pay your all tour expense.

  66. @Love*, I better spend this money to visit your country and tell everything to your boy friend ๐Ÿ˜›

    I know shawn not gonna be your next long term boy friend. He changes everything very soon…..saw he changed vb version also ๐Ÿ˜›

  67. huh? May be I was on wrong track.. Just browsing your gallery and that thought came in mind.
    Who’s Alison btw?, I very good friend I guess.

    @Love.. don’t forget to post some pics of your dinner at DPF.

  68. this place is turning into a dating hub…
    oh goss… webmasters are flirty too.. never expected this from the Shawn himself ๐Ÿ˜€

  69. Testimonial:

    Shawn were always helpful in finding the right girl. We are not happy couple (QadsI + Love*). Thanks shawn ๐Ÿ˜›

  70. Shawn,

    may i speak to you regarding some matters? i would like to get them resolved if possible and quickly.

  71. The update was long overdue, thanks Shawn. BTW, will you consider installing vBSEO for the forum sometime in the future?

    – MENJ

  72. vBSEO did wonders for my forum, I am sure it can do the same for DP. Besides, those SEO permalinks look pretty instead of that ugly default PHP urls :mrgreen:

    – MENJ

  73. Have you noticed how well the forum ranks for everything already by chance? ๐Ÿ™‚

    #1 search term for the forum: “hottest girl in the world” lol

  74. Haha…now thats an interesting search keyword. No doubt DP is the best-ranked forum there is on the net ๐Ÿ™‚

    – MENJ

  75. Please Shawn,

    At least give me your e-mail id so that I can present myself before you. I am completely innocent and wish to convey the same to you!



  76. Thanks for everything shawn. New version is cool. I hope one day DP will be ranked on “sex” lol ๐Ÿ˜› isn’t it your wish?

  77. Hi

    Following the rules that say you should let a moderator/admin know if you’re on a shared account, I sent you a PM about two weeks ago detailing the fact that I was afraid my account (username “WPressDesign”) would be banned because of a possible shared IP issue. You assured me via PM you put a note for the other moderators so I wouldn’t get banned and I thanked you. I didn’t break any rules but today I got this (screenshot):


    I really don’t know this “idotemplates” guy. It’s not my account. I only had one account: [B]WPressDesign[/B] and it got banned.
    I beg of you: I followed the rules, was extremely careful, treated my clients with respect on the link sales forum.
    I had to make another temporary account just to write you this because there’s no other way to let you know. I hope this won’t get banned until you’ll give me a reply.
    Please, if you can, unban my account. I don’t know what to do. i have open business with some people, people that owe me money and I owe them services. I need to close those deals.
    I thought that if you said you put a sign near my username I wouldn’t get banned because of the shared IP issue.
    What should I do now? DP is my workplace, the way I earn my living. ๐Ÿ˜

    Awaiting your response.

    best regards


    PS: in case this account gets banned too until I receive a reply from you, please send me an e-mail to [email protected]
    Thank you in advance.

    PPS: the account that I made to PM you about this issue also got banned in a jiffy. What did I do wrong?

  78. Shawn my dp id is jalpari , today is 20 Aug 2009 and i can not login into my account also i do not get any infraction notice while option is selected.

    You have been banned due to infractions.
    Date the ban will be lifted: Aug 19th 2009, 9:42 pm

  79. whats up dudes! this is an fabulous online forum. I’m adjoubods and I am seeking experiences that is related to FB inception.

    Did any one heard of that? For now, I have browse through only good things about it, however I need to find out your own thought about it.

    Any type of help is definitely appreciated.

    Thanks alot : )!
    – adjoubods

Leave a Reply

Your email address will not be published. Required fields are marked *