Mysql error

Discussion in 'Programming' started by DeMoN4e, Mar 25, 2009.

  1. #1
    I have litle problems with mysql database, i'm using vbulletin platform and i when i like to post an new thread it shows me an eror 2006 how to fix it...

    Invalid SQL:

    SELECT template
    FROM template
    WHERE templateid = 1414;

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Wednesday, March 25th 2009 @ 05:42:04 AM
    Error Date : Wednesday, March 25th 2009 @ 05:42:10 AM
    Script : http://www.prevzemaj.com/newreply.php?do=postreply&t=6879
    Referrer : http://www.prevzemaj.com/showthread.php?p=10682#post10682
    IP Address : 67.159.44.138
    Username : demoNche
    Classname : vB_Database
    MySQL Version :

    Pleace help :S
    Thanks
     
    DeMoN4e, Mar 25, 2009 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    it seems your query returns too many results and mysql server goes down
     
    crivion, Mar 25, 2009 IP
  3. ads2help

    ads2help Peon

    Messages:
    2,142
    Likes Received:
    67
    Best Answers:
    1
    Trophy Points:
    0
    #3
    Try contacting vB support or your host?

    - ads2help
     
    ads2help, Mar 25, 2009 IP
  4. boompie

    boompie Peon

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Agreed.
    Try adding a LIMIT statement to that specific query.

    But anyway, it's not a good sign of the DB capabilities.

    Carl
     
    boompie, Mar 25, 2009 IP
  5. it career

    it career Notable Member

    Messages:
    3,562
    Likes Received:
    155
    Best Answers:
    0
    Trophy Points:
    270
    #5
    Restart your mysql service.
     
    it career, Mar 26, 2009 IP