Lost connection on mysql

Discussion in 'MySQL' started by mlao, Nov 5, 2008.

  1. #1
    I get Lost connection on mysql. :mad: This is my Error Logs. (DBD::mysql::st execute failed: Lost connection to MySQL server during query at lib/pm.lib line 2438.
    DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at lib/pm.lib line 2439.) I dont know if this is the promlem :rolleyes: but
    how do I change max allowed packet in phpmyadmin
     
    mlao, Nov 5, 2008 IP
  2. greny

    greny Peon

    Messages:
    162
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Try to upgrade to the latest version of MySQL and also upgrade the library you use for connection.
     
    greny, Nov 6, 2008 IP
  3. mlao

    mlao Active Member

    Messages:
    321
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #3
    Im in hosting account how I can upgrade to the latest version of MySQL ?
    MySQL version is 5.0.45
    What can I do from the php myadmin?
     
    mlao, Nov 6, 2008 IP
  4. greny

    greny Peon

    Messages:
    162
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #4
    From phpMyAdmin.. nothing. Try to upgrade the library (lib/pm.lib) you use for connection. Are you programming in Ruby or PHP?
     
    greny, Nov 6, 2008 IP
  5. mlao

    mlao Active Member

    Messages:
    321
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #5
    I upgrade allready the library lib/pm.lib.:( My script is use cgi.
     
    mlao, Nov 6, 2008 IP
  6. Estevan

    Estevan Peon

    Messages:
    120
    Likes Received:
    8
    Best Answers:
    1
    Trophy Points:
    0
    #6
    hello

    lost connection is due timeout
    look in /etc/my.cnf
    connect_timeout =

    if no have add
    connect_timeout = 30
    or change the time restart mysqld and try

    best
     
    Estevan, Nov 6, 2008 IP
  7. maestria

    maestria Well-Known Member

    Messages:
    705
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #7
    Please make sure that the query you are running is correct.
    In case of a wrong query also similar error might popup.
    Can you please post your mysql query here?
     
    maestria, Nov 7, 2008 IP