VBulletin Errors - SQL Server Is Missing

Discussion in 'vBulletin' started by Dubz, May 15, 2008.

0
  1. #1
    I'm getting about 40-50 of these a day when I moved to a new dedicated server.

    Another issue is; if you login and click on the home part of the forum it says you're logged out when you aren't. Also sometimes you login and it shows you aren't on main page. Now go to any sub forum and it shows you're logged in. I'm confused has anyone gotten this?

    Rob
     
    Dubz, May 15, 2008 IP
  2. royo

    royo Peon

    Messages:
    173
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Is that the exact error you are getting, "SQL Server is Missing"?

    The second thing may be related to the use of www. on your forums or cookies.
     
    royo, May 15, 2008 IP
  3. Dubz

    Dubz Peon

    Messages:
    1,859
    Likes Received:
    156
    Best Answers:
    0
    Trophy Points:
    0
    #3
    1 of many possible examples:

    Database error in vBulletin 3.6.4:

    Invalid SQL:

    UPDATE session
    SET lastactivity = 1210815504, location = '/forum/forumdisplay.php?f=6', inforum = 6, inthread = 0, incalendar = 0, badlocation = 0
    WHERE sessionhash = 'b2566c7eae44bfcf85f26341d25c14ba';

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Date : Wednesday, May 14th 2008 @ 08:38:57 PM
    Script : http://www.bloggeries.com/forum/forumdisplay.php?f=6
    Referrer : http://www.bloggeries.com/forum/
     
    Dubz, May 15, 2008 IP
  4. snakeair

    snakeair Notable Member

    Messages:
    1,743
    Likes Received:
    198
    Best Answers:
    4
    Trophy Points:
    280
    #4
    I got this one all day yesterday. Today i don't get this and i made no coding changes. What i think was causing me to get the database error was Hostgator upgrading the server i am on to the latest PHP and MYSQL version's.

    Took about 48 hour's since they started the upgrade till things got better for my forum. Have you got this message again today? You really should contest your host and vbulletin to see if they can provide any information.

    Also you really should think about upgrading your vbulletin forum software since more bug's and security fix's have been made since you last upgraded. This just a suggestion that's all. Just pretend i didn't mention it.
     
    snakeair, May 15, 2008 IP
  5. Dubz

    Dubz Peon

    Messages:
    1,859
    Likes Received:
    156
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I had my SQL timeout at 60 and I set it to 90 and it's fixed I'd say 90% of the errors. Just as going from 20 to 60 solved a tone as well. I had an issue logging in where I logged in but then showed me as not logged in. If you click any forum it shows you as logged in... I would of thought it was a timeout except it could occur in a row so who knows. Odd to say the least.
     
    Dubz, May 21, 2008 IP